Table merging with row data reduction

A computer data processing system configured for table merging with row data reduction for merged columns, the system comprising:

• a computer with at least one processor and memory;
• first and second tables loaded into the memory of the computer;
• and,
• a table merge with row data reduction module executing in the memory of the computer, the module comprising program code enabled to
• select the first and second tables for merger,
• match a column of a plurality of rows in the first table with a column of a plurality of rows in the second table,
• determine 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, generate in a merged table an aggregation of the columns of the first table and the second table, but to exclude 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, generate 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.

A computer program product for table merging with row data reduction for merged columns, the computer program product comprising:

• a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
• computer readable program code for 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;
• computer readable program code for matching a column of a plurality of rows in the first table with a column of a plurality of rows in the second table;
• computer readable program code for 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;
• computer readable program code for, 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
• computer readable program code for, 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.