Restoring records using a change transaction log

• US 9,594,794 B2
• Filed: 10/19/2007
• Issued: 03/14/2017
• Est. Priority Date: 10/19/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Gutlapalli, Hari K., Kothari, Shirish K., Mehta, Suhas R., Pak, Wai
• Primary Examiner(s): Wu, Yicun
• Application Number:
  US11/875,495
• Publication Number:
  US 20090106325A1
• Time in Patent Office: 3,434 Days
• Field of Search: 707/615, 707/999.2, 707/696
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27

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.

Claims

1. A method comprising:

detecting, by a transaction monitor executing on a computer system that also executes an application, a first transaction configured to delete a record stored in a database;

in response to the detection of the first transaction, storing, by the transaction monitor, a copy of the record in an entry of a transaction log before the record is deleted;

in response to the detection of the first transaction, generating, by the transaction monitor, a first message, which is configured to indicate to a search engine in data communication with the application, that an update to a search index related to the database is needed to reflect the deletion;

transmitting the first message to the search engine;

causing deletion of one or more instances of an index identifier of the record from the search index;

receiving an instruction configured to restore the record in the database, after the record has been deleted; and

in response to the receipt of the instructions, restoring the record in the database using only the copy of the record in the transaction log entry that comprises all information needed to restore the record in the database.

2. The method of claim 1,

wherein the first message comprises a table name and an identifier of the record in a table of the database.

3. The method of claim 2, further comprising:

generating an index identifier of the record using the table name and the identifier of the record in the table of the database.

4. The method of claim 1, further comprising:

adding a name of a table in the database to the entry of the transaction log; and

adding an identifier of the record to the entry, wherein

the record is restored using the name and the identifier of the record in the table.

5. The method of claim 1, further comprising:

in response to receiving the instructions, generating a second message which comprises a table name and an identifier of the record in a table of the database, and information that indicates that the record has been restored into the table; and

transmitting the second message to the search engine.

6. The method of claim 5, further comprising:

adding one or more instances of an index identifier of the record to the search index, in response to receiving the second message.

7. The method of claim 1, wherein

the receiving and the restoring are performed by the transaction monitor.

8. The method of claim 1, wherein

the transaction monitor is in data communication with the transaction log.

9. The method of claim 1, wherein

the application is in data communication with a memory,

the memory stores the database,

the database comprise one or more tables,

the one or more tables comprises the table, and

each of the one or more tables stores one or more records.

10. The method of claim 2, wherein

the first message comprises information related to a table in the database, where the record is stored.

11. The method of claim 1, wherein the entry of the transaction log comprises:

an action type that indicates the deletion of the record from the database,

a table name,

a row number,

a timestamp, and

all data contents of the record.

12. A non-transitory computer-readable storage medium storing instructions, wherein a method is implemented in response to executing the instructions, the method comprising:

detecting, by a transaction monitor executing on a computer system that also executes an application, a first transaction configured to delete a record stored in a database;

in response to the detection of the first transaction, storing, by the transaction monitor, a copy of the record in an entry of a transaction log before the record is deleted;

in response to the detection of the first transaction, generating, by the transaction monitor, a first message, which is configured to indicate to a search engine in data communication with the application, that an update to a search index related to the database is needed to reflect the deletion;

transmitting the first message to the search engine;

causing deletion of one or more instances of an index identifier of the record from the search index;

receiving an instruction configured to restore the record in the database, after the record has been deleted; and

in response to the receipt of the instruction, restoring the record in the database using only the copy of the record in the transaction log entry that comprises all information needed to restore the record in the database.

13. The non-transitory computer-readable storage medium of claim 12, wherein

the first message comprises a table name and an identifier of the record in a table of the database, and

wherein the method further comprises:

in response to the receipt of the instruction, generating a second message, which comprises the table name, the identifier of the record in the table, and information that indicates that the record has been restored into the table; and

transmitting the second message to the computer system search engine.

14. The non-transitory computer readable storage medium of claim 12, wherein

the receiving and the restoring are performed by the transaction monitor, and

the transaction monitor is configured to be in data communication with the transaction log.

15. The non-transitory computer readable storage medium of claim 12, wherein

the application is configured to be in data communication with a memory,

the memory stores the database,

the database comprise one or more tables,

the one or more tables comprises the table, and

each of the one or more tables stores one or more records.

16. The non-transitory computer readable storage medium of claim 12, wherein the entry of the transaction log comprises:

an action type that indicates the deletion of the record from the database,

a table name,

a row number,

a timestamp, and

all data contents of the record.

17. An apparatus comprising:

a memory system, wherein

the memory system is configured to store a database; and

a computer system comprising a memory, wherein the memory stores instructions, and the computer system implements a method in response to executing the instructions, the method comprising

detecting, by a transaction monitor executing on the computer system that also executes an application, a first transaction configured to delete a record stored in the database,

in response to the detection of the first transaction, storing, by the transaction monitor, a copy of the record in an entry of a transaction log before the deletion is performed,

in response to the detection of the first transaction, generating, by the transaction monitor, a first message, which is configured to indicate to a search engine in data communication with the application, that an update to a search index related to the database is needed to reflect the deletion,

transmitting the first message to the search engine,

causing deletion of one or more instances of an index identifier of the record from the search index,

receiving an instruction configured to restore the record in the database, after the record has been deleted, and

in response to the receipt of the instruction, restoring the record in the database using only the copy of the record in the transaction log entry that comprises all information needed to restore the record in the database.

18. The apparatus of claim 17, wherein

the first message comprises a table name and an identifier of the record in a table of the database to the search engine,

wherein the method further comprises:

in response to the receipt of the instruction, generating a second message,

which comprises the table name, the identifier of the record in the table, and information that indicates that the record has been restored into the table, and

transmitting the second message to the search engine.

19. The apparatus of claim 17, wherein

the receiving and the restoring are performed by the transaction monitor, and

the transaction monitor is configured to be in data communication with the transaction log.

20. The apparatus of claim 17, wherein

the application is configured to be in data communication with the memory,

the database comprises one or more tables,

the one or more tables comprise the table, and

each of the one or more tables stores one or more records.

21. The apparatus of claim 17, wherein the entry of the transaction log comprises:

an action type that indicates the deletion of the record from the database,

a table name,

a row number,

a timestamp, and

all data contents of the record.