Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and device for realizing multi-dimensional cube association

A cube and multi-dimensional technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems that Cube cannot realize correlation analysis, etc., achieve the effect of reducing system performance consumption and execution time, and improving efficiency

Active Publication Date: 2018-09-04
CHINA MOBILE COMM CORP TIANJIN
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] Therefore, in the existing two schemes, there are common shortcomings when implementing association analysis on two cubes: to implement association analysis of two cubes, the two cubes must have common dimensions, and cubes without common dimensions cannot Realize association analysis

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
  • A method and device for realizing multi-dimensional cube association
  • A method and device for realizing multi-dimensional cube association
  • A method and device for realizing multi-dimensional cube association

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] Embodiment 1 of the present invention realizes the method for Cube association, such as figure 2 As shown, the method includes the following steps:

[0039] Step 101: The server determines that Cubes to be associated have no common dimension.

[0040] Specifically, the server compares the dimension information of the Cubes that need to be associated, and when there is no same dimension information, it is determined that the Cubes that need to be associated do not have a common dimension; the server can be a server for data management, such as the data of the mobile company background Management server.

[0041] When having the same dimension information, the server directly associates the Cubes that need to be associated through the dimension information.

[0042] For example, for Cube1 in Table 1 and Cube2 in Table 2, when users need to check the number of users and revenue of each brand in each region, they need to associate Cube1 and Cube2 to generate a New Cube ...

Embodiment 2

[0070] Embodiment 2 of the present invention provides a device for realizing Cube association, such as image 3 As shown, the device includes: a judgment module 301, a source table analysis module 302, and a generation module 303; wherein,

[0071] Judgment module 301, for determining that the Cubes that need to be associated do not have a common dimension;

[0072] A source table analysis module 302, configured to track the source table of the Cube and obtain a list;

[0073] A generating module 303, configured to generate a dynamic Cube according to the schedule;

[0074] Wherein, the Cube that needs to be associated is: during the generation process, it has the same parameter information; the parameter information includes primary key, dimension and measurement information;

[0075] Specifically, the judging module 301 compares the dimension information of the Cubes that need to be associated, and when there is no identical dimension information, determines that the Cubes...

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 a method for achieving multi-dimensional cube association. The method for achieving the multi-dimensional cube association comprises the steps of determining that cubes required to be associated have no common dimensionality, tracking a source list of the cubes to obtain a detailed list, generating a dynamic cubes according to the obtained detailed list. The invention further discloses a device for achieving multi-dimensional cube association. By means of the scheme, the cube association free of common dimensionality can be achieved, and quick and convenient data analysis can be provided for a user.

Description

technical field [0001] The present invention relates to distributed statistics technology, in particular to a method and device for realizing multi-dimensional cube (Cube) association. Background technique [0002] Online analytical processing (OLAP) was proposed by E.F. Codd, the father of relational databases, in 1993. Codd believed that online transaction processing (OLTP) could no longer meet the requirements of end users for database query and analysis. The simple query can not meet the needs of user analysis. The user's decision analysis needs a large number of calculations on the relational database to get the results, and the query results cannot meet the needs of the decision makers. Therefore, Codd proposed the concept of multidimensional database and multidimensional analysis, namely OLAP. The OLAP committee defines online analytical processing as: the data converted from the original data, which can be truly understood by users and truly reflects the multidimen...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 刘玉娜
Owner CHINA MOBILE COMM CORP TIANJIN