Method and system for data analysis

• US 9,489,364 B2
• Filed: 11/26/2012
• Issued: 11/08/2016
• Est. Priority Date: 05/05/2008
• Status: Active Grant

• Current Assignee: Drinking Bird Software Limited
• Original Assignee: Drinking Bird Software Limited
• Inventors: Rosner, Norm
• Primary Examiner(s): Patel, Manglesh M
• Application Number:
  US13/685,235
• Publication Number:
  US 20130117654A1
• Time in Patent Office: 1,443 Days
• Field of Search: 715/227, 715/212, 715/220, 715/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2456 Join operations
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 40/177 of tables; using ruled lines

Abstract

A data analysis and display system and method for performing a plurality of operations on data arranged in data tables. One or more of the following data operations are provided: combining separate data together, for example by joining and appending; normalizing and summarizing; copying; calculating and presenting new information from existing data; making corrections in a persistent manner, and analyzing the data, to allow users to work with their data at a high level using a core set of functions that facilitate performance of these operations in a generally simple, intuitive manner.

Claims

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 a single source table rows meeting the condition that data included in a cell belonging to a source key column is identical to data included in the cells of the target table rows and the corresponding target key column;

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 directly appending to the target table conjoined columns populated with associated data from the source table;

then further changing, adding or removing data in at least one cell of the source table or of the target table;

updating all associations between source table rows and target table rows to remain consistent with all current values in cells of the source key columns and of the target key columns; and

updating the values in the conjoined columns of the target table to remain consistent with any updated associations between source table rows and target table rows, and to remain consistent with all current values in cells of the source table.

2. The method of claim 1 further comprising displaying the conjoined data from the source table in a first visual style, and displaying the data of the target table in a second visual style.

3. The method of claim 2 further wherein the first visual style comprises a first graphical icon and the second visual style comprises a second graphical icon.

4. The method of claim 1, wherein the source table is selected from the group consisting of a manual input table, an electronic spreadsheet input table and a database input table.

5. The method of claim 1 further comprising:

providing a user option to correct data in a cell of a target table row and of a target key column; and

updating conjoined data of the target table row to reflect the source table data which matches the corrected data of the cell of the target table row.

6. A computer implemented method, executed in a processor, of creating a resultant table, based on a source table comprising a plurality of rows and columns comprising cells capable of including data values, the method comprising:

selecting a first one or more columns of the source table as key columns;

selecting a second one or more columns of the source table as summarization columns;

consolidating redundant data values in the key columns to a single set of key data values; and

aggregating data values in the summarization columns associated with the single set of key data values to provide an aggregated value corresponding to the single set of key data values, wherein aggregating one or more data values comprises selecting a single representative data value from the one or more data values based on a selection rule;

thereby to create the resultant table comprising the set of key data values with the aggregated data values from the summarization columns.

7. The method according to claim 6, further comprising:

providing a user option to add, delete and/or correct values in the key columns and in the summarization columns; and

displaying the corrected key column values and aggregated values in the summarized table.

8. The method of claim 6 wherein the source table is selected from the group consisting of a manual input table, an electronic spreadsheet input table and a database input table.

9. The method of claim 6 further comprising:

selecting a first one or more rows of the resultant table;

selecting a second row of the resultant table; and

combining the first one or more rows with the second row, so that only the second selected row is present in the resultant table; and

recalculating the aggregated values in the resultant table which are associated with the second row to include data values from the summarization columns corresponding to any one of the rows in the first and second selections of rows.

10. The method of claim 9 further comprising displaying, the second selected row of the resultant table in a first visual style, and displaying the remaining rows of the resultant table in a second visual style.

11. The method of claim 10 further wherein the first visual style comprises a first graphical icon and the second visual style comprises one of a second graphical icon and no icon.

12. The method of claim 6 wherein the selected key columns comprise a plurality of columns and the rows of the resultant table are divided into groups of rows which have identical values for at least one but less than all of the selected key columns, and a row header is displayed in the resultant table for each of the groups of rows, the method further comprising:

