System and method for synchronizing databases

• US 20020059299A1
• Filed: 01/23/2001
• Published: 05/16/2002
• Est. Priority Date: 07/14/2000
• Status: Abandoned Application

• Current Assignee: Creasoft
• Original Assignee: Creasoft
• Inventors: Spaey, Frederic
• Application Number:
  US09/766,637
• Publication Number:
  US 20020059299A1
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A data processing method and system including a plurality of databases linked by at least one communication channels, a synchronization set which defines the objects or records to be synchronized between the plurality of databases, and a synchronizer for each database which controls and monitors the synchronization between databases and accesses a local database to which the synchronizer is connected. Each synchronizer includes a communications module which monitors and controls the communication with other databases and at least one table synchronizer which controls and monitors the synchronization of the local database and access to the local database. Each table synchronizer includes a table synchronizer engine which handle the synchronization management for its table synchronizer, a plug-in which handle the generic database communication for its table synchronizer, and a driver which controls communication with the local database. The data processing method synchronizes data records of a source database and a destination database. The method includes defining a synchronization set for data records existing in the source database, synchronizing the source database and the destination database based on the synchronization set, and changing the definition of the synchronization set while synchronizing the source database and the destination database.

Claims

1. A data processing method for synchronizing data records of a source database and a destination database, the method comprising:

defining a synchronization set for data records existing in the source database;

synchronizing the source database and the destination database based on the synchronization set; and

changing the definition of the synchronization set while synchronizing the source database and the destination database.

2. The data processing method of claim 1, further comprising:

removing a data record from the destination database based on the step of changing the definition of the synchronization set.

3. The data processing method of claim 1, further comprising:

deleting a data record belonging to the synchronization set from the source database; and

removing the data record from the destination database based on the deleting of the data record in the source database.

4. A data processing method for synchronizing data records of a plurality of databases, the method comprising:

defining a synchronization set for data records existing in at least one of the plurality of databases;

synchronizing the plurality of databases based on the synchronization set; and

changing the definition of the synchronization set while synchronizing the plurality of databases.

5. The data processing method of claim 4, further comprising:

removing a data record from at least one of the plurality of databased on the step of changing the definition of the synchronization set.

6. The data processing method of claim 4, wherein the step of synchronizing the plurality of database includes merging data from at least two of the plurality of databases into a data record in one of the plurality of databases.

7. A data processing method for synchronizing data records of a source database and a destination database, the method comprising:

defining a synchronization for data records existing in the source database;

synchronizing the source database and the destination database based on the synchronization set; and

scanning the data records in the source database defined in the synchronization set.

8. The data processing method of claim 7, further comprising:

receiving a plurality of queries for information on data records defined in the synchronization set; and

Wherein the step of scanning includes combining the plurality of received queries before scanning the source database.

9. The data processing method for synchronizing data records of a source database and a destination database, the method comprising:

defining synchronizing set for data records existing in the source database;

synchronizing the source database and the destination database based on the synchronization set; and

creating a notification packet for each data record defined in the synchronization set and modified in the source database, the notification packet containing only an indication of modification.

10. A data processing method for synchronizing data records of a source database and a destination database, the method comprising:

defining a synchronization set for data records existing in the source database;

synchronizing the source database and the destination database based on the synchronization set; and

creating a user flag each data record defined in the synchronization set and modified in the destination database.

11. A data processing method for synchronizing data records of a source database and a destination database, the method comprising:

defining a synchronization set for data records existing in the source database;

hashing information on the data records defined by the synchronization set;

sending the hashing information to the destination database; and

synchronizing the source database and the destination database based on the synchronization set.

12. The data processing method of claim 11, further comprising:

receiving a request for hashing information on at least on data record defined by the synchronization set at the source database from the destination database; and

sending the at least one data record to the destination database.

14. The data processing method of claim 13, further comprising:

defining a query to identify a subset of the data records to synchronize from a source database for each link.

15. The data processing method of claim 13, further comprising:

defining a subset of data records fields to synchronize from a source database for each link.

