×

Method and system for data analysis

  • US 8,347,204 B2
  • Filed: 03/03/2009
  • Issued: 01/01/2013
  • Est. Priority Date: 05/05/2008
  • Status: Active Grant
First Claim
Patent Images

1. A computer implemented method, executed in a processor, of joining a target table and a source table, the target table and the source table each comprising a plurality of cells arranged in rows and columns, each cell in the plurality of cells being capable of including data, the method comprising:

  • designating certain ones of the columns of the source table as source key columns;

    assigning corresponding ones of the columns of the target table as target key columns thereby creating a one to one correspondence between each source key column and each of the assigned ones of the target key columns;

    associating each row of the target table with the source table rows based on the condition that data included in the cells therein and in each source key column is identical to data included in the cells of the target table rows and the corresponding target key column; and

    populating, into cells of conjoined columns appended onto the target table, data identical to data in cells from corresponding source table columns and from source table rows associated with the target table rows;

    thereby creating a joined table comprising the target table with the conjoined columns appended onto the target table;

    displaying, on a single user interface screen, a target table icon representative of the target table, and a source table icon representative of the source table;

    receiving a drag and drop selection of the source table icon onto the target table icon;

    receiving a selection for the source key columns of the source table;

    receiving a selection for the target key columns of the target table;

    thereby to create the joined table; and

    displaying a visual directional link between the source table icon and the icon representative of the target table.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×