Hello!
Currently, we store weather sensor data in two collections:
- sensor_data collection, where each document has the fields:
- sensor_id: ObjectID
- timestamp: datetime
- temperature: float
- wind_speed: float
- sensor_features collection, where information about the sensors are stored:
- sensor_code: string
- latitude: float
- longitude: float
I think maybe this data could fit better in a time-series collection. However, I have the following concerns, due to our limited storage resources:
-
If I store the sensor characteristics (sensor_features) in the time-series metadata field, would I lose storage space due to duplication? MongoDB keeps reference internally to this metadata (instead of repeating it for several data-points) ?
-
How hard is to update this metadata or add new fields, compared to a normal collection? We may need it once every month.
-
The only way to remove old data is by TTL (automatic removal)?