Unlock instant, AI-driven research and patent intelligence for your innovation.

Time-series data aggregation query method, system, device and storage medium

A time series data and query method technology, applied in the field of data processing, can solve the problem of not allowing one-by-one comparison, and achieve the effect of shortening the processing time

Active Publication Date: 2021-11-30
XIAN THERMAL POWER RES INST CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in practical applications, it is necessary to complete complex queries in the shortest time, and it is possible to encounter measurement points with a time accuracy of milliseconds, so one-by-one comparison is not allowed

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 query method, system, device and storage medium
  • Time-series data aggregation query method, system, device and storage medium
  • Time-series data aggregation query method, system, device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0057] The invention belongs to the technical field of data processing, and specifically judges query options submitted by users; judges the linear monotonicity of input expressions; divides each sub-expression to form a linear inequality group composed of linear inequalities; proposes For the coefficients of linear inequalities, call Hatchyan's algorithm to judge whether the linear inequalities have a solution; through the linear monotone judgment of complex query expressions, it solves how to judge the correctness of the expression grammar and how to judge the expression in the expression Whether it is linear is judged, different situations are separated for processing, and the processing time is shortened; the application of the Hatchyan algorithm in the present invention is optimized to shorten the processing time.

[0058] to combine figure 1 As shown, the first object of the present invention is to provide an aggregate query method for time series data, the specific meth...

Embodiment

[0072] Such as Figure 1-2 As shown, the aggregation query method of time series data, the specific method includes:

[0073] Provide historical data query and calculation functions under complex conditions, and input query conditions in the form of expressions;

[0074] Query and count the historical values ​​of the target measuring points under the condition that the value range of multiple measuring points is satisfied, for example, the average boiler efficiency in the last 30 days under the condition that the calculated active power is not less than 300MW and the plant power consumption rate is less than 9%. value;

[0075] Query and count the historical values ​​of the target measuring points in multiple time intervals, such as calculating the average power consumption rate of the previous working week and the previous working week, and the data that occurred on weekends during the period is not within the statistical range;

[0076] The arithmetic mean value of multipl...

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 an aggregation query method, system, equipment and storage medium of time series data, belongs to the technical field of data processing, and judges the query options submitted by users; judges the linear monotonicity of input expressions; Carry out division to form a linear inequality group composed of linear inequalities; propose the coefficients of the linear inequality group, and call the Hatchyan algorithm to judge whether the linear inequality group has a solution; through the linear monotone judgment of the expression of the complex query, it is solved. Judging the correctness of the expression grammar and judging whether the expression is linear or not, separate out different situations for processing, and shorten the processing time; optimize the application of the Hatchyan algorithm in the present invention, and shorten the processing time.

Description

technical field [0001] The invention belongs to the technical field of data processing, in particular to an aggregation query method, system, equipment and storage medium of time series data. Background technique [0002] In the field of data processing technology, the current real-time database's processing method for statistical value queries needs to calculate the interpolation values ​​per second and then substitute them into expressions one by one for calculation. However, in practical applications, it is necessary to complete complex queries in the shortest time, and it is possible to encounter measurement points with a time precision of milliseconds, so one-by-one comparison is not allowed. Therefore, it is necessary to reduce the processing scope and reduce the calculation time. Contents of the invention [0003] In order to solve the problems in the above solutions, the present invention provides an aggregate query method, system, device and storage medium for ti...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2458
CPCG06F16/2474
Inventor 王毅马瑞瑞何清王奕飞何新
Owner XIAN THERMAL POWER RES INST CO LTD