Multi-dimensional data query method and device

Abstract

The invention discloses a multi-dimensional data query method and device, and relates to the technical field of computers. A specific embodiment of the method comprises the following steps: establishing a dimension retrieval table according to a fact table and a dimension table related to the fact table, and adding a composite index of the dimension retrieval table; according to at least one dimension query condition in the query request, performing query in a dimension retrieval table by utilizing the composite index, and determining a target data primary key; and according to the target dataprimary key, inquiring the fact table to obtain data needing to be inquired in the inquiry request. According to the embodiment, a dimension retrieval table is adopted; according to the technical scheme, the method has the advantages that the data can be quickly retrieved only by creating a small amount of indexes in the dimension retrieval table, the number of the indexes is not increased alongwith the increase of the number of dimensions, the dimension retrieval table can be used for uniformly managing the dimension data, and the dimension management complexity is reduced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a multidimensional data query method and device. Background technique [0002] In order to observe the data from multiple angles and sides, so that users can have a deep understanding of the information and connotation contained in the data, multi-dimensional data analysis technology came into being. Multidimensional data analysis refers to various analysis operations on data organized in a multidimensional manner to perform data analysis. As a component of multidimensional data analysis technology, multidimensional data query technology has important research value. [0003] At present, there are three common ways to query multi-dimensional data: (1) create an index on the dimension field of the original fact table, and improve the efficiency of data query through the index; (2) build a multi-dimensional data cube, that is, summarize the fact table by dimension, Generate a m...

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventors found that there are at least the following problems in the prior art: 1. Various indexes need to be created in the method (1), causing a large number of indexes to occupy a large amount of resources, reducing the efficiency of updating the fact table, and Increase the difficulty of management; 2. In the method (2), if the dimension of the data is too high, the cubes established will be relatively sparse, requiring a large amount of storage resources and lack of economy; 3. The calculation cost of the method (3) is high, and the calculation Resources grow with the growth of data volume, even higher than the growth rate of data volume, and will encounter performance bottlenecks; 4. In method (1) and method (3), dimension data is stored in their respective fact tables, and from their respective fact tables The data is summarized according to the dimensions, and the unified management of dimension data cannot be realized.

Images