Retrieving data objects

• US 9,069,830 B2
• Filed: 03/29/2011
• Issued: 06/30/2015
• Est. Priority Date: 03/29/2011
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cochrane, Roberta J., Leung, Ronald C., Mau, Louis S. W.
• Primary Examiner(s): Choi, Yuk Ting
• Application Number:
  US13/074,472
• Publication Number:
  US 20120254201A1
• Time in Patent Office: 1,554 Days
• Field of Search: 707/754, 707/999.003
• US Class Current: 1/1
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data

Abstract

Provided are techniques for generating a Graphical User Interface (GUI) based on relationships between tables identified in a data model and displaying the GUI to enable selection of the tables and columns in the tables. Via the GUI, a selection of at least one of the tables and a selection of at least one of the columns in the at least one of the selected tables are received. A statement is generated based on the selected tables and the selected columns. The statement is executed to obtain results. The results are processed to create a data object having a hierarchical structure that indicates the relationships between the tables.

Claims

1. A system, comprising:

a processor; and

storage coupled to the processor, wherein the storage stores a computer program, and wherein the processor is configured to execute the computer program to perform operations, the operations comprising;

obtaining information about relationships between values in tables stored in a database;

in response to receiving selection of a first table, displaying a hierarchical tree structure with the selected first table, columns of the selected first table that each has a selection indicator located adjacent to a column name for that column, and one or more related tables that each has a selection indicator and an expansion indicator located adjacent to a table name for that related table;

receiving, via the hierarchical tree structure, a selection of a related table from the one or more related tables using the selection indicator for the related table, a column from the columns in the selected first table to be included as an attribute in a data object using the selection indicator for the column in the selected first table, and a column from columns in the selected related table to be included as another attribute in the data object using a selection indicator for the column in the selected related table;

generating a statement based on the selected first table, the selected related table, the selected column in the selected first table, and the selected column in the selected related table; and

executing the statement to create the data object having a hierarchical tree structure that indicates the relationships between the values of the selected column in the selected first table and the selected column in the selected related table.

2. The system of claim 1, wherein the operations further comprise:

obtaining a data model; and

parsing the data model to obtain the information about the relationships between the values in the tables stored in the database.

3. The system of claim 1, wherein the operations further comprise:

receiving filtering criteria that selects rows in the selected first table and the selected related table;

in response to the received filtering criteria, generating filter criteria for one or more references of the selected first table and the selected related table; and

generating the statement based on the selected first table, the selected related table, the selected column in the selected first table, the selected column in the selected related table, and the received filtering criteria.

4. The system of claim 1, wherein the statement is a Structured Query Language (SQL) statement that identifies the selected column in the selected first table, that identifies the selected column in the selected related table, that identifies the selected rows, and that joins the selected first table and the selected related table.

5. The system of claim 4, wherein the operations further comprise:

returning the data object as a web feed; and

in response to the user selecting the web feed, displaying the data object.

6. The system of claim 5, wherein the web feed comprises an ATOM feed.

7. The system of claim 1, wherein the relationships include cyclic relationships.

8. A computer program product, comprising:

a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code, when executed by a processor of a computer, is configured to;

obtain information about relationships between values in tables stored in a database;

in response to receiving selection of a first table, display a hierarchical tree structure with the selected first table, columns of the selected first table that each has a selection indicator located adjacent to a column name for that column, and one or more related tables that each has a selection indicator and an expansion indicator located adjacent to a table name for that related table;

receive, via the hierarchical tree structure, a selection a related table from the one or more related tables using the selection indicator for the related table, a column from the columns in the selected first table to be included as an attribute in a data object using the selection indicator for the column in the selected first table, and a column from columns in the selected related table to be included as another attribute in the data object using a selection indicator for the column in the selected related table;

generate a statement based on the selected first table, the selected related table, the selected column in the selected first table, and the selected column in the selected related table; and

execute the statement to create the data object having a hierarchical tree structure that indicates the relationships between the values of the selected column in the selected first table and the selected column in the selected related table.

9. The computer program product of claim 8, wherein the computer readable program code, when executed by the processor of the computer, is configured to:

obtain a data model; and

parse the data model to obtain the information about the relationships between the values in the tables stored in the database.

10. The computer program product of claim 8, wherein the computer readable program code, when executed by the processor of the computer, is configured to:

receive filtering criteria that selects rows in the selected first table and the selected related table;

in response to the received filtering criteria, generate filter criteria for one or more references of the selected first table and the selected related table; and

generate the statement based on the selected first table, the selected related table, the selected column in the selected first table, the selected column in the selected related table, and the received filtering criteria.

11. The computer program product of claim 8, wherein the statement is a Structured Query Language (SQL) statement that identifies the selected column in the selected first table, that identifies the selected column in the selected related table, that identifies the selected rows, and that joins the selected first table and the selected related table.

12. The computer program product of claim 8, wherein the computer readable program code, when executed by the processor of the computer, is configured to:

return the data object as a web feed; and

in response to the user selecting the web feed, display the data object.

13. The computer program product of claim 12, wherein the web feed comprises an ATOM feed.

14. The computer program product of claim 8, wherein the relationships include cyclic relationships.