The basic concept of InfluxDB for InfluxDB Learning

I. Compare nouns in traditional databases with nouns in nfluxDB Concepts in traditional databases Database tables in measurement database A row of data in the table points table

II. Unique concepts in InfluxDB

1) database-database, this database concept is the same as traditional database.

2) measurement--data table. In InfluxDB, measurement is the role of table, which is consistent with the role of table in traditional database.

1) tag--tag. In InfluxDB, tag is a very important part. The table name +tag together serve as the index of the database, in the form of "key-value."

2) field--data, field is mainly used to store data, but also in the form of "key-value."

3) timestamp--timestamp, as a time-series database, timestamp is the most important part of InfluxDB. When inserting data, you can specify it yourself or leave it blank for the system to specify.

Note: When inserting new data, a space separates tag, field, and timestamp.

4) series-series, all the data in the database, need to be displayed through the chart, and this series represents the data in this table, which can be drawn as several lines on the chart.

5) Retention policy-Data retention policy, which can define the duration of data retention. Each database can have multiple data retention policies, but only one default policy.

6) Point--Point, which represents the data of a field under a certain condition at a certain time in each table, because it is a point on the chart, so it is called point.

1）Point

Point consists of time stamp, data (field) and tags.

Point is equivalent to a row of data in a traditional database, as shown in the following table:

A concept in a traditional database time for each data record is the primary index in the database (automatically generated)fields recorded values (attributes without indexes) i.e. recorded values: temperature, humidity tags indexed attributes: area, elevation

All the data in the database needs to be displayed through a chart, and this series represents the data in this table, which can be drawn as several lines on the chart: calculated by arranging and combining tags.

As follows:

>show series from cpukeycpu,cpu=cpu-total,host=ResourcePool-0246-billing07cpu,cpu=cpu-total,host=billing07cpu,cpu=cpu0,host=ResourcePool-0246-billing07cpu,cpu=cpu0,host=billing07cpu,cpu=cpu1,host=ResourcePool-0246-billing07cpu,cpu=cpu1,host=billing07cpu,cpu=cpu10,host=ResourcePool-0246-billing07cpu,cpu=cpu10,host=billing07cpu,cpu=cpu11,host=ResourcePool-0246-billing07cpu,cpu=cpu11,host=billing07cpu,cpu=cpu12,host=ResourcePool-0246-billing07cpu,cpu=cpu12,host=billing07cpu,cpu=cpu13,host=ResourcePool-0246-billing07cpu,cpu=cpu13,host=billing07cpu,cpu=cpu14,host=ResourcePool-0246-billing07cpu,cpu=cpu14,host=billing07cpu,cpu=cpu15,host=ResourcePool-0246-billing07cpu,cpu=cpu15,host=billing07cpu,cpu=cpu16,host=ResourcePool-0246-billing07cpu,cpu=cpu17,host=ResourcePool-0246-billing07cpu,cpu=cpu18,host=ResourcePool-0246-billing07cpu,cpu=cpu19,host=ResourcePool-0246-billing07cpu,cpu=cpu2,host=ResourcePool-0246-billing07cpu,cpu=cpu2,host=billing07cpu,cpu=cpu20,host=ResourcePool-0246-billing07cpu,cpu=cpu21,host=ResourcePool-0246-billing07cpu,cpu=cpu22,host=ResourcePool-0246-billing07cpu,cpu=cpu23,host=ResourcePool-0246-billing07cpu,cpu=cpu3,host=ResourcePool-0246-billing07cpu,cpu=cpu3,host=billing07cpu,cpu=cpu4,host=ResourcePool-0246-billing07cpu,cpu=cpu4,host=billing07cpu,cpu=cpu5,host=ResourcePool-0246-billing07cpu,cpu=cpu5,host=billing07cpu,cpu=cpu6,host=ResourcePool-0246-billing07cpu,cpu=cpu6,host=billing07cpu,cpu=cpu7,host=ResourcePool-0246-billing07cpu,cpu=cpu7,host=billing07cpu,cpu=cpu8,host=ResourcePool-0246-billing07cpu,cpu=cpu8,host=billing07cpu,cpu=cpu9,host=ResourcePool-0246-billing07cpu,cpu=cpu9,host=billing07