Database Synchronizer

• US 5,926,816 A
• Filed: 10/09/1996
• Issued: 07/20/1999
• Est. Priority Date: 10/09/1996
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Bodge, Andrew, Huberman, Steven, Bauer, Jonathan A.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Alam, Hosain T.
• Application Number:
  US08/727,294
• Time in Patent Office: 1,014 Days
• Field of Search: 707/8-10, 707/201-203, 355/200, 355/78, 395/200.78
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A database synchronizer facilitates computing systems which have client-side and server-side applications that share data in similar database structures, but which do not maintain a continuous connection to a single shared data source. In general, a database synchronizer is used to share data among many nodes on the computing system. The database synchronizer is used to synchronize the data in a central database for a particular client with the data on that client'"'"'s intermittently-connected computer. Updates performed by either client or server are propagated to the other side when a connection is established and eventually from the server to other clients in the system.

Claims

1. A method of synchronizing values of data items on a plurality of computers, comprising the steps of:

storing a data item having a value at a first computer;

at the first computer, maintaining a log of modification operations to the value of the data item, the value of the data item being modifiable by the first computer and in response to actions at a plurality of computers, including at a second computer;

at the first computer, deriving a single effective operation from a plurality of modification operations maintained in the log, the effective operation yielding the same result on the value of the data item as would the plurality of modification operations; and

using the effective operation to synchronize the value of the data item at the first computer with a value of a replica data item stored at the second computer.

2. The method of claim 1 wherein the step of maintaining a log comprises the steps of:

determining the class of a respective modification operation; and

based on the class, logging a value of the data item in the log, the logged value being either a before-value or an inserted value.

3. The method of claim 1 wherein the step of deriving comprises iteratively processing the modification operations in the log.

4. The method of claim 1 further comprising the step of detecting a conflict between modifications to the value of the data item and the value of the replica data item using the effective operation.

5. The method of claim 4 wherein the step of detecting comprises:

determining a deduced modification operation to propagate the value of the replica data item from the second computer to the first computer; and

comparing the effective operation with the deduced modification operation to yield a conflict state.

6. The method of claim 5 wherein the modification operations include an operation from the group consisting of an insert, a delete and an update operation.

7. A system for synchronizing values of data items on a plurality of computers, comprising:

a value of a data item stored at a first computer;

a log of modification operations to the value of the data item maintained at the first computer, the value of the data item being modifiable by the first computer and in response to actions at a plurality of computers, including at a second computer;

an effective operation derived at the first computer from a plurality of modification operations in the log, the effective operation calculated to yield the same result to the value of the data item as would the plurality of modification operations; and

a database synchronizer to synchronize the value of the data item with a value of a replica data item stored on the second computer using the effective operation.

8. The system of claim 7 wherein the log comprises a class of a respective modification operation and a logged value of the data item, the logged value being either a before value or an inserted value based on the class.

9. The system of claim 7 wherein the effective operation comprises an iterative processing of the modification operations in the log.

10. The system of claim 7 wherein the database synchronizer comprises a conflict detector to detect a conflict between modifications to the value of the data item and the value of the replica data item using the effective operation.

11. The system of claim 10 wherein the conflict detector comprises:

a deduced modification operation calculated to propagate the value of the replica data item from the second computer to the first computer; and

a conflict state yielded from comparing the effective operation with the deduced modification operation.

12. The system of claim 11 wherein the modification operations are selected from the group of operations consisting of an insert, a delete and an update operation.

13. A method of synchronizing values of data items on a plurality of computers, comprising the steps of:

maintaining a first copy of a data item at a first computer;

maintaining a replica copy of the data item at a second computer, the value of the replica copy differing from the value of the first copy;

at the first computer, maintaining a log of modification operations to the value of the first copy, the value of the first copy being modifiable by the first computer and in response to actions at the second computer;

at the first computer, deriving an effective operation from a plurality of modification operations maintained in the log, the effective operation yielding the same result on the value of the first copy as would the plurality of modification operations;

from the effective operation, deducing at the first computer a before value of the replica copy stored at the second computer;

at the first computer, detecting a conflict between modification to the values of the first copy and the replica copy using the deduced before value; and

applying the effective operation to resolve the conflict.

14. The method of claim 13 wherein the plurality of computers form a client-server computing system, the first computer being a server and the second computer being a client.

15. The method of claim 13 wherein the step of maintaining a first copy comprises the steps of:

defining a database structure having plurality of organized data fields; and

storing the current value of the first copy in a data field of the database.

16. The method of claim 13 wherein the step of maintaining a log comprises the steps of:

determining the class of a respective modification operation; and

based on the class, logging a value of the first copy in the log, the logged value being either a before value or an inserted value of the first copy.

17. The method of claim 13 wherein the step of determining an effective operation comprises an iterative processing of the modification operations in the log and a determination of the existence of a value for the first copy stored on the first computer.

18. The method of claim 13 wherein the step of detecting a conflict comprises the steps of:

determining a deduced modification operation to propagate the value of the replica copy from the second computer to the first computer; and

