Retrieving data objects
AssigneeInternational Business Machines Corporation
InventorsRoberta J. Cochrane, Ronald C. Leung, Louis S. W. Mau
Life of this patent
Estimating the term…
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.
Claims14
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.
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.
Dependencies are inferred from the claim text.