Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Intelligent data aggregation method and intelligent data aggregation system based on relational online analytical processing

An online analysis and processing and data aggregation technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of a large number of human resources, small storage space, and low query efficiency, so as to improve work efficiency and improve processing Speed, the effect of improving query speed

Active Publication Date: 2012-06-27
南京橙红科技股份有限公司
View PDF2 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Relational online analytical processing (ROLAP) is a very common method in data analysis. Its advantage is that the storage space is small, but the query efficiency is low. In terms of establishing and maintaining aggregates, it requires a lot of human resources to maintain
However, based on multidimensional online analysis (Multidimensional OLAP, MOLAP), the query efficiency is higher in data analysis, but it needs to be aggregated in advance and requires a large space

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
  • Intelligent data aggregation method and intelligent data aggregation system based on relational online analytical processing
  • Intelligent data aggregation method and intelligent data aggregation system based on relational online analytical processing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] An intelligent data aggregation system based on relational online analysis and processing provided by this embodiment, the system includes: a fact table module: used to store actual detailed data; an aggregation table module, used to store summary data of the fact table data; Dimension table module: used to store related dimensions of the aggregation table; data processing module: used to add data in the fact table to the aggregation table at regular intervals; timer: used to start the data processing module at regular intervals.

[0035] The system also includes an aggregation management table module, a dimension dictionary table module and a measurement dictionary table module, the dimension dictionary table module and the measurement dictionary table module are associated with the aggregation management table through a foreign key, and are used for according to the weight of the aggregation management table module Go to find the aggregation table module that needs to ...

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 discloses an intelligent data aggregation method based on relational online analytical processing, which includes the steps: (1) establishing an aggregation table and establishing the relation between the aggregation table and a dimension table and the relation between the aggregation table and a fact table; (2) analyzing the relation between the aggregation table and the dimension table and the relation between the aggregation table and the fact table to generate a data processing module for extracting, transforming and loading data; (3) starting the data processing module in a database at regular time to add data in the fact table into the aggregation table at regular time; and (4) judging whether the aggregation table or the fact table is queried according to information matching in a matching aggregation knowledge base when data are queried in a system. The method is high in query efficiency, small in occupied space and less in labor cost.

Description

technical field [0001] The invention relates to an intelligent data processing method, and more specifically, relates to an intelligent data processing method based on relational connection analysis and processing. Background technique [0002] In the data warehouse system, the query speed is a very difficult problem. Currently, the query speed is very slow for the fact table query with a large amount of data. Especially for queries in relational online analytical processing (ROLAP), if you want to increase the speed of queries, you must first build an aggregation table according to business needs. But often the business analysis of an enterprise is very complicated, and the query method, granularity, and dimension may be changed at any time according to the current situation. This makes it difficult to establish the aggregation table in advance. If there is no aggregation table at this time, the fact table will be queried, but the fact table is often very large and the que...

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
Inventor 吴斌袁红岗高峡
Owner 南京橙红科技股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products