Multi-dimensional data cube generation method, device and system

Abstract

The invention discloses a multi-dimensional data cube generation method, device and system. The method comprises the steps of collecting query data in an analysis engine, wherein the query data comprises model information, dimension information, measurement information and time granularity involved in query; performing statistical analysis on the query data, and determining construction information of a multi-dimensional data cube, including a recommendation model, a recommendation dimension combination, a recommendation metric and a recommendation time granularity; and constructing a multi-dimensional data cube according to the construction information. According to the technical scheme disclosed by the invention, the automatic generation of the Cube is realized, and the problems of dimension loss, time granularity non-correspondence and low Cube hit rate possibly existing in the manual autonomous creation of the Cube are solved.

Description

technical field [0001] The invention relates to the technical field of big data processing, in particular to a method, device and system for generating a multi-dimensional data cube. Background technique [0002] A multidimensional data cube (Cube) is a fact-based and dimension-based data collection established to meet the needs of users for data query and analysis from multiple perspectives and levels. Generally, it is a data collection of the same business theme. In the prior art, Cube is mainly used for data processing in an online analysis engine (OLAP), which stores indexes and results through pre-computing technology to achieve high performance during query. In the existing technology, since the OLAP engine does not have the management capability of Cube, in actual use, the combination of dimensions in Cube requires manual input or report input as a condition, but the above method is set by the technicians according to the needs of various business scenarios , if the ...

AI Technical Summary

Problems solved by technology

[0003] 1. The quality of the Cube created by the user is not high, there are missing dimensions, the time granularity does not correspond, and the Cube hit rate is low;

[0004] 2. The versatility of Cubes created by users is not enough, resulting in a low calling rate of some Cubes;

[0005] 3. Since there is no complete Cube construction process, it is impossible to schedule and complement the Cubes created by users

Images