Patent ID: 6959301

Claim:
A method of undoing changes made to the content of at least one database, comprising the steps of: (1) storing data in a database; (2) performing a plurality of loads to said database, wherein the load data comprises a load table and the database comprises a target table, and wherein the database table rows and the load table rows are correlated via a primary key; and (3) undoing at least one of said plurality of loads, wherein the resulting content of the database reflects the data as if the undone load had not been performed, and wherein performing a load in step (2) comprises the steps of: i. inserting rows into the target with new key values; ii. updating rows in the target table with existing key values; and iii. deleting rows from the target table when a row's key value does not exist in the load table, wherein during step (2) i., when inserting a row with a primary key which at some point in the past was deleted prior to said load, those columns for which the load does not contain data are set to the values that they had when the row was last deleted.