Database data storage method and device, electronic equipment and storage medium

Abstract

The invention relates to a database data storage method and device, electronic equipment and a storage medium, and the method comprises the steps: firstly obtaining measurement point data sent by target equipment, the measurement point data at least comprising a storage position parameter, a measurement point value and a storage mode identifier; then determining a target row and a target column in a database according to the storage mode identifier and the storage position parameter, and finally determining a target storage position according to the target row and the target column. And storing the measuring point value and the data type of the measuring point value to the target storage position according to the storage mode corresponding to the storage mode identifier, so that the data type and the measuring point value can be correspondingly stored.

Description

technical field [0001] The present invention relates to the technical field of data transmission, and in particular, to a database data storage method, device, electronic device and storage medium. Background technique [0002] In industrial interconnection, the storage of time series data of equipment measurement points is mostly stored in time series database and HBase database. Since the underlying data stored in HBase database can only be stored in binary form, when accessing data of other data types When the data is converted to binary form, it will be converted into binary form, and then stored in the HBase database. In the process of converting the data to binary, the data will lose the expression of the original data type. If you want to query the data from the HBase database , it is often impossible to know the original data type of the queried data, and the later application cannot distinguish the data type of the data obtained from the HBase database. SUMMARY OF...

AI Technical Summary

Problems solved by technology

[0002] In the industrial interconnection, the storage of time series data of equipment measurement points is mostly stored in time series database and HBase database. Since the underlying data stored in HBase database can only be stored in binary form, when accessing data of other data types In the process of converting the data into binary, the data will lose the expression of the original data type. If you want to query data from the HBase database , it is often impossible to know the original data type of the queried data, and the later application cannot distinguish the data type of the data obtained from the HBase database

Images