IP Library Granted Patent US 7,774,307
Granted Patent B2
US 7,774,307 · App. 10/206,263 · Granted Aug 10, 2010

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

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 7,774,307
App. No.
10/206,263
Granted
Aug 10, 2010
Kind
B2
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 (57)

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.

Assignments (1)
MERGER Recorded Feb 5, 2016
From: SIEBEL SYSTEMS, INC.
To: ORACLE AMERICA, INC.
Reel/Frame 037702/0505 →