System and method for synchronizing data repositories

• US 20040064484A1
• Filed: 09/05/2003
• Published: 04/01/2004
• Est. Priority Date: 09/30/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Yeung, Alice T., Polan, Michael G.
• Granted Patent: US 7,296,035 B2
• Time in Patent Office: Days
• US Class Current: 707/200
• 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: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A system and method for synchronizing a first data repository with a second data repository is disclosed. The method includes: a) detecting a change to data in the first data repository; b) communicating the change from the first data repository to the second data repository via the Internet using SOAP over HTTP; and c) updating data in the second data repository with the change. The system includes a first computing device which communicates with the first data repository and a second computing device which communicates with the second data repository. The first computing device detects a change to data in the first data repository and communicates the change to the second computing device via the Internet using SOAP over HTTP. The second computing device updates data in the second data repository with the change.

Claims

1. A method of synchronizing a first data repository with a second data repository, comprising:

(a) detecting a change to data in said first data repository; and

(b) communicating said change from said first data repository to said second data repository via the Internet.

2. The method of claim 1, wherein step (b) further comprises:

(b.1) communicating said change using Simple Object Access Protocol.

3. The method of claim 2, wherein step (b.1) further comprises:

(b.1.1) communicating said change using Simple Object Access Protocol over Hypertext Transfer Protocol.

4. The method of claim 1, further comprising:

(c) updating data in said second data repository with said change.

5. The method of claim 4, wherein said first data repository is in communication with a first client and said second data repository is in communication with a server.

6. The method of claim 5, wherein step (a) further comprises:

(a.1) detecting a change to data in said first data repository via said first client.

7. The method of claim 6, wherein step (b) further comprises:

(b.1) sending said change to said server via said first client.

8. The method of claim 7, wherein step (b.1) further comprises:

(b.1.1) sending said change to said server via a remote procedure call.

9. The method of claim 5, wherein step (c) further comprises:

(c.1) updating said data in said second data repository with said change via said server.

10. The method of claim 5, further comprising:

(d) communicating said change from said server to a second client in communication with a third data repository.

11. The method of claim 10, wherein step (d) further includes:

(d.1) determining whether said second data repository includes data relating to said change via said server and prior to communicating said change to said second client.

12. A system for synchronizing a first data repository with a second data repository, comprising:

a) a first computing device to communicate with said first data repository; and

b) a second computing device to communicate with said second data repository;

wherein said first computing device is configured to detect a change to data in said first data repository and to communicate said change to said second computing device via the Internet, and wherein said second computing device is configured to update data in said second data repository with said change.

13. The system of claim 12, wherein said first and second computing devices are configured to communicate using Simple Object Access Protocol.

14. The system of claim 13, wherein said first and second computing devices are configured to communicate using Simple Object Access Protocol over Hypertext Transfer Protocol.

15. The system of claim 12, wherein said first computing device comprises a server, and said second computing device comprises a first client.

16. The system of claim 12, wherein said first computing device comprises a first client, and said second computing device comprises a server.

17. The system of claim 16, wherein said first client comprises:

a change detection module to communicate with said first data repository and to detect said change to data in said first data repository;

a routing module in communication with said change detection module to determine recipients for receiving said change; and

a client communications module to communicate said change to said second computing device.

18. The system of claim 17, wherein said server comprises:

a server communications module to receive said change from said client communications module;

a mapping module in communication with said server communications module to associate said change with corresponding data in said second repository; and

an update module to communicate with said second data repository and update said second data repository with said change.

19. The system of claim 18, wherein said client communications module sends said change to said server communications module via a remote procedure call.

20. The system of claim 16, wherein said second computing device further comprises a second client loaded thereon to communicate changes to said first computing device and said first computing device further comprises a second server loaded thereon to update said first data repository with data received from said second computing device.

21. A program product apparatus having a computer readable medium with computer program logic recorded thereon for synchronizing a first data repository with a second data repository, said program product apparatus comprising:

a change detection module to detect a change to data in said first data repository; and

a communication module to communicate said change from said first data repository to said second data repository via the Internet.

22. The program product apparatus of claim 21 wherein said communication module includes:

a Simple Object Access Protocol module to communicate said change using Simple Object Access Protocol.

23. The program product apparatus of claim 22 wherein said communication module further includes:

a Hypertext Transfer Protocol module to communicate said change using Simple Object Access Protocol over Hypertext Transfer Protocol.