16. The data processing method of claim 13, further comprising:

defining a matching between a source database field and destination database field for each link.

17. The data processing method of claim 13, further comprising:

defining a merging of a transferred data records in a destination database for each link.

18. The data processing method of claim 13, further comprising:

defining a merging of data fields in destination database records for each link.

19. The data processing method of claim 13, further comprising:

defining a field transformation function for each transferred data field.

20. The data processing method of claim 13, further comprising:

encrypting synchronized data fields at a source database and decrypting the data fields at a destination database.

21. The data processing method of claim 13, further comprising:

keeping synchronization information for each data record of a synchronized database;

comparing the synchronization information between linked databases for each link; and

sending the data records from a source database to a destination database, based on the comparison for each link.

22. The data processing method of claim 21, further comprising:

restarting the step of comparing when a synchronization link is broken and reestablished.

23. The data processing method of claim 21, further comprising:

keeping a unique global ID for each synchronized data record.

24. The data processing method of claim 21, further comprising:

keeping a hashed value for each data field in the synchronized records;

keeping a modification time for each data field in the synchronized records; and

updating the modification time when the hashed value is changed.

25. The data processing method of claim 21, further comprising:

updating the synchronization information by scanning the plurality of databases.

26. The data processing method of claim 25, further comprising:

combining a query of multiple synchronization links into one query for scanning.

27. The data processing method of claim 21, further comprising:

updating the synchronization information when receiving database change notifications.

28. The data processing method of claim 27, further comprising:

activating the step of updating based on the status of synchronization information, while synchronizing.

29. The data processing method of claim 21, further comprising:

keeping a user flag for each field in the synchronized records.

30. The data processing method of claim 13, further comprising:

adding, removing or changing a synchronization link definition while synchronizing the plurality of databases.

31. The data processing method of claim 30, further comprising:

adding records or fields into records in a destination database when a synchronization link is added or changed.

32. The data processing method of claim 30, further comprising:

removing records or fields from a destination database when a synchronization link is removed or changed.

33. The data processing method of claim 32, further comprising:

protecting a field from removal based on a status of a user flag.

34. The data processing method of claim 13, further comprising:

protecting the plurality of database coherence by transferring all modified fields of a logical record together.

35. The data processing method of claim 13, further comprising:

accessing shared synchronized databases while other processes or applications are modifying the synchronized databases.

36. The data processing method of claim 13, further comprising:

keeping meta-data information for each synchronized database.

37. The data processing method of claim 13, further comprising:

merging all synchronization information for a synchronized database into an information database, the information being synchronization links information, record synchronization information, and meta-data information.

38. The data processing method of claim 37, further comprising:

synchronizing information database of linked synchronized databases; and

creating synchronization links between the information databases.

39. The data processing method of claim 13, further comprising:

creating a destination database for each synchronization link; and

changing a destination database structure for each synchronization link.

13. A data processing method for synchronizing data records of a plurality of databases, the method comprising:

defining synchronization links for a unidirectional synchronized data transfer between any two of the plurality of databases;

defining a combination of the synchronization links, for synchronizing a plurality of databases;

synchronizing the databases; and

applying the database record changes to all the linked databases.

40. A computer system configured to synchronize data records of a source database and a destination database, the system comprising:

a processor; and

a memory coupled to said processor;

the memory having stored therein sequences of instructions which, when executed by said processor, cause said processor to synchronize data records of the source database and the destination database by causing the processor to perform the steps of;

defining a synchronization set for data records existing in the source database;

synchronizing the source database and the destination database based on the synchronization set; and

changing the definition of the synchronization set while synchronizing the source database and the destination database.

41. An article of manufacture that includes a medium readable by a processor, the medium having stored thereon a plurality of sequences of instructions, said plurality of sequences of instructions including sequences of instructions which, when executed by a processor, cause said processor to perform the steps of:

defining a synchronization set for data records existing in a source database;

synchronizing the source database and a destination database based on the synchronization set; and

changing the definition of the synchronization set while synchronizing the source database and the destination database.