A database processing method and electronic device

Abstract

The present application discloses a database processing method and electronic equipment. The method includes: establishing a data relationship table according to the logical relationship of multiple data units in the multi-domain time series data, and storing the data storage table in the target database; receiving Invoking the data relationship table for the first instruction that operates on the multi-domain time-series data, and splitting the multi-domain time-series data corresponding to the first instruction according to the data relationship table to form multiple unit domain time series data, wherein the single domain time series data corresponds to the data unit; respectively performing a first operation corresponding to the first instruction on a plurality of the single domain time series data in response to the first instruction. This method can process multi-domain time-series data based on a single-domain time-series database, so as to meet various needs of users while simplifying database construction and use.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database processing method and electronic equipment. Background technique [0002] Currently, time-series databases are more and more widely used, and single-domain time-series databases are simple to construct and easy to use, which can meet various needs of users. However, single-domain time-series databases cannot handle multi-domain time-series data. In many cases, users can only use when processing some data. Multi-domain time series database. For example, when a set of latitude and longitude coordinates need to be stored in a time series database, the longitude and latitude will be stored and managed as two time series, which requires the use of a multi-domain time series database instead of a single domain time series database (such as OpenTSDB). Because the single-domain time series can only store one Metric (metric) value on each timestamp, but obviously the longitude and lat...

AI Technical Summary

Problems solved by technology

[0002] Currently, time-series databases are more and more widely used, and single-domain time-series databases are simple to construct and easy to use, which can meet various needs of users. However, single-domain time-series databases cannot handle multi-domain time-series data. In many cases, users can only use when processing some data. Multi-domain time series database

For example, when a set of latitude and longitude coordinates need to be stored in a time series database, the longitude and latitude will be stored and managed as two time series, which requires the use of a multi-domain time series database instead of a single domain time series database (such as OpenTSDB). Because the single-domain time series can only store one Metric (metric) value on each timestamp, but obviously the longitude and latitude in the coordinates are related and cannot be used separately. Since the above data cannot be processed using a single-domain time series database, it will make Data management is inflexible, and the cost of processing and maintaining data increases

Images