Patent US5261094A successfully refreshed from Google Patents.
US5261094A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Asynchronous replication of data changes by distributed update requests
Assignee: International Business Machines Corp
•
Filing: 1991-04-08
•
Granted: 1993-11-09
•
Expires: 2011-04-08
Abstract
Abstract A method of replicating changes made to databases distributed throughout a computer network is described. A first program (TP1) in the Collector node instructs a second program (TP2) in the Collectee node to send all updates to a database since the last conversation. TP2 processes queries to retrieve any changes made since the last conversation between the Collector and Collectee nodes and send the data to TP1, which updates the copy of the database on its own system.
Inventors
- 👤 Rhonda S. Everson
- 👤 Michael R. Felix
- 👤 Boyd D. Robertson
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-03 12:01
CPC Classifications
G; G06; G06F; G06F15/00; G06F15/16; G06F15/161; G06F16/00; G06F16/20; G06F16/27; G06F16/273; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
154 words
In a distributed computing environment, which includes a plurality of computers, each of which include at least one relational database and a control table, a method for replicating changes to one of the databases comprising the steps of: (a) periodically initiating an update conversation between a first computer and a second computer; (b) said first computer instructing said second computer to send to the first computer only all changes to its database since the last update conversation; (c) said second computer processing said instruction, preparing an update, and transmitting the update along with a time of transmission to the first computer, and updating the control table of said second computer with said transmission time; (d) said first computer receiving the said update and the said time of transmission and replicating all said changes in its database; and (e) said first computer updating its control table with said time of transmission of the said update.
Claim 2
Dependent Claim
154 words
In a distributed computing environment, which includes a plurality of computers, each of which include at least one relational database and a control table, a method for replicating changes to one of the databases comprising the steps of: (a) periodically initiating an update conversation between a first computer and a second computer; (b) said first computer instructing said second computer to send to the first computer only all changes to its database since the last update conversation; (c) said second computer processing said instruction, preparing an update, and transmitting the update along with a time of transmission to the first computer, and updating the control table of said second computer with said transmission time; (d) said first computer receiving the said update and the said time of transmission and replicating all said changes in its database; and (e) said first computer updating its control table with said time of transmission of the said update.
Claim 3
Dependent Claim
17 words
The method as claimed in claim 1 wherein the computers communicate in a peer to peer relationship.
Claim 4
Dependent Claim
16 words
The method as claimed in claim 1 wherein the computers are arranged in a hierarchical relationship.
Claim 5
Dependent Claim
17 words
The method as claimed in claim 1 wherein said initiating step is performed at predefined time intervals.
Claim 6
Dependent Claim
26 words
The method as claimed in claim 1 wherein the second computer processing said instruction step includes preparing a data query in a structured query language format.
Claim 7
Dependent Claim
30 words
The method as claimed in claim 1 wherein the control table of each computer includes the time of the last update to the said relational database contained in said computer.
Claim 8
Independent Claim
176 words
A method for maintaining identical information in a plurality of relational databases distributed in a plurality of computer systems comprising the following steps: (a) periodically triggering a first computer process in a first computer system which initiates an update conversation with a second computer process in a second computer system; (b) said first computer process instructing said second computer process to query its database and identify only all changes made to its information since the last update conversation of its information was sent to said first computer process; (c) said second computer process querying its database, preparing the update, transmitting only the updated information along with a time of transmission to said first computer process, and updating the control table of said second computer system with said transmission time; (d) said first computer process receiving the updated information and said time of transmission and applying the said updated information to its database; and (e) said first computer process updating its control table with the said time of the last update transmitted by the second computer process.
Claim 9
Independent Claim
176 words
A method for maintaining identical information in a plurality of relational databases distributed in a plurality of computer systems comprising the following steps: (a) periodically triggering a first computer process in a first computer system which initiates an update conversation with a second computer process in a second computer system; (b) said first computer process instructing said second computer process to query its database and identify only all changes made to its information since the last update conversation of its information was sent to said first computer process; (c) said second computer process querying its database, preparing the update, transmitting only the updated information along with a time of transmission to said first computer process, and updating the control table of said second computer system with said transmission time; (d) said first computer process receiving the updated information and said time of transmission and applying the said updated information to its database; and (e) said first computer process updating its control table with the said time of the last update transmitted by the second computer process.
Claim 10
Dependent Claim
18 words
The method as claimed in claim 7 wherein the computer systems communicate in a peer to peer relationship.
Claim 11
Dependent Claim
17 words
The method as claimed in claim 7 wherein the computer systems are arranged in a hierarchical relationship.
Claim 12
Dependent Claim
31 words
The method as claimed in claim 7 wherein the control tables of each computer system include the times of last update to the relational databases contained in said each computer system.
References Cited (Backward Citations)
US4432057A
Cited
US4627019A
Cited
US4819156A
Cited
US4914570A
Cited
US4887204A
Cited
US5113499A
Cited
US5187787A
Cited
US5187787B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1996-11-08 | 1997-05-10 | 1997-11-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2000-11-08 | 2001-05-10 | 2001-11-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2004-11-08 | 2005-05-10 | 2005-11-09 | $7700.00 | Window Closed / Lapsed |