Design of Influxdb Database Structure

InfluxDB 2
1

I would like to ask the expert to take a look at our database design ideas. We have tens of thousands of devices, each with multiple sensors. The data collection time of each sensor ranges from 1 second to 1 hour, and each sensor stores the measured values and reception time. The current approach is to assign a measurement to each sensing point ID, which includes a measurement attribute (v) and a receiving time attribute (atm), with the time attribute used to record the collection time. _Tag is also the ID of the sensing point. Please give some suggestions, thank you very much!!!

2

I’m not sure I understand your design. Can you provide an example of the line protocol you would write?

Here’s my guess at what you may mean:

Sensor5,_Tag=Sensor5,v=SomeMeasurementAttribute atm=1747858581000000000 1747858580000000000
  • The measurement is Sensor5,
  • The v attribute is a tag (so you can search and filter on it),
  • The atm receiving time is a field
  • The timestamp is the collection time (in this example, one second earlier than the receiving time)

Is this roughly what you were planning?