US5884325A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System for synchronizing shared data between computers
Assignee: Oracle International Corp
•
Filing: 1996-10-09
•
Granted: 1999-03-16
•
Expires: 2016-10-09
Abstract
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.
Inventors
- 👤 Jonathan A. Bauer
- 👤 Andrew Bodge
- 👤 Steven Huberman
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 23:19
CPC Classifications
G; G06; G06Q; G06Q20/00; G06Q20/08; G06Q20/10; G06Q20/102; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/273; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99938; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
85 words
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.
Claim 2
Independent Claim
85 words
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.
Claim 3
Dependent Claim
29 words
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.
Claim 4
Dependent Claim
19 words
The method of claim 2 wherein the step of encoding comprises calculating a bitmapped value representing the respective index.
Claim 5
Dependent Claim
24 words
The method of claim 1 wherein the step of encoding comprises dynamically selecting an encoding technique based on the resulting size of the identifier.
Claim 6
Dependent Claim
28 words
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.
Claim 7
Dependent Claim
48 words
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.
Claim 8
Dependent Claim
25 words
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.
Claim 9
Dependent Claim
16 words
The method of claim 6 wherein at least one of the databases is a tabular database.
Claim 10
Dependent Claim
13 words
The method of claim 8 wherein a tabular database is a relational database.
Claim 11
Independent Claim
90 words
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.
Claim 12
Independent Claim
90 words
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.
Claim 13
Dependent Claim
26 words
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.
Claim 14
Dependent Claim
16 words
The system of claim 11 wherein the identifier is a bitmapped value representing the respective index.
Claim 15
Dependent Claim
24 words
The method of claim 10 wherein the identifier is encoded by a dynamically selected encoding technique based on the resulting size of the identifier.
Claim 16
Dependent Claim
22 words
The method of claim 10 wherein the message includes the identifier and a coded operation to be performed at the second computer.
Claim 17
Dependent Claim
48 words
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.
Claim 18
Dependent Claim
21 words
The method of claim 15 wherein the list includes sequentially ordering attributes shared between the first collection and the second collection.
Claim 19
Dependent Claim
16 words
The method of claim 15 wherein at least one of the databases is a tabular database.
Claim 20
Dependent Claim
13 words
The method of claim 17 wherein a tabular database is a relational database.
Claim 21
Dependent Claim
79 words
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.
Claim 22
Dependent Claim
79 words
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.
Claim 23
Dependent Claim
21 words
The method of claim 19 wherein the catalog is derived from a correspondence of shared columns between a plurality of computers.
Claim 24
Dependent Claim
154 words
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.
Claim 25
Dependent Claim
154 words
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.
Claim 26
Dependent Claim
14 words
The database system of claim 21 wherein the first and second databases are heterogeneous.
Claim 27
Dependent Claim
23 words
The database system of claim 21 wherein the private subset of data is at least one row of data in the second database.
References Cited (Backward Citations)
US5129082A
Cited
US5559991A
Cited
US5392390A
Cited
US5689706A
Cited
US5434994A
Cited
US5640566A
Cited
US5581753A
Cited
US5684990A
Cited
US5706509A
Cited
US5649195A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-03-15 | 2002-09-14 | 2003-03-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-03-15 | 2006-09-14 | 2007-03-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-03-15 | 2010-09-14 | 2011-03-16 | $7700.00 | Window Closed / Lapsed |