# US 2012/0254201 A1 · Retrieving data objects

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0254201 A1
- Document ID: US20120254201A1
- Status: Published application
- Kind: A1
- Application number: 13/074,472
- Filed: 2011-03-29
- Published: 2012-10-04
- Earliest claimed: 2011-03-29
- Assignees: International Business Machines Corporation
- Inventors: Roberta J. Cochrane; Ronald C. Leung; Louis S.W. Mau
- Web page: https://patentgrep.com/patent/US20120254201A1

## CPC

- G06F 16/26: Visual data mining; Browsing structured data
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim at position 1

1-7. (canceled)

### Claim 8

A system, comprising:
a processor; and
a data object retriever coupled to the processor and performing operations, the operations comprising:
generating a Graphical User Interface (GUI) based on relationships between tables identified in a data model;
displaying the GUI to enable selection of the tables and columns in the tables;
receiving, 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;
generating a statement based on the selected tables and the selected columns;
executing the statement to obtain results; and
processing the results to create a data object having a hierarchical structure that indicates the relationships between the tables.

### Claim 9 (depends on 8)

The system of claim 8, wherein the operations further comprise:
obtaining the data model; and
parsing the data model to obtain information about the relationships between the tables.

### Claim 10 (depends on 8)

The system of claim 8, wherein the operations further comprise:
receiving filtering criteria via the GUI that selects rows in the selected tables;
in response to the received filtering criteria, generating filter criteria for one or more references of a same table; and
generating the statement based on the filtering criteria.

### Claim 11 (depends on 8)

The system of claim 8, wherein the operations further comprise:
based on information gathered via the GUI, generating a Structured Query Language (SQL) statement that identifies the selected columns, that identifies the selected rows, and that joins the selected tables.

### Claim 12 (depends on 11)

The system of claim 11, 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.

### Claim 13 (depends on 8)

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

### Claim 14 (depends on 8)

The system of claim 8, wherein the relationships include cyclic relationships.

### Claim 15

A computer program product, comprising:
a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
computer readable program code, when executed by a processor of a computer, configured to:
generate a Graphical User Interface (GUI) based on relationships between tables identified in a data model;
display the GUI to enable selection of the tables and columns in the tables;
receive, 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;
generate a statement based on the selected tables and the selected columns;
execute the statement to obtain results; and
process the results to create a data object having a hierarchical structure that indicates the relationships between the tables.

### Claim 16 (depends on 15)

The computer program product of claim 15, wherein the computer readable program code, when executed by the processor of the computer, is configured to:
obtain the data model; and
parse the data model to obtain information about the relationships between the tables.

### Claim 17 (depends on 15)

The computer program product of claim 15, wherein the computer readable program code, when executed by the processor of the computer, is configured to:
receive filtering criteria via the GUI that selects rows in the selected tables;
in response to the received filtering criteria, generate filter criteria for one or more references of a same table; and
generate the statement based on the filtering criteria.

### Claim 18 (depends on 14)

The computer program product of claim 14, wherein the computer readable program code, when executed by the processor of the computer, is configured to.
based on information gathered via the GUI, generate a Structured Query Language (SQL) statement that identifies the selected columns, that identifies the selected rows, and that joins the selected tables.

### Claim 19 (depends on 15)

The computer program product of claim 15, 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.

### Claim 20 (depends on 15)

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

### Claim 21 (depends on 15)

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