InfluxDB: basic concepts of InfluxDB and basic concepts of influxdb

InfluxDB: basic concepts of InfluxDB and basic concepts of influxdb

InfluxDB and traditional databases have many differences in concept. This article will introduce some basic concepts in InfluxDB. For more details about InfluxDB, see the InfluxDB series tutorial directory.

InfluxDB technology exchange group: 580487672 (click to join)

I. Comparison with nouns in traditional databases

Terms in influxDB	Concepts in traditional databases
Database	Database
Measurement	Tables in the database
Points	A row of data in the table

 

Ii. concept exclusive to InfluxDB 1) Point

Point consists of time, field, and tags.

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

Point attribute	Concepts in traditional databases
Time	Each data record time is the primary index in the database (will be automatically generated)
Fields	Various record values (attributes without indexes), that is, the recorded values: Temperature and Humidity
Tags	Various indexed attributes: region, altitude

2) series

All the data in the database needs to be displayed through charts. This series represents the data in this table, and several lines can be drawn on the chart: sorted and combined by 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

For more information about the concept of InfluxDB, see the following articles at the Linux University.

For more details about InfluxDB, see the InfluxDB series learning tutorial directory.

InfluxDB technology exchange group: 580487672 (click to join)