Method and apparatus for synchronizing a database with a third party database

• US 7,774,307 B2
• Filed: 07/23/2002
• Issued: 08/10/2010
• Est. Priority Date: 07/24/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Yang, Yi, Wiryawan, Antonius A., Ju, Wade, Zuljevic, Zeljko
• Primary Examiner(s): Rones; Charles
• Assistant Examiner(s): Chojnacki; Mellissa M
• Application Number:
  US10/206,263
• Publication Number:
  US 20070239796A1
• Time in Patent Office: 2,940 Days
• Field of Search: 707 1- 10, 707200-206
• US Class Current: 707/616
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

In one embodiment, the present invention is a method of changing information in a first database and a second database. The method includes receiving new information. The method also includes receiving a first record from the first database, the first record corresponding to the new information. The method further includes receiving a second record from the second database, the second record corresponding to the new information. The method also includes merging the new information, the first record, and the second record into a final record.

Claims

1. A method of changing information in a first database and a second database, comprising:

receiving an update record N comprising new information to update a first record A in the first database and a second record E in the second database, wherein the first record A and the second record E correspond to the new information; and

merging the update record N, the first record A, and the second record E into a final record F so that F=N|((^N)&

A&

E)|((^(N|A))&

E)|((^(N|E))&

A).

2. The method of claim 1 further comprising:

requesting the first record A from the first database.

3. The method of claim 2 further comprising:

requesting the second record E from the second database.

4. The method of claim 3 further comprising:

updating the first record A in the first database using the contents of the final record F.

5. The method of claim 4 further comprising:

updating the second record E in the second database using the contents of the final record F.

6. The method of claim 5 further comprising:

locking the first record A of the first database; and

unlocking the first record A of the first database.

7. The method of claim 6 further comprising:

verifying the changes to the second record E in the second database.

8. The method of claim 2 further comprising:

submitting the new information to the second database.

9. The method of claim 7 wherein:

receiving the new information includes receiving the new information responsive to a submission by a user.

10. The method of claim 2 further comprising:

checking status of the second database for free status.

11. The method of claim 10 further comprising:

awaiting free status of the second database.

12. An apparatus for updating a first database and a second database comprising:

a processor to perform;

means for receiving an update record N comprising new information to update a first record A in the first database and a second record E in the second database, wherein the first record A and the second record E correspond to the new information; and

means for merging the update record N, the first record A, and the second record E into a final record F so that F=NI((^N)&

A&

E)I((^(NIA))&

E)I((^(NIE))&

A), wherein the means for merging coupled to the means for receiving.

13. The apparatus of claim 12 further comprising:

means for updating, the means for updating for updating the first record A in the first database using the contents of the final record F, and for updating the second record E in the second database using the contents of the final record F, the means for updating coupled to the means for merging.

14. The apparatus of claim 13 further comprising:

means for locking, the means for locking for locking and unlocking the first record A of the first database, the means for locking coupled to the means for receiving and the means for updating.

15. The apparatus of claim 14 further comprising:

means for verifying the changes to the second record in the second database.

16. A machine-readable medium embodying instructions executed by a processor, cause the processor to perform a method of changing information in a first database and a second database, the method comprising:

receiving an update record N comprising new information to update a first record A in the first database and a second record E in the second database, wherein the first record A and the second record E correspond to the new information; and

merging the update record N, the first record A, and the second record E into a final record F so that F=NI((^N)&

A&

E)I((^(NIA))&

E)I((^(NIE))&

A).

17. The machine-readable medium of claim 16 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

requesting the first record A from the first database; and

requesting the second record E from the second database.

18. The machine-readable medium of claim 17 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

updating the first record A in the first database using the contents of the final record F.

19. The machine-readable medium of claim 18 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

updating the second record E in the second database using the contents of the final record F.

20. The machine-readable medium of claim 18 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

submitting the new information to the second database.

21. The machine-readable medium of claim 19 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

locking the first record A of the first database; and

unlocking the first record A of the first database.

22. The machine-readable medium of claim 21 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

verifying the changes to the second record in the second database.

23. The machine-readable medium of claim 22 further embodying instructions executed by the processor, to further cause the processor to perform the method wherein:

receiving the new information includes receiving the new information responsive to a submission by a user.

24. The machine-readable medium of claim 23 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

receiving a status request from the user; and

providing status information responsive to the status request from the user.

25. The machine-readable medium of claim 24 further embodying instructions executed by the processor, to further cause the processor to perform the method further comprising:

checking status of the second database for free status; and

awaiting free status of the second database.