Patent ID: 9069831
Filing Date: 2015-06-30
Classification: G06F

Abstract:
1. A method, comprising: obtaining, using a processor of a computer, 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.