Lindorm:Data model

Element

Description

table

A time series table stores data of the same type. For example, you can create a time series table to store monitored data that is generated by air quality sensors.

tag

A tag is used to describe a data source. In most cases, a tag value remains unchanged over time. For example, you can create tags for a sensor based on information such as the ID of the sensor and the region where the sensor is deployed. A database in LindormTSDB automatically indexes tags and allows you to query data based on tags in a multi-dimensional manner. A tag consists of a tag key and a tag value. A tag key and a tag value must be of the STRING data type.

When you define a time series table, you can explicitly specify a rule based on which data sharding on multiple nodes is performed by specifying a tag column as the primary key of the table. This way, the performance of your business can be improved.

timestamp

A timestamp indicates the point in time when a row of data is generated. You can specify the timestamp of data when you write data to LindormTSDB. The system can also automatically generate the timestamp of the data that is written to a table.

field

A field describes a metric of a data source. In most cases, field values change over time. For example, you can create fields for a sensor based on information such as temperature and humidity. You are not required to create a fixed schema for field columns before the corresponding time series table is created. You can add or delete a field column when your business is running. A field consists of a field key and a field value. A field key must be of the STRING data type. For more information about the data types supported by field values, see Data types.

data point

A data point is a field value that is generated by a data source at a point in time. When you query data in a database or write data to a database, the number of data points is used as a statistical metric.

time series

A time series is generated based on a metric that you specify for a data source. The values of the metric change over time. A time series is determined by tags. Time series data can be calculated based on operations such as downsampling, aggregation, and interpolation. You can aggregate time series data by using multiple functions, such as sum aggregate functions, count aggregate functions, max aggregate functions, and min aggregate functions. The operations are performed based on data in a time series. When a database stores data, the database stores data that is in the same time series in the same table. This helps increase the efficiency of accessing time series data and supports LindormTSDB in time series-data compression.

In a time series table, a time series consists of data rows that have the same tag values.

Operation

Description

aggregation

Aggregation refers to operations such as grouping, counting the number of, and calculating the sum of data points in one or more time series.

downsampling

If the time range for your query is large and the sampling rate of your raw data is high, you can perform downsampling to reduce the display precision of your query. For example, if your raw data is sampled at a granularity of seconds, you can perform downsampling in your query to sample the data at a granularity of hours. This way, you can reduce the number of data points in your result set.

interpolation

If no data points are collected in a specific time window in a time series, you can perform interpolation to fill values.

TTL

Time to live (TTL) is a validity period during which your data is retained. If the validity period of your data elapses, the data is removed. By default, data is retained in a permanent manner.