OLAP (on-line analytical processing) data model automatic modeling method and classifier

一种数据模型、自动建模的技术，应用在数据库模型、推理方法、计算模型等方向，能够解决建模效率低、无法实现自动建模、成本大等问题，达到降低学习难度、降低试错成本、提高精度的效果

Active Publication Date: 2018-06-12
SHANGHAI KYLIGENCE INFORMATION TECH CO LTD
View PDF5 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is: the existing OLAP model relies heavily on manual understanding of data tables and business requirements to achieve, the modeling efficiency is low, the cost is high, and automatic modeling cannot be realized

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • OLAP (on-line analytical processing) data model automatic modeling method and classifier
  • OLAP (on-line analytical processing) data model automatic modeling method and classifier

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0042] Such as figure 1 As shown, a method for automatic modeling of OLAP data models, the method includes:

[0043] S1, obtaining the SQL query statement;

[0044] S2, analyzing the SQL query statement, and judging whether there is a grammatical or lexical error in the SQL query statement according to the analysis result;

[0045] S3, if it does not exist, perform query structure extraction on the SQL query statement according to the column information and table information related to the source data used by the SQL query statement, and obtain at least N groups of query patterns, where N is greater than or equal to the natural number of 1;

[0046] S4. Classify the at least N groups of query patterns;

[0047] ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to an OLAP (on-line analytical processing) data model automatic modeling method and a classifier. The method includes the steps: acquiring an SQL (structured query language); analyzing the SQL and judging whether the SQL has grammar and lexical errors or not; extracting a query structure from the SQL if not to obtain at least N groups of query modes; classifying the N groupsof query modes; combining the query modes of each class to obtain a corresponding mode relationship tree; converting the mode relationship tree into a corresponding data model. The classifier comprises a static rule classification module and a statistical rule and preset learning rule classification module. The data model generated by the method can completely support all inputted SQL, has a certain generalization capacity and can further completely support Cube operation and rapid query, and learning difficulty and trial and error cost of users are effectively reduced.

Description

technical field [0001] The invention belongs to the field of OLAP big data information, and in particular relates to a method and a classifier for automatic modeling of an OLAP data model. Background technique [0002] In today's era of dataization, how to analyze massive and complex data through OLAP to assist business decision-making is an important topic in the field of business intelligence and data analysis; and the data model is the basis of OLAP analysis. [0003] Generally, the bottom layer of OLAP analysis architecture is the data warehouse, which contains a series of data tables; modelers design data models based on these tables for analysts to use according to business analysis requirements; eventually, analysts’ analysis operations will be transformed into a series of data for SQL query of the data table. The data model gives business meaning to the data table, decouples the relationship between the underlying data and business requirements, and is an indispensa...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2465G06F16/283G06F16/285G06F16/212G06F16/2282G06N20/00G06F16/2455G06F16/258G06F16/254G06N5/04
Inventor 李栋张逸凡李扬韩卿
Owner SHANGHAI KYLIGENCE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap