Patent ID: 7251650

Claim:
A method for processing input data comprising: receiving multiple input rows to be loaded into a first structure, wherein the first structure is an output table; processing each input row of the multiple input rows to classify each input row as one of an insert row and an update row, wherein input duplicates are appended to the first structure and index entries for the input duplicates are stored in a second structure, wherein an insert row is a row to be added to the first structure and an update row is an update to an existing row in the first structure, wherein input duplicates are duplicate input rows having a same primary key value, and wherein, of the input rows having the same primary key value, one is an original row; and after the multiple input rows have been processed, automatically re-applying the input duplicates to the first structure by removing the input duplicates from the first structure and applying the input duplicates to matching original rows in the first structure to update the matching original rows; and merging index entries from the index entries stored in the second structure to a primary key index.