Time series data storage method and device, time series data query method and device, equipment and storage medium

Abstract

The invention discloses a time series data storage method and device, a time series data query method and device, equipment and a storage medium, and relates to the technical field of computers. The time series data storage method comprises the following steps: receiving a storage instruction of the time series data, extracting the data of the time series data in the storage instruction and firstindex information, the first index information comprising a policy identifier of a storage policy of the time series data, the storage policy being used for indicating retention durations of the datain a database, and at least two storage policies having different retention durations corresponding to each other; and writing the data and the first index information into a table of a database. According to the time series data storage method, as different storage strategies of time series data are created in a database, and the time series data with different retention durations are correspondingly stored under different storage strategies, the time series data can be automatically deleted after expiration, and automatic management of the time series data with different retention durationsis realized, and manual maintenance is not needed, and the updating efficiency of the database is improved.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a storage method, query method, device, equipment and storage medium for time series data. Background technique [0002] Time series data refers to a series of data indexed by the time dimension, which describes the measurement value of the measured subject at each moment within a time range. [0003] The above-mentioned time-series data is generally stored in a relational database or a non-relational database to support the continuous high concurrency of time-series data, massive data writing, generally no update, and low-latency query. As for the update of the time series data stored in the above-mentioned database, generally, technicians modify and delete part of the time series data in the database in a targeted manner. [0004] For the Internet of Things (IoT) edge, due to the limited resources of the device, the time-series data in the database is endowed w...

AI Technical Summary

Problems solved by technology

[0004] For the Internet of Things (IoT) edge, due to the limited resources of the device, the time-series data in the database is endowed with timeliness. Therefore, it is often necessary to delete a large amount of expired time-series data in the database. At this time, artificial The way of maintenance will lead to low efficiency of updating the database

Images