System for synchronizing shared data between computers

• US 5,884,325 A
• Filed: 10/09/1996
• Issued: 03/16/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, Bauer, Jonathan A., Huberman, Steven
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Mizrahi, Diane D.
• Application Number:
  US08/728,497
• Time in Patent Office: 888 Days
• Field of Search: 707/201, 707/10, 707/1, 707/2, 707/202, 705/40, 364/474.05, 364/528.3, 364/528.21, 364/528.28, 395/200.53, 395/701
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• 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 communicating shared data between computers comprising the steps of:

maintaining a list of data items shared between a first computer and a second computer;

storing a copy of the list on the first computer and the second computer;

encoding the identity of a selected data item into an identifier based on the position of the selected data item in the list; and

transmitting a message having the encoded identity of the selected data item from the first computer to the second computer.

2. The method of claim 1 wherein the step of encoding comprises determining a respective index into the list, the index pointing to the identity of the selected data item.

3. The method of claim 2 wherein the step of encoding comprises calculating a bitmapped value representing the respective index.

4. The method of claim 1 wherein the step of encoding comprises dynamically selecting an encoding technique based on the resulting size of the identifier.

5. The method of claim 1 wherein the step of transmitting comprises building the message from the identifier and a coded operation to be performed at the second computer.

6. The method of claim 1 wherein the data is organized in a database, the first computer having a first database which includes data organized into a first collection of data and the second computer having a second database which includes data organized into a second collection of data.

7. The method of claim 6 wherein the step of maintaining a list comprises sequentially ordering attributes shared between the first collection and the second collection.

8. The method of claim 6 wherein at least one of the databases is a tabular database.

9. The method of claim 8 wherein a tabular database is a relational database.

10. A system for communication shared data between computers comprising:

a list of data items shared between a first computer and a second computer, a copy of the list being stored on the first computer and the second computer;

an identifier in which is encoded the identity of a selected data item based on the position of the selected data item in the list;

a message having the encoded identity of the selected data item; and

a transceiver at the first computer and second computer for transmitting and receiving the message.

11. The system of claim 10 wherein the identifier is a respective index into the list, the index pointing to the identity of the selected data item.

12. The system of claim 11 wherein the identifier is a bitmapped value representing the respective index.

13. The method of claim 10 wherein the identifier is encoded by a dynamically selected encoding technique based on the resulting size of the identifier.

14. The method of claim 10 wherein the message includes the identifier and a coded operation to be performed at the second computer.

15. The method of claim 10 wherein the data is organized in a database, the first computer having a first database which includes data organized into a first collection of data and the second computer having a second database which includes data organized into a second collection of data.

16. The method of claim 15 wherein the list includes sequentially ordering attributes shared between the first collection and the second collection.

17. The method of claim 15 wherein at least one of the databases is a tabular database.

18. The method of claim 17 wherein a tabular database is a relational database.

19. In a database synchronizer, a method of filtering data from a tabular database organizing data as rows and columns of data fields, comprising the steps of:

maintaining a catalog of columns in the database that are subject to synchronization, there being at least one column in the database that is not in the catalog;

generating a filter predicate to restrict rows from the database from synchronization; and

constructing a query on the database using the catalog and the predicate.

20. The method of claim 19 wherein the catalog is derived from a correspondence of shared columns between a plurality of computers.

21. A database system comprising:

a first database on a first computer, the first database including a first collection of data representable as rows and columns;

a second database on a second computer, the second database including a second collection of data representable as rows and columns, the second collection including a shared subset of data replicated from the first collection;

a first private subset of data in the first collection which is not shared between the first database and the second database;

a second private subset of data in the second collection which is not shared between the first database and the second database; and

a database synchronizer for synchronizing the shared subset of data between the first database and the second database, the database synchronizer filtering the first private subset of data from the synchronization of the second database and the second private subset of data from the synchronization of the first database.

22. The database system of claim 21 wherein the first and second databases are heterogeneous.

23. The database system of claim 21 wherein the private subset of data is at least one row of data in the second database.