Mapping data elements in a user interface
AssigneeInternational Business Machines Corporation
InventorsTrenten Peterson, Daina E. Pupons Wickham
Life of this patent
Estimating the term…
Abstract
A data assignment column, a first data element column, and a second data element column are presented in a graphical user interface, wherein the first and second data element columns show data elements stored in a database. First user input selecting one or more data elements in the first data column is received. Second user input in one or more of the data assignment elements indicates selection of one or more data elements of the second data column. The selected one or more data elements in the first data column are associated in the database with the selected one or more data elements in the second data column.
Claims15
A computer program product for using a graphical user interface to associate data in a database, the computer program product comprising:
- a computer readable storage medium having computer usable program code embodied therewith, the computer usable program code comprising a computer usable program code configured to:
- present a data assignment column, a first data element column, and a second data element column in the graphical user interface, wherein the first and second data element columns show data elements stored in a database;
- receive first user input selecting one or more data elements in the first data element column;
- after receiving the first user input, configure data assignment elements of the data assignment column to correspond to the data elements of the second data element column;
- move the data assignment column in juxtaposition to the second data element column, wherein the data assignment column's data assignment elements visually correspond to the second data element column's data elements;
- receive second user input in one or more of the data assignment elements indicating selection of one or more data elements of the second data element column;
- and
- associate, in the database, the selected one or more data elements in the first data element column with the selected one or more data elements in the second data element column;
- wherein the data assignment column comprises a selection interface for designating at least one of a many-to-one relationship, a one-to-many relationship, or a many-to-many relationship between the one or more selected data elements in the first data element column and the one or more selected data elements in the second data element column.
An apparatus comprising:
- a processor;
- a computer readable storage medium having computer usable program code embodied therewith, the computer usable program code comprising a computer usable program code configured to:
- present a data assignment column, a first data element column, and a second data element column in a graphical user interface, wherein the first and second data element columns show data elements stored in a database;
- receive first user input selecting one or more data elements in the first data element column;
- after receiving the first user input, configure data assignment elements of the data assignment column to correspond to the data elements of the second data element column;
- move the data assignment column in juxtaposition to the second data element column, wherein the data assignment column's data assignment elements visually correspond to the second data element column's data elements;
- receive second user input in one or more of the data assignment elements indicating selection of one or more data elements of the second data element column;
- and
- associate, in the database, the selected one or more data elements in the first data element column with the selected one or more data elements in the second data element column;
- wherein the data assignment column comprises a selection interface for designating at least one of a many-to-one relationship, a one-to-many relationship, or a many-to-many relationship between the one or more selected data elements in the first data element column and the one or more selected data elements in the second data element column.
Dependencies are inferred from the claim text.