Method and mechanism for identifying transaction on a row of data
First Claim
Patent Images
1. 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, whereinthe 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, whereinthe 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.
0 Assignments
0 Petitions
Accused Products
Abstract
A method and mechanism for identifying one or more transactions that have modified or created an object in a database system. Also disclosed is a method and mechanism to compensate for the effects of a transaction in a database system is disclosed. The disclosed approach can be applied to perform auditing for changes and/or transactions in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
-
Citations
20 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 18, 19, 20)
-
-
12. A computer program product comprising a tangible computer usable storage medium having executable code, which when executed by a processor, causes the processor to execute a process for partially restoring a database block in a database system, the process comprising the actions of:
-
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 the 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. - View Dependent Claims (14, 15)
-
-
13. A system for partially restoring a database block in a database system, comprising:
-
a computer system which comprises at least one processor and is programmed for performing at least; 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 processor configured for identifying the some but not all of the plurality of changes is further configured for accessing 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 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 by applying at least a portion of the one or more log records to the database block. - View Dependent Claims (16, 17)
-
Specification