CN102135994A - Online analytical processing (OLAP)-based intelligent analysis method - Google Patents
Online analytical processing (OLAP)-based intelligent analysis method Download PDFInfo
- Publication number
- CN102135994A CN102135994A CN2011100639596A CN201110063959A CN102135994A CN 102135994 A CN102135994 A CN 102135994A CN 2011100639596 A CN2011100639596 A CN 2011100639596A CN 201110063959 A CN201110063959 A CN 201110063959A CN 102135994 A CN102135994 A CN 102135994A
- Authority
- CN
- China
- Prior art keywords
- dimension
- olap
- analysis method
- analysis
- intelligent analysis
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
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
The invention belongs to business intelligence software development aspect in the field of software engineering, particularly a kind of intelligent analysis method, and the application of this method in the Business Intelligence system exploitation based on OLAP.
Technical background
Along with the development of infotech, all there are every day the data of magnanimity to produce, the height relevance between the various data makes data analyst tend in multi-dimensional database OLAP the inside they be analyzed.Owing to raw data has been carried out processing such as compression polymerization, make that multi-dimensional database is that data storage processing analysis ability aspect time or space is all outstanding than relational database.However, the present stage analyst is only limited to simple query analysis to the operation of multi-dimensional database, and often will depend on analyst's subjective judgement in the process of analyzing, and needs the analyst to determine to analyze which member of which attribute.
A problem in the reality is that certain metric of the known form total value of supposition changes to some extent, and task is to find out this metric is changed the highest several dimension members of contribution rate (contribution rate is defined as the number that proportion that a member about a dimension of this metric accounts for all members of this dimension multiply by member under this dimension here).The front is mentioned, and the present stage analyst can only carry out simple query analysis and often comprise artificial subjective analysis multi-dimensional database.In order to finish above-mentioned task, their possible way is all input dimensions of manual handle data cube, and each dimension is carried out query analysis and selection result and it is returned manually, and this process is suitable labor intensive and time.Therefore proposing a kind of new method handles the problems referred to above automatically and becomes and press for.
Summary of the invention
The objective of the invention is to change the contribution rate decision problem, propose a kind of intelligent analysis method based on OLAP at BI system metrics value.
In order to realize goal of the invention, the technical scheme principle of employing is as follows:
As shown in Figure 1, with data cube as input.Cubical all dimensions of data are traveled through, handle a dimension (supposition has n dimension) at every turn.Di represents dimension i, and Viii is illustrated in i variable of i level of i dimension.On i dimension, earlier by drilling through the ground floor member who extracts under the dimension downwards, choose then contribution rate satisfy condition (the condition here be set certain threshold value) member Vi1i and store these nodes, then based on these member Vi1i, drill through down one deck member Vi2i downwards, judge whether to satisfy assign thresholds again, suppose that the words that satisfy condition are then stored Vi2i and continued to drill through downwards on the basis of Vi2i.The end condition of recurrence is that the contribution rate all members of certain one deck is lower than assign thresholds.This dimension disposes, and the result who obtains is the set N1 that contribution rate satisfies each dimension each member at all levels of certain threshold value.Store N1.Second to take turns the round-robin implementation as follows: all members and other dimensions that will gather all levels of some dimension i among the N1
All members of all levels link and obtain gathering N2, the member of the inside is Vimn*Vjkl,
And its contribution rate is greater than given threshold value.Suppose N2 for empty, then algorithm stops and returns the result of N1.Suppose N2 not for empty, storage N2 links the member inside the N2 and obtains N3 earlier, and the formation rule of N3 is similar with N2.The rest may be inferred, obtains a set about Ni.
Description of drawings
Fig. 1 is an overall procedure synoptic diagram of the present invention;
Fig. 2 is a processing raw data cube synoptic diagram of the present invention;
Fig. 3 is processing of the present invention and returns the Ni-1 synoptic diagram.
Embodiment
This method is by cubical each dimension of the automatic ergodic data of recursive device, thus each dimension recurrence drill through up and down and dimension between the connection analysis can draw current form total value or the highest several dimension members and the combination thereof of certain tolerance contribution degree.Whole flow process does not need artificial analysis, only data cube need be got final product as input, and its output is each metric and to N the highest dimension member of their contribution degrees combination in the cube.
As shown in Figures 2 and 3, the MDX false code of a level of a dimension of c specific implementation processing is as follows:
The false code of handling set Ni is as follows:
Claims (4)
1. the intelligent analysis method based on OLAP is characterized in that having adopted MDX (Multi Dimensional Expressions, Multidimensional Expressions) language;
2. the intelligent analysis method based on OLAP is characterized in that using MDX to handle multidimensional data analysis;
3. intelligent analysis method based on OLAP is characterized in that utilizing the ability of MDX fast processing olap database to realize based on the automatic statement analysis of attribute metric and finds out the several dimension members combinations the highest to form total value contribution rate;
4. the intelligent analysis method based on OLAP according to claim 3 is characterized in that using a plurality of dimensions of searching loop and utilizes recursive technique to realize the drilling analysis up and down of single dimension and the connection analysis between dimension.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100639596A CN102135994A (en) | 2011-03-17 | 2011-03-17 | Online analytical processing (OLAP)-based intelligent analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100639596A CN102135994A (en) | 2011-03-17 | 2011-03-17 | Online analytical processing (OLAP)-based intelligent analysis method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102135994A true CN102135994A (en) | 2011-07-27 |
Family
ID=44295780
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011100639596A Pending CN102135994A (en) | 2011-03-17 | 2011-03-17 | Online analytical processing (OLAP)-based intelligent analysis method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102135994A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103488475A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Multidimensional data analysis system and multidimensional data analysis method |
| CN103853818B (en) * | 2014-02-12 | 2017-04-12 | 博易智软（北京）技术股份有限公司 | Multidimensional data processing method and device |
| CN106997386A (en) * | 2017-03-28 | 2017-08-01 | 上海跬智信息技术有限公司 | A kind of OLAP precomputations model, method for automatic modeling and automatic modeling system |
| CN108268612A (en) * | 2017-12-29 | 2018-07-10 | 上海跬智信息技术有限公司 | A kind of pre- method of calibration based on OLAP precomputation models and pre- check system |
| CN108415981A (en) * | 2018-02-09 | 2018-08-17 | 平安科技（深圳）有限公司 | Data dimension generation method, device, equipment and computer readable storage medium |
| CN109739940A (en) * | 2018-12-29 | 2019-05-10 | 东软集团股份有限公司 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
| CN111782734A (en) * | 2019-04-04 | 2020-10-16 | 华为技术服务有限公司 | Data compression and decompression method and device |
| CN113779044A (en) * | 2021-11-08 | 2021-12-10 | 南京网眼信息技术有限公司 | Data drilling method and system |
-
2011
- 2011-03-17 CN CN2011100639596A patent/CN102135994A/en active Pending
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103488475B (en) * | 2013-09-02 | 2017-04-26 | 用友网络科技股份有限公司 | Multidimensional data analysis system and multidimensional data analysis method |
| CN103488475A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Multidimensional data analysis system and multidimensional data analysis method |
| CN103853818B (en) * | 2014-02-12 | 2017-04-12 | 博易智软（北京）技术股份有限公司 | Multidimensional data processing method and device |
| CN106997386A (en) * | 2017-03-28 | 2017-08-01 | 上海跬智信息技术有限公司 | A kind of OLAP precomputations model, method for automatic modeling and automatic modeling system |
| CN106997386B (en) * | 2017-03-28 | 2019-12-27 | 上海跬智信息技术有限公司 | OLAP pre-calculation model, automatic modeling method and automatic modeling system |
| CN108268612B (en) * | 2017-12-29 | 2021-05-25 | 上海跬智信息技术有限公司 | Pre-verification method and pre-verification system based on OLAP pre-calculation model |
| CN108268612A (en) * | 2017-12-29 | 2018-07-10 | 上海跬智信息技术有限公司 | A kind of pre- method of calibration based on OLAP precomputation models and pre- check system |
| CN108415981A (en) * | 2018-02-09 | 2018-08-17 | 平安科技（深圳）有限公司 | Data dimension generation method, device, equipment and computer readable storage medium |
| WO2019153543A1 (en) * | 2018-02-09 | 2019-08-15 | 平安科技（深圳）有限公司 | Data dimension generation method, apparatus, device, and computer readable storage medium |
| CN109739940A (en) * | 2018-12-29 | 2019-05-10 | 东软集团股份有限公司 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
| CN111782734A (en) * | 2019-04-04 | 2020-10-16 | 华为技术服务有限公司 | Data compression and decompression method and device |
| CN111782734B (en) * | 2019-04-04 | 2024-04-12 | 华为技术服务有限公司 | Data compression and decompression method and device |
| CN113779044A (en) * | 2021-11-08 | 2021-12-10 | 南京网眼信息技术有限公司 | Data drilling method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102135994A (en) | Online analytical processing (OLAP)-based intelligent analysis method | |
| Priyam et al. | Comparative analysis of decision tree classification algorithms | |
| CN104200087B (en) | For the parameter optimization of machine learning and the method and system of feature tuning | |
| CN101055585B (en) | System and method for clustering documents | |
| CN103208039B (en) | Method and device for evaluating software project risks | |
| CN101604363B (en) | Classification system and classification method of computer rogue programs based on file instruction frequency | |
| US9652498B2 (en) | Processing queries using hybrid access paths | |
| CN104965905A (en) | Web page classifying method and apparatus | |
| CN103514304A (en) | Project recommendation method and device | |
| CN103455593B (en) | A kind of service competition based on social networks realizes system and method | |
| CN104298787A (en) | Individual recommendation method and device based on fusion strategy | |
| CN103902694B (en) | Clustering and query behavior based retrieval result sorting method | |
| CN104778237A (en) | Individual recommending method and system based on key users | |
| CN102609465A (en) | Information recommendation method based on potential communities | |
| CN103336771A (en) | Data similarity detection method based on sliding window | |
| CN105389358A (en) | Web service recommending method based on association rules | |
| CN106649731A (en) | Node similarity searching method based on large-scale attribute network | |
| CN103678513B (en) | A kind of interactively retrieval type generates method and system | |
| CN108764324A (en) | A kind of text data immediate processing method based on K-Means algorithms and co-occurrence word | |
| CN103336765B (en) | A kind of markov matrix off-line correction method of text key word | |
| CN111126865A (en) | Technology maturity judging method and system based on scientific and technological big data | |
| CN102622358A (en) | Method and system for information searching | |
| CN104077361B (en) | A kind of sort method and system for big data | |
| CN103455491A (en) | Method and device for classifying search terms | |
| CN103678709A (en) | Recommendation system attack detection method based on time series data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C53 | Correction of patent for invention or patent application | ||
| CB02 | Change of applicant information |
Address after: 510665 No. 4 construction road, Guangzhou, Guangdong, Tianhe District Applicant after: PCI-Suntektech Co., Ltd. Address before: 510665 No. 4 construction road, Guangzhou, Guangdong, Tianhe District Applicant before: Suntek Technology Co., Ltd. |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: APPLICANT; FROM: XINTAI SCIENCE + TECHNOLOGY CO., LTD. TO: PCI-SUNTEKTECH CO., LTD. |
|
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110727 |