Online analytical processing (OLAP)-based intelligent analysis method

An intelligent analysis and dimensional technology, applied in the direction of instruments, calculations, electrical digital data processing, etc., can solve the problems of manpower and time

Inactive Publication Date: 2011-07-27
PCI TECH GRP CO LTD
View PDF0 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In order to accomplish the above tasks, their possible approach is to manually process all the input dimensions of the data cube, perform query analysis on each dimension and manually select the results and return them. This process is quite labor-intensive and time-consuming

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
  • Online analytical processing (OLAP)-based intelligent analysis method
  • Online analytical processing (OLAP)-based intelligent analysis method
  • Online analytical processing (OLAP)-based intelligent analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] This method automatically traverses each dimension of the data cube by means of loops, recursively drills up and down on each dimension and analyzes the connection between dimensions, so as to obtain the members of the dimensions with the highest contribution to the total amount of the current report or a certain measurement and their combination. The whole process does not require human analysis, it only needs to take the data cube as input, and its output is the combination of each metric value in the cube and the N dimension members with the highest contribution to them.

[0011] Such as figure 2 with image 3 As shown, c implements the MDX pseudocode of one level of processing one dimension as follows:

[0012]

[0013]

[0014] The pseudocode for processing the set Ni is as follows:

[0015]

[0016] .

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 provides an online analytical processing (OLAP)-based intelligent analysis method and application thereof to the development of a business intelligence (BI) system. In the method, each dimension of a data cube is automatically traversed by cyclic means, and recursive vertical drilling and inter-dimension connection analysis are performed on each dimension, thereby obtaining a plurality of dimension members with the highest contribution degree for a current report total sum or a certain measure and combinations thereof. In the whole flow, manual analysis is not required, only the data cube is required to serve as input, and output comprises each measure in the cube and the combinations of N dimension members with the highest contribution degree for the measures.

Description

technical field [0001] The invention belongs to the development of business intelligence software in the field of software engineering, in particular to an OLAP-based intelligent analysis method and the application of the method in the development of business intelligence systems. technical background [0002] With the development of information technology, massive amounts of data are generated every day, and the high correlation between various data makes data analysts tend to analyze them in the multidimensional database OLAP. Since the original data has been compressed and aggregated, the multidimensional database has better data storage, processing and analysis capabilities than relational databases in terms of time and space. Nevertheless, analysts' operations on multidimensional databases are limited to simple query and analysis at this stage, and the analysis process often depends on the analyst's subjective judgment, requiring the analyst to decide which attributes a...

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 PCI TECH GRP 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