Archiving-safe replication of relational data

• US 8,606,758 B2
• Filed: 09/22/2011
• Issued: 12/10/2013
• Est. Priority Date: 09/22/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Herbst, Axel
• Primary Examiner(s): Mofiz, Apu
• Assistant Examiner(s): BIBBEE, JARED M
• Application Number:
  US13/240,816
• Publication Number:
  US 20130080383A1
• Time in Patent Office: 810 Days
• Field of Search: 707/600, 707/607, 707/661, 707/667
• US Class Current: 707/667
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 7/00 Methods or arrangements for processing data by operating upon the order or content of the data handled logic circuits H03K19/00

Abstract

A computer-implemented method for archiving information includes: executing a first application in a first process; determining that the first application is an archiving application configured to archive information stored in a transactional system; assigning, based on the determination, an archiving mode to the first process; receiving, from the first process and after assigning the archiving mode, a request to delete information; and processing the request to delete information according to the archiving mode.

Claims

1. A computer-implemented method for archiving information, the method comprising:

executing a first application in a first process;

determining that the first application is a non-archiving application;

receiving, from the first process, a first request to delete first information that is stored in a transactional system, wherein information that is stored in the transactional system is periodically copied by a replication system to an analysis system;

performing, based on having determined that the first application is a non-archiving application, the first request to delete the first information without converting the first request into separate copy and delete requests;

executing a second application in a second process;

determining that the second application is an archiving application configured to archive information that is stored in the transactional system;

receiving, from the second process, a second request to delete second information that is stored in the transactional system;

converting, based on having determined that the second application is an archiving application, the second request to delete the second information that is stored in the transactional system to a new request that comprises;

(i) a copy request to copy the second information from the transactional system to an analysis system, and (ii) a delete request to delete the second information that is stored in the transactional system;

copying, according to the copy request to copy the second information from the transactional system to the analysis system, the second information from the transactional system to the analysis system; and

deleting, according to the delete request to delete the second information that is stored in the transactional system, the second information that is stored in the transactional system.

2. The computer-implemented method of claim 1, wherein determining that the second application is an archiving application comprises detecting a call to open an archive.

3. The computer-implemented method of claim 1, wherein determining that the second application is an archiving application comprises detecting a particular database connection.

4. The computer-implemented method of claim 1, wherein copying the second information from the transactional system to the analysis system includes copying the second information to the transactional system and the replication system subsequently providing the second information to the analysis system.

5. The computer-implemented method of claim 1, further comprising using, by an analysis application, the second information that has been copied to the analysis system.

6. The computer-implemented method of claim 1, wherein the new request comprises a delete-into request which comprises, in one database command, the copy request and the delete request.

7. The computer-implemented method of claim 1, wherein processing the second request to delete the second information comprises deleting information from the transactional system and not deleting information from the analysis system.

8. The computer-implemented method of claim 7,

wherein performing the first request to delete the first information includes, in addition to deleting the first information that is stored in the transactional system, 1) identifying information in the analysis system that corresponds to the first information;

and

     2) deleting the identified information from the analysis system.

9. A computer-implemented method for archiving information, the method comprising:

executing a first application in a first process of a computer system;

executing a second application in a second process of the computer system;

determining that the first application is an archiving application configured to archive information that is stored in a transactional system of the computer system;

determining that the second application is not an archiving application;

receiving, from the first process, a first request to delete first information that is stored in the transactional system;

receiving, from the second process, a second request to delete second information that is stored in the transactional system;

determining whether the computer system is configured to perform an archiving process before a replication process;

in response to determining that the computer system is configured to perform the archiving process before the replication process;

converting, based on having determined that the first application is an archiving application, the first request to delete the first information that is stored in the transactional system to a new request that comprises;

(i) a copy request to copy the first information from the transactional system to an analysis system, and (ii) a delete request to delete the first information that is stored in the transactional system;

copying, according to the copy request to copy the first information from the transactional system to the analysis system, the first information from the transactional system to the analysis system;

deleting, according to the delete request to delete the first information that is stored in the transactional system, the second information that is stored in the transactional system; and

deleting, according to the delete request to delete the second information that is stored in the transactional system, the second information that is stored in the transactional system;

in response to determining that the computer system is configured to perform the archiving process after the replication process;

deleting, based on having determined that the first application is an archiving application, the first information from the transactional system without deleting corresponding information from an analysis system;

identifying, based on having determined that the second application is not an archiving application, information in the analysis system that corresponds to the second information;

deleting, based on having determined that the second application is not an archiving application, the identified information from the analysis system; and

deleting, based on having determined that the second application is not an archiving application, the second information from the transactional system.

10. The computer-implemented method of claim 9, wherein determining that the first application is an archiving application comprises detecting a call to open an archive.

11. The computer-implemented method of claim 9, wherein determining that the first application is an archiving application comprises detecting a particular database connection.

12. A computer program product embodied in a non-transitory computer readable storage device and comprising instructions that when executed by a processor perform a method comprising:

executing a first application in a first process;

determining that the first application is a non-archiving application;

receiving, from the first process, a first request to delete first information that is stored in a transactional system, wherein information that is stored in the transactional system is periodically copied by a replication system to an analysis system;

performing, based on having determined that the first application is a non-archiving application, the first request to delete the first information without converting the first request into separate copy and delete requests;

executing a second application in a second process;

determining that the second application is an archiving application configured to archive information that is stored in the transactional system;

receiving, from the second process, a second request to delete second information that is stored in the transactional system;

converting, based on having determined that the second application is an archiving application, the second request to delete the second information that is stored in the transactional system to a new request that comprises;

(i) a copy request to copy the second information from the transactional system to an analysis system, and (ii) a delete request to delete the second information that is stored in the transactional system;

copying, according to the copy request to copy the second information from the transactional system to the analysis system, the second information from the transactional system to the analysis system; and

deleting, according to the delete request to delete the second information that is stored in the transactional system, the second information that is stored in the transactional system.

13. A system comprising:

at least one processor; and

a computer program product embodied in a non-transitory computer readable storage device and comprising instructions that when executed by the processor cause the system to perform a method comprising;

executing a first application in a first process;

determining, by the at least one processor, that the first application is a non-archiving application;

receiving, from the first process, a first request to delete first information that is stored in a transactional system, wherein information that is stored in the transactional system is periodically copied by a replication system to an analysis system;

performing, based on having determined that the first application is a non-archiving application, the first request to delete the first information without converting the first request into separate copy and delete requests;

executing a second application in a second process;

determining, by the at least one processor, that the second application is an archiving application configured to archive information that is stored in the transactional system;

receiving, from the second process, a second request to delete second information that is stored in the transactional system;

converting, based on having determined that the second application is an archiving application, the second request to delete the second information that is stored in the transactional system to a new request that comprises;

(i) a copy request to copy the second information from the transactional system to an analysis system, and (ii) a delete request to delete the second information that is stored in the transactional system;

copying, according to the copy request to copy the second information from the transactional system to the analysis system, the second information from the transactional system to the analysis system; and

deleting, according to the delete request to delete the second information that is stored in the transactional system, the second information that is stored in the transactional system.