Methods to manage the display of data entities and relational database structures

• US 7,467,125 B2
• Filed: 12/12/2002
• Issued: 12/16/2008
• Est. Priority Date: 12/12/2002
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Tomlyn, Craig R., Khatchatrian, Suzanna
• Primary Examiner(s): ABEL JALIL, NEVEEN
• Application Number:
  US10/318,749
• Publication Number:
  US 20040117379A1
• Time in Patent Office: 2,196 Days
• Field of Search: 707 1- 10, 707/103.R, 707/104.1, 715/744, 715/853, 715/784, 715/788
• 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

Methods 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-implemented method to retain contextual information about data, said computer having a graphical display and at least one entity that represents said data, said method comprising:

mapping 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;

mapping 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;

generating 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

displaying 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.

2. The method of claim 1, further comprising:

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

associating said at least one object 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 method of claim 1, further comprising including another said at least one area in said at least one object.

4. The method of claim 3, further comprising including another said at least one object in said another at least one area.

5. The method of claim 1, further comprising said data representing OLAP data.