Patent ID: 7937368

Claim:
A computer implemented method for partially restoring a database block in a database system, comprising: tracking a plurality of changes that have been made to the database block by a committed transaction by using at least one or more log records; receiving a request for reversing some but not all of the plurality of changes made to the database block by the committed transaction; identifying the some but not all of the plurality of changes, wherein the act of identifying the some but not all of the plurality of changes comprises accessing the one or more log records that are associated with the committed transaction; and reversing the some but not all of the plurality of changes made by the committed transaction to the database block by applying at least a portion of the one or more log records to the database block, wherein the act of reversing the some but not all of the plurality of changes is performed by a processor while leaving one or more of the plurality of changes that are not the some but not all of the plurality of changes made by the committed transaction persisted.