METHOD AND SYSTEM FOR SYNCHRONIZATION OF DATABASES

• US 20090287726A1
• Filed: 09/18/2006
• Published: 11/19/2009
• Est. Priority Date: 04/07/2006
• Status: Abandoned Application

• Current Assignee: MAG Productions Holding B.V.
• Original Assignee: MAG Productions Holding B.V.
• Inventors: Verhoeven, Martijn
• Application Number:
  US12/296,298
• Publication Number:
  US 20090287726A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

The invention relates to a method for synchronization of source data sets of a source database stored on a source system with representative target data sets in a target database database database stored on a target system, the source data sets being of a first type and the target data sets being of a second type. The source data sets are compared with the previous source data sets to obtain difference source data sets of the first type. The difference source data sets are transformed into transformed data sets of the second type and supplied to the target system to enable updating of the representative target data sets. Preferably, the transformation is performed via data sets of a third type, which allows to implement external business generation. To add fully transparent a new source of target database to a business information system using the method only the conversion from data type of the new source database to data sets of third type and/or conversion from data sets of third type to data type of target database has to be developed.

Claims

1-12. -12. (canceled)

13. A method for synchronization of source data sets of a source database stored on a source system with representative target data sets in a target database stored on a target system, the source data sets being of a first type and the target data sets being of a second type, the method comprising:

(a) retrieving source data sets;

(b) retrieving previous source data sets from a first memory;

(c) comparing the source data sets with the previous source data sets to obtain difference source data sets of the first type;

(d) replacing in said first memory the previous source data sets with the source data sets;

(e) transforming the difference source data sets into transformed data sets of the second type;

(f) supplying the transformed data sets to the target system to enable updating of the representative target data sets.

14. The method according to claim 13, wherein the method further comprises repeatedly performing the actions.

15. The method according to claim 13, wherein the transforming action (e) comprises:

(e1) converting the difference source data sets into intermediate data sets of a third type;

(e2) retrieving data from the intermediate data sets to obtain the transformed data set.

16. The method according to claim 15, wherein the data sets of the third type comprises data fields for storing a representation of at least a part of the data fields of a data set of the first type and data fields representative for data fields of a data set of the second type.

17. The method according to claim 15, wherein the data sets of the third type comprises a data field with content being a copy of content of a data field of the source data set and a data field with content being a representation of said content of said data field of the source data set.

18. The method according to claim 13, wherein comparing (c) comprises:

(c1) retrieving a new data set of the first type from the source database;

(c2) searching for a corresponding previous data set stored in a second memory;

(c3) if a corresponding previous data set is not found in (c2) storing the new data set from the source database in the second memory;

(c4) if a corresponding previous data set is found in (c2) perform;

(c4a) supplying a difference source data set obtained from the new data set if the new data set differs from the corresponding previous data set; and

(c4b) removing corresponding previous data set from second memory.

19. The method according to claim 18, wherein comparing (c) comprises:

(c5) retrieving a previous data set of the first type from the previous source database;

(c6) searching for a corresponding new data set stored in the second memory;

(c7) if a corresponding new data set is not found in (c6) storing the corresponding previous data set from the first in the second memory;

(c8) if a corresponding previous data set is found in (c6) perform;

(c8a) supplying a difference source data set obtained from the new data set if the new data set differs from the corresponding previous data set; and

(c8b) removing corresponding new data set from second memory.

20. The method according to claim 13 comprising:

(g) controlling the actions (a) and (b) in dependence of the number of retrieved new source data sets and the number of retrieved previous source data sets.

21. The method according to claim 13, wherein a source data set comprises a static data part and a dynamic data part, and the actions (a)-(f) being performed independently for the static data part and the dynamic data part.

22. The method as claimed in claim 21, wherein a difference source data set corresponding to a dynamic data part comprises a status indication flag, wherein transforming (f) of a difference source data set corresponding to a dynamic data part is performed under control of the status indication flag.

23. A computer program product in a processor readable storage medium, comprising computer executable instructions which instructions when executed on at least one processor perform the method comprising:

(a) retrieving source data sets;

(b) retrieving previous source data sets from a first memory;

(c) comparing the source data sets with the previous source data sets to obtain difference source data sets of the first type;

(d) replacing in said first memory the previous source data sets with the source data sets;

(e) transforming the difference source data sets into transformed data sets of the second type;

(f) supplying the transformed data sets to the target system to enable updating of the representative target data sets.

24. A computing system for synchronization of source data sets of a source database with representative target data sets in a target database, the computing system comprising:

input means (302) for receiving source data sets from a source system;

at least one processor (318) for generating a transformed data sets;

a processor readable storage medium (312) comprising executable instructions which instructions when executed on said at least one processor perform the method comprising;

(a) retrieving source data sets;

(b) retrieving previous source data sets from a first memory;

(c) comparing the source data sets with the previous source data sets to obtain difference source data sets of the first type;

(d) replacing in said first memory the previous source data sets with the source data sets;

(e) transforming the difference source data sets into transformed data sets of the second type;

(f) supplying the transformed data sets to the target system to enable updating of the representative target data sets;

output means (308) for supplying the transformed data sets to a target system to enable updating of the representative target data sets.