I’m just beginning to work with database - InfluxDB 2.4 and have a few beginners questions.
I have sensor information (see screenshot) I want to migrate to an InfluxDB Database
Queries I’m going to make are for instance
- All entities with their value in a certain room
- All values of a certain entity in a timeperiod
- All sensors from a certain type in a room with their value
What would be the best structure of the DB. I’m thinking
- Measurement: Entity_ID
- Tags: Room, Source, Type and Kind
But I’m not sure about the measurement, maybe the entity_id should be a tag?
And is the number of tags necessary, or should that be reduced to be more efficient.
Thx for any advice