receiving a first selection of one or more rows of the resultant table;

receiving a second selection of one row header of the resultant table; and

moving the first selection of one or more rows to associate them with the second selection of the one row header.

13. The method of claim 6 wherein the selected key columns include a plurality of columns, the rows in the resultant table being divided into groups of rows which have identical values for at least one but not all of the selected key columns, and wherein a row header is displayed in the resultant table for each of the groups of rows, the system further comprising:

selecting a first one or more row headers in the resultant table;

selecting a second row header in the resultant table; and

combining the first selection of one or more row headers with the second selection of the row header, so that only the selected second row header is present in the resultant table;

wherein all rows associated with the first one or more row headers are re-associated with the selected second row header.

14. A computer implemented method, executed in a processor, of creating a resultant table based on a source table comprising a plurality of rows and columns comprising cells capable of including, data values, the method comprising:

selecting a first one or more columns of the source table as key columns;

selecting a second one or more columns of the source table as summarization columns;

consolidating redundant data values in the key columns to a single set of key data values;

aggregating data values in the summarization columns associated with the single set of key data values to provide an aggregated value corresponding to the single set of key data values, wherein aggregating one or more data values comprises mathematically aggregating the one or more data values, thereby creating the resultant table;

selecting a first one or more rows of the resultant table;

selecting a second row of the resultant table;

combining the first one or more rows with the second row, so that only the second selected row is present in the resultant table; and

recalculating the aggregated values in the resultant table which are associated with the second row to include data values from the summarization columns corresponding to any one of the rows in the first and second selections of rows.

15. The method of claim 14 further comprising displaying the second selected row of the resultant table in a first visual style, and displaying the remaining rows of the resultant table in a second visual style.

16. The method of claim 15 wherein the first visual style comprises a first graphical icon and the second visual style comprises one of a second graphical icon and no icon.

17. A computer implemented method, executed in a processor, of creating a resultant table from a source table comprising a plurality of rows and columns having cells capable of including data values, the method comprising:

selecting a first two or more columns of the source table as key columns;

selecting a second one or more columns of the source table as summarization columns;

consolidating redundant data values in the key columns to a single set of key data values;

aggregating data values in the summarization columns associated with the single set of key data values to provide an aggregated value corresponding to the single set of key data values, wherein aggregating one or more data values comprises mathematically aggregating the one or more data values, thereby creating the resultant table, and wherein the rows of the resultant table are divided into groups of rows which have identical values for at least one but less than all of the selected key columns, and a row header is displayed in the resultant table for each of the groups of rows;

receiving a first selection of one or more rows of the resultant table;

receiving a second selection of one row header of the resultant table; and

moving the first selection of the one or more rows to associate them with the second selection of the one row header.

18. A computer implemented method, executed in a processor, of creating a resultant table from a source table comprising a plurality of rows and columns having cells capable of including data values, the method comprising:

selecting a first two or more columns of the source table as key columns;

selecting a second one or more columns of the source table as summarization columns;

consolidating redundant data values in the key columns to a single set of key data values;

aggregating data values in the summarization columns associated with the single set of key data values to provide an aggregated value corresponding to the single set of key data values, wherein aggregating one or more data values comprises mathematically aggregating the one or more data values, thereby creating the resultant table, and wherein the rows of the resultant table are divided into groups of rows which have identical values for at least one but less than all of the selected key columns, and a row header is displayed in the resultant table for each of the groups of rows;

selecting a first, one or more row headers in the resultant table;

selecting a second row header in the resultant table; and

combining the first selection of one or more row headers with the second selection of the row header, so that only the selected second row header is present in the resultant table;

wherein all rows associated with the first one or more row headers are re-associated with the selected second row header.

19. The method of claim 18 further comprising displaying in a first visual style the rows which originally were associated with the first one or more headers and, following said combining, are associated with the selected second row header of the resultant table, and displaying the remaining row headers of the resultant table in a second visual style.