IP Library › Granted Patent US 8,126,871
Granted Patent B2
US 8,126,871 · App. 12/264,891 · Granted Feb 28, 2012

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

Assignee: International Business Machines Corporation
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,126,871
App. No.
12/264,891
Granted
Feb 28, 2012
Kind
B2
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 (30)

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.

Continuity (2)
Continuation 10325299 · Dec 18, 2002
Related Publication 20090063403A1 · Mar 5, 2009