Methods to identify related data in a multidimensional database

• US 7,472,127 B2
• Filed: 12/18/2002
• Issued: 12/30/2008
• 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): Fleurantin; Jean Bolte
• Assistant Examiner(s): Ly; Anh
• Application Number:
  US10/325,299
• Publication Number:
  US 20040122820A1
• Time in Patent Office: 2,204 Days
• Field of Search: 707/2, 707 3- 6, 707100-1041, 707/1, 707200-202
• US Class Current: 1/1
• 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

Methods 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 method implemented in a computer including a processor 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:

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.

2. The method of claim 1, 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.

3. The method of claim 1, further comprising creating a view of said related data.