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

摘要

An OLAP precomputed model, an automatic modelling method, and an automatic modelling system. The model comprises: a dimension module, an aggregate group module, and a measurement module. The method comprises: compiling statistics of data of all data sources to produce a statistic compilation resu determining a service model on the basis of a user-defined data model and of a query preview with respect to a target query; performing a query preview with respect to a sample and collecting query statistics; performing physical modeling and defining the dimensions, measurements, and an aggregate group of a precomputed model; producing a service modeling resu and producing the precomputed model. The system comprises: a data statistic compilation module, a service model module, a query statistics module, and a model creating module. The described solution, by adding a derived dimension and an aggregate group, performs more effective combination of precomputed dimensions, reduces redundant computation and data storage, and provides increased computational efficiency and reduced storage occupancy, thus acquiring improved effects in big data multidimensional analysis applications.