Data query method and device based on pre-calculation

A data query and pre-computing technology, applied in the field of data processing, can solve the problems of low work efficiency of query results and prolonged response time of calculation amount, so as to reduce the amount of query, reduce the amount of related calculation, and improve work efficiency.

Inactive Publication Date: 2019-07-16
BEIJING GRIDSUM TECH CO LTD
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the massive amount of data stored in the OLAP system, although the multi-dimensional analysis of data in OLAP makes the data have certain logical relationships, these logical relationships may not match the user's query conditions, so , in order to ensure the integrity of the query data, it is still necessary to query each piece of data, so the amount of data to be queried is still very large. When performing related operations matching query conditions based on such a large amount of data, the huge amount of calculation will make The response time of the query is prolonged, which eventually leads to low work efficiency in obtaining query results

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
  • Data query method and device based on pre-calculation
  • Data query method and device based on pre-calculation
  • Data query method and device based on pre-calculation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the drawings, it should be understood that the invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present invention and to fully convey the scope of the present invention to those skilled in the art.

[0059] The embodiment of the present invention provides a data query method based on precomputation, such as figure 1 As shown, the method obtains the query results that meet the user's query requirements by preferentially querying the pre-calculated result table, and reduces the query amount and related calculation amount required for the user to query the original data table. For this, the embodiment of the present invention provides the follo...

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 data query method and device based on pre-computation, and relates to the technical field of data processing, which improves the working efficiency of data query. The main technical scheme includes: when a query request is received, analyzing a query condition contained in the query request; judging whether a preset query condition matched with the query condition existsin a pre-calculation result table or not, wherein a plurality of preset query conditions and a query result corresponding to each preset query condition are stored in the pre-calculation result table;and if yes, extracting a first query result corresponding to a preset query condition matched with the query condition from the pre-calculation result table. The method is mainly used for optimizingthe data query method.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a pre-calculation-based data query method and device. Background technique [0002] With the advent of the era of big data, based on the characteristics of scale, high speed, diversity and ubiquity of big data, by quickly acquiring, processing and extracting valuable and diverse transaction data and analyzing them , can provide targeted suggestions for the operation strategy planned by the enterprise. According to this, the business value based on big data analysis is immeasurable, and the subsequent data warehouse, data security, data analysis, data The commercial value brought about by technologies such as mining and other big data has gradually attracted the attention of people in the industry. Among them, the online analytical processing system (Online Analytical Processing, OLAP) is the most important application of the data warehouse system, which realizes the mult...

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 Applications(China)
IPC IPC(8): G06F16/2453G06F16/28G06F16/242
CPCG06F16/242G06F16/2453G06F16/283
Inventor 张硕
Owner BEIJING GRIDSUM TECH CO LTD
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