Source: InfluxData Documentation
Relational to Time Series Analogy
In the above example, there are 8 rows or field sets
- Field values are your data; they can be strings, floats, integers, or booleans, and, because InfluxDB is a time series database, a field value is always associated with a timestamp.
- time stores timestamps, and the timestamp shows the date and time, in RFC3339 UTC, associated with particular data.
- Fields are a required piece of InfluxDB’s data structure — you cannot have data in InfluxDB without fields. It’s also important to note that fields are not indexed.
- In general, fields should not contain commonly-queried metadata.
- Tags are optional. You don’t need to have tags in your data structure, but it’s generally a good idea to make use of them because, unlike fields, tags are indexed. This means that queries on tags are faster and that tags are ideal for storing commonly-queried metadata.
- Avoid table scan by storing the fields that matter to your queries as tags.
So the above example should be re-designed as follows:
Do you want to be a developer, and sustain a fun and meaningful IT Marketplace? Just click HERE.