SYSTEMS, METHODS, AND COMPUTER PROGRAM PRODUCTS TO MANAGE THE DISPLAY OF DATA ENTITIES AND RELATIONAL DATABASE STRUCTURES

• US 20090024658A1
• Filed: 10/03/2008
• Published: 01/22/2009
• Est. Priority Date: 12/12/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: KHATCHATRIAN, Suzanna, TOMLYN, Craig R.
• Granted Patent: US 7,904,415 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

Systems and computer products that present typically large amounts of entity information with a graphical display that efficiently maps the display of a large number of OLAP objects to related relational database tables thereby retaining contextual information about the data associated with the objects and tables. The efficient mapping is enabled by the use of areas that contain and include objects. The preferred embodiment of the present invention enhances analysis, by OLAP techniques, of the objects and the associated relational database information. An embodiment of the present invention further operates in a recursive manner by enabling the objects to include and contain additional objects.

Claims

1. A computer system to retain contextual information about data, said computer having a graphical display and at least one entity that represents said data, comprising:

said at least facts table in a relational database that is mapped to at least one Online Analytical Processing (OLAP) object, wherein the at least one OLAP object is a facts object that is presented for OLAP data analysis, and wherein said facts table includes measurement data;

at least one dimension table in said relational database is mapped to a dimension object, wherein said at least one dimension table includes attribute data, and wherein said dimension object is an OLAP object that is presented for OLAP data analysis;

said graphical display is generated, wherein said graphical display includes a series of three separate areas represented with rectangles and including a left rectangle that is adjacent to a middle rectangle that is adjacent to a right rectangle, wherein said separate areas represent a star schema configuration, wherein different portions of the star schema configuration are displayed in different areas, wherein each of said separate areas is a container that contains one or more OLAP objects each represented with separate rectangles and contains one or more additional tables that are associated with said one or more OLAP objects and each represented with separate rectangles within a rectangle containing an associated OLAP object, wherein any OLAP object represented by a rectangle includes at least one of an additional OLAP object or a table each represented with separate rectangles, and wherein said one or more OLAP objects are manipulated independently within each of said separate areas while retaining contextual information about the OLAP objects and displaying related tables within an area; and

said facts object is displayed in a first rectangle and said at least one associated facts table are each displayed in a separate rectangle within said first rectangle that includes said measurement data displayed in said middle rectangle, said dimension object represented in a second rectangle and said at least one associated dimension table each represented in said second rectangle, wherein said first dimension object is in one of said left rectangle or said right rectangle, and relationships between said facts table and said dimension table that are displayed in said graphical display to retain said contextual information about said data, wherein said relationships are shown across said separate rectangles in said graphical display, wherein one or more lines cross said separate rectangles and connect said measurement data of said at least one associated facts table in said middle rectangle and said attribute data of said at least one associated dimension table in said left rectangle or said right rectangle.

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

said relational database having at least one table in said computer; and

said at least one object that is associated with said at least one relational database table to retain said contextual information about said data and said associated at least one relational database table.

3. The computer system of claim 1, further comprising another said at least one area that is included in said at least one object.

4. The computer system of claim 3, further comprising another said at least one object that is included in said another at least one area.

5. The computer system of claim 1, further comprising said data that represents OLAP data.

6. An article of manufacture comprising a program usable storage medium embodying one or more computer usable instructions executable by said computer to retain contextual information about data, said computer having a graphical display and at least one entity that represents said data, wherein:

said computer usable instructions map at least one facts table in a relational database to at least one Online Analytical Processing (OLAP) object, wherein the at least one OLAP object is a facts object that is presented for OLAP data analysis, and wherein said facts table includes measurement data;

said computer usable instructions map at least one dimension table in said relational database to a dimension object, wherein said at least one dimension table includes attribute data, and wherein said dimension object is an OLAP object that is presented for OLAP data analysis;

said computer usable instructions generate said graphical display, wherein said graphical display includes a series of three separate areas represented with rectangles and including a left rectangle that is adjacent to a middle rectangle that is adjacent to a right rectangle, wherein said separate areas represent a star schema configuration, wherein different portions of the star schema configuration are displayed in different areas, wherein each of said separate areas is a container that contains one or more OLAP objects each represented with separate rectangles and contains one or more additional tables that are associated with said one or more OLAP objects and each represented with separate rectangles within a rectangle containing an associated OLAP object, wherein any OLAP object represented by a rectangle includes at least one of an additional OLAP object or a table each represented with separate rectangles, and wherein said one or more OLAP objects are manipulated independently within each of said separate areas while retaining contextual information about the OLAP objects and displaying related tables within an area; and

said computer usable instructions display said facts object in a first rectangle and said at least one associated facts table each in a separate rectangle within said first rectangle that includes said measurement data in said middle rectangle, said dimension object represented in a second rectangle and said at least one associated dimension table each in separate rectangles in said second rectangle, wherein said first dimension object is in one of said left rectangle or said right rectangle, and relationships between said facts table and said dimension table in said graphical display to retain said contextual information about said data, wherein said relationships are shown across said separate rectangles in said graphical display, wherein one or more lines cross said separate rectangles and connect said measurement data of said at least one associated facts table in said middle rectangle and said attribute data of said at least one associated dimension table in said left rectangle or said right rectangle.

7. The article of manufacture of claim 6, wherein:

said computer usable instructions associate said at least one object with at least one relational database table in said relational database to retain said contextual information about said data and said associated at least one relational database table.

8. The article of manufacture of claim 6, wherein said computer usable instructions include another said at least one area in said at least one object.

9. The article of manufacture of claim 8, wherein said computer usable instructions include another said at least one object in said another at least one area.

10. The article of manufacture of claim 6, wherein said computer usable instructions represent OLAP data by said data.