A fast query method for massive dynamic data with different time granularity

A technology of time granularity and dynamic data, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as long response time, achieve the effect of increasing stability, improving query speed, and speeding up query speed

Inactive Publication Date: 2017-01-18
芜湖大学科技园发展有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a fast query method that satisfies massive dynamic data of different time granularities, to solve the problem of long response time when massive data is directly queried in the prior art database

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
  • A fast query method for massive dynamic data with different time granularity

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] Embodiment 1, the primary data is summarized according to the minimum time granularity, and written into the secondary database.

[0026] Start the data processing module, obtain the database structure from the configuration file, select the table to be operated, and click the "Start" button, then the program will summarize each batch of data according to the query index, and the current summary results will be displayed in a table. This process is repeated until the data is written to the secondary database using the "Output" function and then re-aggregated.

[0027] After using "Output", the system will store the summarized data in the secondary database with the minimum query time granularity, and at the same time clear the summarized data to restart the calculation of the summary. Repeat this process.

Embodiment 2

[0028] In embodiment 2, the query is performed by specifying indicators according to different time granularities.

[0029] Start the query statistics module, display the query interface, select different query time granularity, select the query index, select the query region and generator, etc., execute the "query" function, the system will correctly display the results of the query execution, and pass the results through the table display in other forms.

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 massive dynamic data fast query method meeting different time granularity requirements. The method includes that data in a primary data base is taken out in batches, the minimum time granularity is used as the unit, different batches of data are collected according to query indexes, collected data is written into a secondary data base, and query is executed on the secondary data base. Due to the fact that query data quantity is small, query time can be greatly shortened, and a query requirement is met.

Description

technical field [0001] The invention relates to the field of data analysis and statistical methods in power system databases, in particular to a fast query method for massive dynamic data satisfying different time granularities. Background technique [0002] After the dynamic data generated by the electric power enterprise is analyzed, in order to perform statistics and query on the data, the data is continuously saved in the database. It is necessary to query and count the data in the database by day, month, quarter and year. Due to the continuous increase of data, the year-long data is actually massive data, and the response time of direct query is long, which is difficult to meet the requirements. Contents of the invention [0003] The purpose of the present invention is to provide a fast query method for massive dynamic data satisfying different time granularities, so as to solve the problem of long response time in direct query of massive data in databases in the pri...

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): G06F17/30
CPCG06F16/2453
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