Dimension abnormity aggregation method of OLAP system

A technology of aggregation and dimension, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problem of long generation time, achieve the effect of good effect and ensure timeliness

Inactive Publication Date: 2009-12-23
CHINA MOBILE QUANTONG SYST INTEGRATION CO LTD
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the case of a large amount of data, when generating data for multi-dimensional analysis, th

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] Now take mobile communication as an example to illustrate as follows:

[0020] (1) Establish the fact table and dimension table of the data warehouse:

[0021] According to the star structure design in the data warehouse, there is a fact table (see attached table 1) and a dimension table (see attached table 2) in this embodiment;

[0022] The fact table and dimension table get the description displayed by the front end through CALL_TYPE_ID.

[0023] (2) Generation rules of database fact table data (see attached table 3):

[0024] From the content in Attached Table 3, it can be obtained that in July 2008, the number of calling customers was 1,000; the number of called users was 1,500. If it is displayed in the BI tool, it will be displayed as automatic summation or other calculation methods. However, part of the number of calling and called customers is heavy, so in this case, to make statistics, it is necessary to sort the records of the user’s calling and called to o...

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 a dimension abnormity aggregation method of an OLAP system, which is suitable for the situation in which non-mutual exclusion of indicators is present between dimension values in the OLAP system, in particular in the process of multidimensional analysis which generates a large amount of data and which is timely required. The invention generates gathering data of a fact table in a database in advance, dimension level codes of an OLAP tool is directed to well-gathered codes for association in order to achieve the requirement of generating correct gathering data. The beneficial effect of the invention is to thoroughly solve the problem that the current OLAP system performs indicators gathering too long in case that the dimension values are not mutually exclusive and guarantees timeliness of data, in addition, the invention is simple and easily practicable. The method has extremely excellent effect as represented by the application to IMEI analysis in Hebei Mobile.

Description

technical field [0001] The invention relates to an OLAP system dimension anomaly aggregation method, which is applicable to the situation when indicators in the OLAP system are aggregated when the dimension values ​​are not mutually exclusive, especially in the multidimensional analysis process that generates a large amount of data and has time requirements. Background technique [0002] With the rapid development of various industries, some industries will accumulate a large amount of historical data. Enterprise managers are no longer satisfied with simple business operations or even simple report analysis. In order to meet the needs of the market, they need a large amount of historical data. To discover the problems and laws of the data, analyze various factors of the data in an all-round way, and achieve the purpose of the analysis. So far, OLAP analysis has emerged as the times require. [0003] OLAP: On-Line Analytical Processing is a software technology that enables an...

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
IPC IPC(8): G06F17/30
Inventor 张文杰张琳赵雪辉
Owner CHINA MOBILE QUANTONG SYST INTEGRATION 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