Time series data aggregation retrieval method and device and medium

A time-series data and database technology, applied in the field of data retrieval, can solve the problems of inflexible pre-aggregation calculation trigger mechanism, difficulty in adapting to changes in retrieval conditions, and low efficiency, so as to reduce the amount of data access, improve retrieval efficiency, and facilitate stand-alone Effect

Inactive Publication Date: 2019-07-23
北京易沃特科技有限公司
View PDF7 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] According to the application and practice, the pre-aggregation calculation trigger mechanism is not flexible enough, and it is diffic

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Time series data aggregation retrieval method and device and medium
  • Time series data aggregation retrieval method and device and medium
  • Time series data aggregation retrieval method and device and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] Embodiments of the technical solutions of the present invention will be described in detail below in conjunction with the accompanying drawings. The following examples are only used to illustrate the technical solutions of the present invention more clearly, and therefore are only examples, rather than limiting the protection scope of the present invention.

[0041] It should be noted that, unless otherwise specified, the technical terms or scientific terms used in this application shall have the usual meanings understood by those skilled in the art to which the present invention belongs.

[0042] Such as figure 1 As shown, it is a database embodiment for storing time series data of the present invention, including:

[0043] The data storage module 11 is used to store time-series data in a hierarchical and fragmented manner; the time-series data includes raw data and pre-aggregated statistical data;

[0044] The data update module 12 is used to incrementally update th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a time series data aggregation retrieval method and device and a medium. The method comprises a database for storing the time series data, and comprises the steps of firstly, optimizing the time series database, adding a statistical level concept for the data storage, carrying out the hierarchical fragmentation storage of the time series data, and providing the data structure support for the optimization of the time series data aggregation retrieval; when the time series data is subjected to statistical query, applying different query algorithms according to different statistical query requests, and subjecting the time series data to the statistical query in combination with the hierarchical fragmented data storage structure. When the data is written into the database, the data only needs to be subjected to hierarchical fragmentation statistics according to the determined hierarchical fragmentation rule so as to record the data characteristics, and conditions for future query and retrieval are not considered in the writing process; during the statistical query, according to the retrieval conditions, the original data and all levels of statistical data are used, a statistical result is calculated after optimization and combination without depending on mass original data, so that the data access amount is reduced, and the retrieval efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of data retrieval, in particular to a time series data aggregation retrieval method, device and medium, and includes a database for storing time series data. Background technique [0002] In industrial production, automated detection and control systems will generate a large amount of time-related data. With the development of the industrial Internet, the demand for centralized storage and analysis of data in the cloud is increasing. It is difficult for traditional relational databases to compress and store massive time-series numerical data, and it is even more difficult to provide efficient retrieval and statistical algorithms. Time series database is a data storage system specially optimized for such scenarios. Currently, well-known products include InfluxDB and OpenTSDB. [0003] In the existing technology, the storage and query operations of time series data are extremely dependent on time stamps. The ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/2458G06F16/22
CPCG06F16/22G06F16/2462G06F16/2474G06F16/2477
Inventor 梁猛李守东涂龙
Owner 北京易沃特科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap