RESTORING RECORDS USING A CHANGE TRANSACTION LOG
First Claim
Patent Images
1. A method comprising:
- generating a first transaction for deleting a record from a table in a database;
deleting the record from the table;
in response to the generation of the first transaction, storing a copy of the record in an entry of a transaction log before the record is deleted from the table;
generating an instruction;
restoring the record to the table after the record is deleted, wherein the record is restored in response to the generation of the instruction, wherein the record is restored in the table using the copy of the record in the transaction log entry.
1 Assignment
0 Petitions
Accused Products
Abstract
In one embodiment of the method, a first transaction is generated for deleting a record from a table of a database. In response the record is deleted from the table. Further in response to the generation of the first transaction, a copy of data of the record is stored in an entry of a transaction log before the record is deleted from the table. An instruction is then generated, and in response the record is restored to the table after the record is deleted, wherein the record is restored in the table using the copy of the data in the transaction log entry.
75 Citations
14 Claims
-
1. A method comprising:
-
generating a first transaction for deleting a record from a table in a database; deleting the record from the table; in response to the generation of the first transaction, storing a copy of the record in an entry of a transaction log before the record is deleted from the table; generating an instruction; restoring the record to the table after the record is deleted, wherein the record is restored in response to the generation of the instruction, wherein the record is restored in the table using the copy of the record in the transaction log entry. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer readable medium (CRM) storing instructions, wherein a method is implemented in response to executing the instructions, the method comprising:
-
in response to receiving a first transaction for deleting a record from a table in a database, storing a copy of the record in an entry of a transaction log before the record is deleted from the table; in response to receiving the first transaction, storing in the entry a name of the table; in response to receiving the first transaction, storing in the entry an identifier of the record within the table; in response to receiving an instruction, restoring the record to the table after the record is deleted, wherein the record is restored in the table using the entry'"'"'s copy of the record, the entry'"'"'s name of the table, and the entry'"'"'s identifier of the record in the table. - View Dependent Claims (9, 10)
-
-
11. An apparatus comprising:
-
a memory system for storing a database; a computer system comprising a memory, wherein the memory stores instructions, wherein the computer system implements a method in response to executing the instructions, the method comprising; in response to receiving a first transaction for deleting a record from a table in the database, storing a copy of the record in an entry of a transaction log before the record is deleted from the table; in response to receiving the first transaction, storing in the entry a name of the table; in response to receiving the first transaction, storing in the entry an identifier of the record within the table; in response to receiving an instruction, restoring the record to the table after the record is deleted, wherein the record is restored in the table using the entry'"'"'s copy of the record, the entry'"'"'s name of the table, and the entry'"'"'s identifier of the record in the table. - View Dependent Claims (12, 13, 14)
-
Specification