IP Library Granted Patent US 8,818,947
Granted Patent B2
US 8,818,947 · App. 13/298,212 · Granted Aug 26, 2014

Landscape transformation replication server

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,818,947
App. No.
13/298,212
Granted
Aug 26, 2014
Kind
B2
Abstract

Methods and apparatus, including computer program products, are provided for data replication. In one aspect, there is provided a computer-implemented method. The method may include providing an initial load of a data item from a source system to a target system, wherein the data item is associated with a trigger maintained at the source system; recording a change in a log, when a change to the data item at the source system causes the trigger to prompt the recording; extracting the change from the log to enable at least a confirmation of a consistency of the change; and providing the extracted change to a replication server configured to write the change to the target system. Related apparatus, systems, methods, and articles are also described.

Claims (45)

1. A computer-readable storage medium containing instructions to configure a processor to perform a method, the method comprising:

providing, by a source system, an initial load of a data item from the source system to a target system, wherein the data item is associated with a database trigger maintained at the source system;

recording, by the source system, a change in a log at the source system, when a change to the data item at the source system causes the trigger to prompt the recording;

extracting, by the source system, the change from the log to enable at least a confirmation of an accuracy of the change;

receiving, at the source system, a call from a replication server; and

providing, in response to the received call, the extracted change to the replication server configured to write the change to the target system.

2. The computer-readable storage medium of claim 1 , wherein the database trigger comprises a database object linked to a table including the data item.

3. The computer-readable storage medium of claim 1 , wherein the providing the initial load further comprises:

writing the data item to a database table at the target system.

4. The computer-readable storage medium of claim 3 , wherein the database table comprises at least one of a plurality of database tables of at least one of an in-memory database and a column-oriented database.

5. The computer-readable storage medium of claim 1 further comprising:

initialing, by the replication server, the initial load of the data item from the source system to the target system, wherein the replication server comprises at least a controller.

6. The computer-readable storage medium of claim 1 , wherein the change comprises at least one of an insert, a create, and a delete.

7. The computer-readable storage medium of claim 1 , wherein the extracting further comprises:

determining the consistency based on a comparison of the log and a table including the data item at the source system.

8. A method comprising:

providing, by a source system, an initial load of a data item from the source system to a target system, wherein the data item is associated with a database trigger maintained at the source system;

recording, by the source system, a change in a log at the source system, when a change to the data item at the source system causes the trigger to prompt the recording;

extracting, by the source system, the change from the log to enable at least a confirmation of an accuracy of the change;

receiving, at the source system, a call from a replication server; and

providing, in response to the received call, the extracted change to the replication server configured to write the change to the target system.

9. The method of claim 8 , wherein the database trigger comprises a database object linked to a table including the data item.

10. The method of claim 8 , wherein the providing the initial load further comprises:

writing the data item to a database table at the target system.

11. The method of claim 10 , wherein the database table comprises at least one of a plurality of database tables of at least one of an in-memory database and a column-oriented database.

12. The method of claim 8 further comprising:

initialing, by the replication server, the initial load of the data item from the source system to the target system, wherein the replication server comprises at least a controller.

13. The method of claim 8 , wherein the change comprises at least one of at least one of an insert, a create, and a delete.

14. The method of claim 8 , wherein the extracting further comprises:

determining the consistency based on a comparison of the log and a table including the data item at the source system.

15. A system comprising:

at least one processor; and

at least one memory including code which when executed by the at least one processor provides operations comprising:

providing, by a source system, an initial load of a data item from the source system to a target system, wherein the data item is associated with a database trigger maintained at the source system;

recording, by the source system, a change in a log at the source system, when a change to the data item at the source system causes the trigger to prompt the recording;

extracting, by the source system, the change from the log to enable at least a confirmation of an accuracy of the change;

receiving, at the source system, a call from a replication server; and

providing, in response to the received call, the extracted change to the replication server configured to write the change to the target system.

16. The system of claim 15 , wherein the database trigger comprises a database object linked to a table including the data item.

17. The system of claim 15 , wherein the providing the initial load further comprises:

writing the data item to a database table at the target system.

18. The system of claim 15 , wherein the database table comprises at least one of a plurality of database tables of at least one of an in-memory database and a column-oriented database.

19. The system of claim 15 further comprising:

initialing, by the replication server, the initial load of the data item from the source system to the target system, wherein the replication server comprises at least a controller.

20. The system of claim 15 , wherein the change comprises at least one of at least one of an insert, a create, and a delete.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 29, 2013
From: GUTBERLET, WOLFGANG; DASCHAKOWSKY, KLAUS; WEBER, GUENTER; MERKEL, JOCHEN
To: SAP AG
Reel/Frame 030507/0328 →