Patent ID: 8751216

Claim:
A method for table merging with row data reduction for merged columns, the method comprising: selecting a first table of a plurality of columns and a second table of a plurality of columns for merger in a computer data processing system; matching a column of a plurality of rows in the first table with a column of a plurality of rows in the second table; determining whether the rows of the first table are the same in number as the rows of the second table and whether the matched columns include identical data in the respective ones of the rows; if it is determined that the rows of the first table are the same in number as the rows of the second table and that the matched columns include identical data in the respective ones of the rows, generating in a merged table an aggregation of the columns of the first table and the second table, but excluding in the aggregation of the columns of the merged table one of the matched columns that includes identical data in the respective ones of the rows as the other of the matched columns; and if it is determined that the rows of the first table are not the same in number as the rows of the second table or that the matched columns do not include identical data in the respective ones of the rows, generating in a merged table an aggregation of the columns of the first table and the second table in which the matching columns with disparate data are merged into a column with an aggregation of the disparate data.