comparing the effective operation with the deduced modification operation to yield a conflict state.

19. The method of claim 18 wherein the step of applying the effective operation comprises selecting a solution to the conflict based on the conflict state.

20. A system for synchronizing values of data items on a plurality of computers, comprising:

a first copy of a data item at a first computer;

a replica copy of the data item on a second computer, the value of the replica copy differing from the value of the first copy;

a log of modification operations to the value of the first copy maintained on the first computer, the value of the first copy being modifiable by the first computer and in response to actions at the second computer;

an effective operation derived at the first computer from a plurality of modification operations in the log, the effective operation calculated to yield the same result to the value of the first copy as would the plurality of modification operations;

a deduced before value of the replica copy derived at the first computer from the effective operation;

at the first computer, a conflict detector for detecting a conflict between modifications to the values of the first copy and the replica copy from the deduced before value; and

a conflict resolver for applying the effective operation to resolve the conflict.

21. The system of claim 20 wherein the plurality of computers form a client-server computing system, the first computer being a server and the second computer being a client.

22. The system of claim 20 further comprising a database structure having a plurality of data fields, the current value of the first copy being stored in a data field of the database.

23. The system of claim 20 wherein the log comprises a logged value of the first copy, the logged value being either a before value or an inserted value of the first copy based on a determined class of the respective modification operation.

24. The system of claim 20 wherein the effective operation comprises an iterative processing of the modification operations in the log and a determination of the existence of a value for the first copy on the first computer.

25. The system of claim 20 wherein the conflict detector comprises:

a deduced modification operation calculated to propagate the value of the replica copy from the second computer to the first computer; and

a conflict state derived from a comparison of the effective operation with the deduced modification operation.

26. The system of claim 25 wherein the conflict resolver applies the effective operation by selecting a solution to the conflict based on the conflict state.

27. A method of synchronizing values of data items on a plurality of computers, comprising the steps of:

maintaining a first copy of a data item at a first computer;

maintaining a replica copy of the data item at a second computer, the value of the replica copy differing from the value of the first copy;

at the first computer, maintaining a log of modification operations to the value of the first copy, the value of the first copy being modifiable by the first computer and in response to actions at the second computer;

at the first computer, deriving an effective operation from a plurality of modification operations maintained in the log, the effective operation yielding the same result on the value of the first copy as would the plurality of modification operations;

at the first computer, detecting a conflict between the values of the first copy and the replica copy;

from the effective operation, deducing the value of the replica copy stored on the second computer; and

forming a propagation operation from the effective operation to modify the value of the replica copy on the second computer to be in synchronization with the value of the first copy on the first computer.

28. The method of claim 27 wherein the step of maintaining a first copy comprises:

defining a database structure having plurality of organized data fields; and

storing the current value of the first copy in a data field of the database.

29. The method of claim 27 wherein the step of maintaining a log comprises the steps of:

determining the class of a respective modification operation; and

based on the class, logging a value of the first copy in the log, the logged value being either a before value or an inserted value of the first copy.

30. The method of claim 27 wherein the step of determining an effective operation comprises iteratively processing the modification operations in the log and a determination of the existence of a value for the first copy stored on the first computer.

31. The method of claim 27 wherein the step of detecting a conflict comprises the steps of:

determining a deduced modification operation to propagate the value of the replica copy from the second computer to the first computer; and

comparing the effective operation with the deduced modification operation to yield a conflict state.

32. The method of claim 31 wherein the step of forming the propagation operation further comprises selecting a solution to the conflict based on the conflict state.

33. A system for synchronizing values of data items on a plurality of computers, comprising:

a first copy of a data item stored at a first computer;

a replica copy of the data item stored at a second computer, the value of the replica copy differing from the value of the first copy;

a log of modification operations to the value of the first copy maintained at the first computer, the value of the first copy being modifiable by the first computer and in response to actions at the second computer;

an effective operation derived at the first computer from a plurality of modification operations in the log, the effective operation calculated to yield the same result to the value of the first copy as would the plurality of modification operations;

at the first computer, a conflict detector for detecting a conflict between the values of the first copy and the replica copy;

a deduced value of the replica copy derived from the effective operation; and

a conflict resolver for forming a propagation operation from the effective operation to modify the value of the replica copy on the second computer to be in synchronization with the value of the first copy on the first computer.

34. The system of claim 33 further comprising a database structure having a plurality of data fields, the current value of the first copy being stored in a data field of the database.

35. The system of claim 33 wherein the log comprises a logged value of the first copy, the logged value being either a before value or an inserted value of the data item based on a determined class of the respective modification operation.

36. The system of claim 33 wherein the effective operation comprises an iterative processing of the modification operations in the log and a determination of the existence of a value for the first copy on the first computer.

37. The system of claim 33 wherein the conflict detector comprises:

a deduced modification operation calculated to propagate the value of the replica copy from the second computer to the first computer; and

a conflict state derived from a comparison of the effective operation with the deduced modification operation.

38. The system of claim 37 wherein the conflict resolver forms the propagation operation by selecting a solution to the conflict based on the conflict state.