OLAP PRECOMPUTED MODEL, AUTOMATIC MODELING METHOD, AND AUTOMATIC MODELING SYSTEM

摘要

The present application relates to an OLAP pre-calculation model, an automatic modeling method and an automatic modeling system. The model includes a dimension module, an aggregation group module and a measure module. The method includes collecting data statistics on all data sources to obtain data statistics result, conducting query dryrun based on data model and sample queries given by a user to determine a business model, conducting query dryrun on the sample queries and collecting query statistics, carrying out physical modeling and defining dimension, measure and aggregation group of a pre-calculation model, and obtaining a business modeling result and a pre-calculation model. The system includes data statistics module, business model module, query statistics module, and model establishing modules. A more efficient combination of pre-calculated dimensions can be produced and redundant calculation and data storage can be reduced. It has greater calculation efficiency and occupies smaller storage so that a better result can be achieved in multi-dimensional analytics application of big data.