A new olap pre-calculation system and method for generating pre-calculation results
A pre-computing and new technology, applied in computing, instrumentation, electrical digital data processing, etc., can solve problems that cannot satisfy users' changing query scenarios, and achieve the effect of improving query efficiency
Active Publication Date: 2019-12-27
SHANGHAI KYLIGENCE INFORMATION TECH CO LTD
View PDF3 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0006] The technical problem to be solved by the present invention is: the existing pre-calculation system can only perform pre-calculation according to a combination of dimensions, which cannot meet the changing query scenarios of users
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0037] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.
[0038] Such as figure 1 As shown, what Embodiment 1 of the present invention provides is a novel OLAP pre-computing system, which includes: a query statement statistical analyzer, a dynamic dimension combination generator, and a pre-calculation result usage rate monitor;
[0039] The query statement statistical analyzer is used to receive the input query statement, and perform statistical analysis on the query statement; Precomputed dimension combinations for statement matching;
[0040] The dynamic dimension combination generator is configured to generate an optimal dimension combination corresponding to the query statement and an optimal combination ranking corresponding to the optimal dimension combination when ...
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
Login to View More Abstract
The present invention relates to a novel OLAP pre-calculation system and a method for generating pre-calculation results. The OLAP pre-calculation system includes: a query statement statistical analyzer, a pre-calculation result generator, and a pre-calculation result usage rate monitor; and also relates to a The method includes: performing statistical analysis on the query statement; judging whether there is a matching pre-computing dimension combination according to the statistical analysis results, if not, generating a matching pre-computing dimension combination; finally according to the matching pre-computing dimension combination to obtain Expected query results, or if there is no matching combined dimension, query results directly from the source data. The present invention analyzes the optimal dimension combination expected by the statement, dynamically generates the pre-computation result of the corresponding dimension combination, and improves the query efficiency of subsequent identical or similar queries. As the number of user queries increases, the pre-calculation results more and more meet the query requirements. The query efficiency is higher.
Description
technical field [0001] The invention belongs to the field of OLAP pre-calculation information, in particular to a novel OLAP pre-calculation system and a method for generating pre-calculation results. Background technique [0002] In the Internet era of data explosion, the scale of data collected by people is getting bigger and bigger, and the classification of collected data is getting more and more detailed. How to effectively use these data, mine potential laws in the data, and finally give forward-looking guiding opinions has become an urgent problem to be solved. [0003] Data collection in the era of big data has the characteristics of only increment without modification, that is, historical data is often not revised, and new data is only added continuously. The OLTP (online transaction processing) adopted by traditional data warehouses is not suitable for this scenario, especially when the amount of data is extremely large. The fundamental reason is that OLTP is des...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/00
CPCG06F16/244G06F16/2465G06F16/254
Inventor 施继成李扬韩卿
Owner SHANGHAI KYLIGENCE INFORMATION TECH CO LTD