Time series data writing and reading method and device, electronic equipment and storage medium

By generating and writing row key values ​​of metadata tables and timing data tables in the timing database, the performance problems of timing databases in multi-label combination query are solved, and query efficiency and storage efficiency are improved.

CN119066091APending Publication Date: 2024-12-03BEIJING QIYI CENTURY SCI & TECH CO LTD

Patent Information

Application Number
CN202411192037.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-28
Publication Date
2024-12-03

Smart Images

  • Figure CN119066091A_ABST
    Figure CN119066091A_ABST
Patent Text Reader

Abstract

The invention relates to a time series data writing and reading method and device, electronic equipment and a storage medium. The time series data writing method comprises the steps of obtaining a measurement identifier of time series data to be written and a tag set corresponding to the measurement identifier; according to the measurement identifier and the label set, a first row key value of a preset metadata table is generated, metadata of the to-be-written time sequence data is written into the metadata table based on the first row key value, and the metadata at least comprises labels in the label set; and generating a second row key value of a preset time sequence data table based on the first row key value and the timestamp of the time sequence data, and writing the time sequence data of the time sequence data to be written into the time sequence data table based on the second row key value. Therefore, the storage space can be saved, and meanwhile, the query performance of the database and the query efficiency of the time series data are improved.
Need to check novelty before this filing date? Find Prior Art

Citation Information

Patent Citations

  • Method and apparatus for establishing secondary indexes for massive databases

    CN105608126A

  • Data statistical method and device

    CN105989076A

  • Non-fixed-point object inquiry method and device, terminal device and storage medium

    CN109325089A

  • Time series data storage method and device and time series data query method and device

    CN110297832A

  • Time series data storage method and device

    CN111813782A

Cited By

  • Multi-mode time series data processing method and system

    CN121958277A