Systems and computer program products to identify related data in a multidimensional database

• US 8,126,871 B2
• Filed: 11/04/2008
• Issued: 02/28/2012
• Est. Priority Date: 12/18/2002
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Malloy, William Earl, Pu, Ken Qian
• Primary Examiner(s): Breene, John E
• Assistant Examiner(s): Ly, Anh
• Application Number:
  US12/264,891
• Publication Number:
  US 20090063403A1
• Time in Patent Office: 1,211 Days
• Field of Search: 707/717, 707/830, 707/957, 707/958, 707/E17.002, 707/E17.056
• US Class Current: 707/717
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: Y10S 707/957 Multidimensional
• CPC Class Codes: Y10S 707/958 Data cubes
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Systems and computer program products that identify data that is related to and associated with data that has been selected from a multidimensional database. The overwhelming amount of data in a multidimensional database that may be viewed by a user, such as a data analyst, is reduced to the selected and associated data by use of index data and related index data, according to the present invention. The views of selected data and related data may be highlighted and formatted for presentation to the user. Further, irrelevant data is filtered out and not presented to the user. Existing systems have not been able to efficiently and adequately identify data that is related to and associated with selected data in a multidimensional database.

Claims

1. A computer system for identifying related data that is associated with selected data said selected data that is implemented in a subject multidimensional database, said selected data being obtained by use of index data that is implemented in an index multidimensional database that is a data cube, comprising:

related index data that is identified from said index data by creating a multidimensional query and executing said multidimensional query against said index data, wherein said multidimensional query includes one or more predicates determined by members of said selected data;

said related data that is identified from said selected data by use of multidimensional queries directed to said related index data, wherein said related data is related to said selected data along dimensions of a view that is used to present said selected data to a user, and wherein identifying said related data includes retrieving said related data by accessing combinations of members that are at a same level of aggregation as members of said selected data;

said view of said selected data that is formatted for presentation to a user by;

determining highlighting criteria for said selected data; and

highlighting said selected data in said view that is used to present said selected data based on said highlighting criteria;

a view of said related data that is formatted for presentation to a user by;

determining highlighting criteria for said related data; and

highlighting said related data in said view that is used to present said related data to a user based on said highlighting criteria; and

said related data and said selected data presented to a user in one highlighted view.

2. The computer system of claim 1, further comprising:

said view of said selected data that is created;

said multidimensional query that is created by use of said view of selected data; and

said related data that is identified by said multidimensional query that is directed to said index multidimensional database.

3. The computer system of claim 1, further comprising a view of said related data that is created.

4. An article of manufacture comprising a computer-readable device storing instructions for identifying related data that is associated with selected data, said selected data that is implemented in a subject multidimensional database, said selected data being obtained by use of index data that is implemented in an index multidimensional database that is a data cube, wherein the instructions, when executed by a processor of a computer system, perform:

identifying related index data from said index data by creating a multidimensional query and executing said multidimensional query against said index data, wherein said multidimensional query includes one or more predicates determined by members of said selected data;

identifying said related data from said selected data by use of multidimensional queries directed to said related index data, wherein said related data is related to said selected data along dimensions of a view that is used to present said selected data to a user, and wherein identifying said related data includes retrieving said related data by accessing combinations of members that are at a same level of aggregation as members of said selected data;

formatting said view of said selected data for presentation to a user by;

determining highlighting criteria for said selected data;

highlighting said selected data in said view that is used to present said selected data based on said highlighting criteria;

formatting a view of said related data for presentation to a user by;

determining highlighting criteria for said related data; and

highlighting said related data in said view that is used to present said related data to a user based on said highlighting criteria; and

presenting said related data and said selected data to a user in one highlighted view.

5. The article of manufacture of claim 4, further comprising:

creating said view of said selected data;

creating said multidimensional query by use of said view of selected data; and

identifying said related data by said multidimensional query that is directed to said index multidimensional database.

6. The article of manufacture of claim 4, further comprising creating a view of said related data.