Query method and device suitable for OLAP query engine

Abstract

The invention provides an optimization scheme and device suitable for an OLAP query engine. The optimization scheme comprises a client agent module, a query mode matching module, a query distributed execution module and a pre-aggregation module. The query mode matching module is used for acquiring an MDX query request received by an OLAP query engine and generating at least one aggregation query set for the MDX query request based on dimension processing, and the aggregation query set comprises a plurality of aggregation query requests; and the query distributed execution module is used for carrying out parallel processing on the plurality of aggregation query requests based on an OLAP query engine to obtain a plurality of corresponding aggregation query results in a database, and the aggregation query requests and the aggregation query results are correspondingly arranged. According to the method and device provided by the invention, an efficient OLAP query execution engine can be constructed to deal with complex OLAP queries of various report systems, the execution efficiency of MDX queries can be remarkably improved, and response to analysis requests of the report systems is accelerated.

Description

technical field [0001] The invention relates to data query technology, in particular to a query method and device suitable for an OLAP query engine. Background technique [0002] How to improve the execution efficiency of OLAP queries and quickly respond to business report analysis needs has always been a hot issue for OLAP query systems. [0003] The query language commonly used in OLAP (Online Online Analysis) is MDX, and most reporting systems (including but not limited to Excel, Power BI, Tableau, MSTR, Smartbi, etc.) support the use of MDX interfaces. [0004] Currently, the industry's traditional OLAP engines that support MDX include SSAS and Mondrian. When these traditional OLAP engines encounter complex MDX queries sent by the reporting system, the response performance will be severely degraded. There are three reasons for this. First, the data exchange format of the MDX interface is XMLA, which is inefficient for data transmission. In some cases where the query re...

AI Technical Summary

Problems solved by technology

When these traditional OLAP engines encounter complex MDX queries sent by the reporting system, the response performance will be severely degraded

There are three reasons for this. First, the data exchange format of the MDX interface is XMLA, which is inefficient for data transmission. In some situations where the query result set is large, the query network transmission time is very long

Second, traditional OLAP engines execute MDX queries based on step-by-step calculations based on each MDX operator, without considering the MDX query characteristics of the reporting system for optimization

Third, the traditional OLAP engine executes MDX queries on a single machine. In the case of a large amount of query requests, the execution may be slow and memory overflow may occur.

[0005] In view of the defects in the MDX engine technology in the prior art, which makes it difficult to quickly respond to the query request of the report, no effective solution has been provided in the prior art

Images