An olap pre-calculation model, automatic modeling method and automatic modeling system
An automatic modeling and pre-computing technology, applied in computing, database models, instruments, etc., can solve the problems of increasing pre-computing and storage costs, long pre-computing time, and large amount of result data, so as to reduce pre-computing costs and reduce The effect of redundant computing and data storage, high computing efficiency
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0039] Such as figure 1 As shown, a kind of OLAP pre-calculation model of the present invention, this pre-computation model includes: dimension module, aggregation group module, measure module; Described dimension module comprises: common dimension unit and derivation dimension unit; Described common dimension unit , used to precalculate the fields on the fact table; the derived dimension unit is used to precalculate the primary key on the dimension table, and record the mapping relationship between the columns on the dimension table and the primary key; the dimension table of the derived dimension The primary key and common dimension are used as pre-calculated dimensions, which conform to a specific order; the aggregation group module is used to divide the multiple pre-calculated dimensions calculated in the dimension module into multiple aggregation groups; the measurement module is used to Aggregates all precomputed dimension combinations in the dimension module to generat...
Embodiment 2
[0050] Such as figure 2 Shown, a kind of automatic modeling method based on OLAP precalculation model of the present invention, this method comprises the steps:
[0051] S1, perform data statistics according to the data model and data source given by the user, and obtain the data statistics results;
[0052] S2, perform query rehearsal according to the data model and target query given by the user, and determine the business model;
[0053] S3, perform query rehearsal on the sample, and collect query statistics;
[0054] S4, based on the business model in S2 and the statistical results of data in S1, perform physical modeling, and define the dimensions, measurements, and aggregation groups of the pre-computing model;
[0055] S5, based on the query statistics in S3, adjust the model after the physical modeling in S4 to obtain a business modeling result;
[0056] S6. Optimizing and adjusting the business modeling in S5 to obtain a pre-computation model.
[0057] Solve the ...
Embodiment 3
[0086] Such as Figure 5 Shown, the automatic modeling system of a kind of OLAP precalculation model of the present invention, this system comprises: data statistics module, business model module, query statistics module, modeling building module; Data statistics module, for according to user given The data model and data source are used to perform data statistics to obtain the data statistics results; the business model module is used to conduct query rehearsal according to the data model and samples given by the user, and determine the business model; the query statistics module is used to perform sample analysis Query rehearsal, and collect query statistics; modeling building module, used to obtain the results of business modeling according to the data statistics module, business model module, and query statistics module.
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com