Title:
OLAP PRECOMPUTED MODEL, AUTOMATIC MODELING METHOD, AND AUTOMATIC MODELING SYSTEM
Document Type and Number:
WIPO Patent Application WO/2018/176623
Kind Code:
A1
Abstract:
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 result; 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 result; 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.
Inventors:
HAN QING (CN)
LI DONG (CN)
LI DONG (CN)
Application Number:
PCT/CN2017/086133
Publication Date:
October 04, 2018
Filing Date:
May 26, 2017
Export Citation:
Assignee:
SHANGHAI KYLIGENCE INFORMATION TECH CO LTD (CN)
International Classes:
G06F17/30
Foreign References:
| CN104794221A | 2015-07-22 | |||
| CN106484875A | 2017-03-08 | |||
| CN104965886A | 2015-10-07 | |||
| CN106372190A | 2017-02-01 | |||
| US20060161517A1 | 2006-07-20 |
Other References:
See also references of EP 3605358A4
Attorney, Agent or Firm:
KEYCOM PARTNERS, P.C. (CN)
Download PDF: