Patent ID: 7281023
Filing Date: 2007-10-09
Classification: G06F,Y10S

Abstract:
1. A method of rollbacking a transaction id set in a plurality of tables of an active database, each of the plurality of tables having a before image table and an after image table, the method comprising: retrieving an earliest starting time of the transaction id set; retrieving a latest retention time for each of the plurality of tables; determining that the earliest starting time is greater than the latest retention time; locking each of the plurality of tables to be rollbacked and disabling associated referential integrity constraints; deleting rows from each of the after image tables having an after image table transaction id that is a member of the transaction id set; selecting earliest before image rows from each of the before image tables having a before image table transaction id that is a proper subset of the transaction id set, or having a changing transaction id that is a proper subset of the transaction id set, and having an earliest timestamp; deleting any after image of a row from each of the after image tables when the after image table transaction id of the row is a proper subset of the transaction id set and a changing transaction id of the row is not equal to a current transaction id; deleting any after image of a row from each of the after image tables and inserting the earliest before image from the row into each of the after image tables when a transaction id of the row is not a proper subset of the transaction id set and the changing transaction id is a proper subset of the transaction id set; and activating the associated referential integrity constraints.