US5737601A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for peer-to-peer data replication including handling exceptional occurrences
Assignee: Oracle International Corp
•
Filing: 1997-01-16
•
Granted: 1998-04-07
•
Expires: 2017-01-16
Abstract
Abstract The present invention provides the ability to replicate modifications made at a local site to multiple remote sites in a peer-to-peer environment. Information regarding these replicated modifications (e.g., insert, delete, or update) are contained in a set of replication tables. Thus, modifications can be duplicated at other sites immediately after the original modification, or deferred until the remote site is available. The replication tables of the present invention include a transactions table, transaction nodes table, calls table, call nodes table, and an exceptions table. The present invention further provides a logic-oriented procedure-level replication. Procedure-level replication modifies a remote site based on the logical operations used to modify the data at the originating site. Procedure-level replication provides the ability to identify conflicting updates as well. Information concerning conflicts identified by the present invention can be retained in the replication tables. The information contained in the replication tables can be used immediately, or subsequently, to address any conflicts detected by the present invention. The present invention provides the ability to rollback any modifications made once a conflict is identified. Further, the present invention provides the ability to address these conflicts within an application program. The present invention provides a row-oriented replication. A trigger associated with a table queues deferred remote procedures. The remote procedures use the old and new values from the original modification to replicate the modification at remote sites and detect conflicting updates.
Inventors
- 👤 Sandeep Jain
- 👤 Dean Daniels
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-27 14:43
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F11/00; G06F11/07; G06F11/14; G06F11/1471; G06F11/16; G06F11/20; G06F11/2097; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99938; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 13
Claim 1
Independent Claim
180 words
A computer-implemented method of peer-to-peer data replication comprising the steps of: performing data modifications to a first computer system and a second computer system: generating propagation information associated with said data modifications on said first and said second computer systems, said propagation information being retrievable and modifiable, said propagation information including information indicative of an operation to be performed on another computer system; performing a bi-directional replication of said data modifications using said propagation information said bi-directional replication occurring between said first computer system and said second computer system, said replication initiated by either said first or said second computer system, said bi-directional replication resulting in consistent data between said first and said second computer system; identifying exceptional occurrences while performing said data modifications; and wherein said step of performing data modifications is performed by a procedure; said step of identifying said exceptional occurrences is incorporated into said procedure; and said procedure handles said exceptional occurrences by specifying multiple conflict resolution routines that can be called in order until one of said multiple conflict resolution routines returns a successful value.
Claim 2
Dependent Claim
180 words
A computer-implemented method of peer-to-peer data replication comprising the steps of: performing data modifications to a first computer system and a second computer system: generating propagation information associated with said data modifications on said first and said second computer systems, said propagation information being retrievable and modifiable, said propagation information including information indicative of an operation to be performed on another computer system; performing a bi-directional replication of said data modifications using said propagation information said bi-directional replication occurring between said first computer system and said second computer system, said replication initiated by either said first or said second computer system, said bi-directional replication resulting in consistent data between said first and said second computer system; identifying exceptional occurrences while performing said data modifications; and wherein said step of performing data modifications is performed by a procedure; said step of identifying said exceptional occurrences is incorporated into said procedure; and said procedure handles said exceptional occurrences by specifying multiple conflict resolution routines that can be called in order until one of said multiple conflict resolution routines returns a successful value.
Claim 3
Dependent Claim
52 words
The method of claim 1 wherein said step of generating said propagation information further includes the steps of: obtaining information regarding a logical unit of work; obtaining information regarding a procedure for replicating said logical unit of work; and obtaining information regarding a destination at which said procedure is to be performed.
Claim 4
Dependent Claim
20 words
The method of claim 2 further comprising the step of obtaining information regarding exceptional conditions raised during said data modifications.
Claim 5
Dependent Claim
44 words
The method of claim 2 wherein said step of obtaining information regarding a destination at which said procedure is to be performed comprises the step of obtaining information identifying one of a plurality of networked computers at which said procedure is to be performed.
Claim 6
Dependent Claim
29 words
The method of claim 2 wherein said step of identifying exceptional circumstances comprises the step of determining whether said data modifications to said first and second computer systems conflict.
Claim 7
Dependent Claim
23 words
The method of claim 1 further comprising the step of storing said propagation information and said exceptional occurrences in one or more tables.
Claim 8
Dependent Claim
29 words
The method of claim 2 wherein said step of obtaining information regarding a logical unit of work comprises the step of obtaining information regarding modification of a data value.
Claim 9
Dependent Claim
32 words
The method of claim 7 wherein said step of obtaining information regarding modification of a data value comprises the step of obtaining information regarding modification of a data value in a database.
Claim 10
Dependent Claim
42 words
The method of claim 1 wherein said computer readable program code for causing said processing means to identify exceptional circumstances includes program code for causing said processing means to determine whether said data modifications to said first and second computer systems conflict.
Claim 11
Dependent Claim
263 words
An article of manufacture comprising a computer usable mass storage medium having computer readable program code embodied therein for causing a processing means to perform computer-implemented peer-to-peer data replication, said computer readable program code in said article of manufacture comprising: computer readable program code for causing said processing means to perform data modifications to a first computer system and a second computer system; computer readable program code for causing said processing means to generate propagation information associated with said data modifications on said first and said second computer systems, said propagation information being retrievable and modifiable, said propagation information including information indicative of an operation to be performed on another computer system; computer readable program code for causing said processing means to perform a hi-directional replication of said data modifications using said propagation information, said bi-directional replication occurring between said first computer system and said second computer system, said replication initiated by either said first or said second computer system, said bi-directional replication resulting in consistent data between said first and said second computer system; computer readable program code for causing said processing means to identify exceptional occurrences while performing said data modifications; and wherein said computer readable program code for causing said processing means to perform data modifications is a procedure; said computer readable program code for causing said processing means to identify said exceptional occurrences is incorporated into said procedure; and said procedure handles said exceptional occurrences by specifying multiple conflict resolution routines that can be called in order until one of said multiple conflict resolution routines returns a successful value.
Claim 12
Dependent Claim
263 words
An article of manufacture comprising a computer usable mass storage medium having computer readable program code embodied therein for causing a processing means to perform computer-implemented peer-to-peer data replication, said computer readable program code in said article of manufacture comprising: computer readable program code for causing said processing means to perform data modifications to a first computer system and a second computer system; computer readable program code for causing said processing means to generate propagation information associated with said data modifications on said first and said second computer systems, said propagation information being retrievable and modifiable, said propagation information including information indicative of an operation to be performed on another computer system; computer readable program code for causing said processing means to perform a hi-directional replication of said data modifications using said propagation information, said bi-directional replication occurring between said first computer system and said second computer system, said replication initiated by either said first or said second computer system, said bi-directional replication resulting in consistent data between said first and said second computer system; computer readable program code for causing said processing means to identify exceptional occurrences while performing said data modifications; and wherein said computer readable program code for causing said processing means to perform data modifications is a procedure; said computer readable program code for causing said processing means to identify said exceptional occurrences is incorporated into said procedure; and said procedure handles said exceptional occurrences by specifying multiple conflict resolution routines that can be called in order until one of said multiple conflict resolution routines returns a successful value.
Claim 13
Dependent Claim
45 words
The article of manufacture claimed in claim 10 wherein said computer readable program code for causing said processing means to generate propagation information includes program code for causing said processing means to store said propagation information and said exceptional occurrences in one or more tables.
References Cited (Backward Citations)
US4077059A
Cited
US4646229A
Cited
US4558413A
Cited
US4635189A
Cited
US4631673A
Cited
US4648036A
Cited
US4714992A
Cited
US5043871A
Cited
US5155848A
Cited
US4853843A
Cited
US4875159A
Cited
US5321832A
Cited
US5170480A
Cited
EP0428264A2
Cited
US5333265A
Cited
US5276871A
Cited
US5261094A
Cited
US5280612A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-04-06 | 2001-10-06 | 2002-04-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-04-06 | 2005-10-06 | 2006-04-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-04-06 | 2009-10-06 | 2010-04-07 | $7700.00 | Window Closed / Lapsed |