US6012059A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for replicated transaction consistency
Assignee: Oracle International Corp
•
Filing: 1997-08-21
•
Granted: 2000-01-04
•
Expires: 2017-08-21
Abstract
Abstract Local transactions are run at replication sites while receiving and tracking replication packages from primary sites. If a package coming in from a primary site updates data that a local transaction used, the data is considered stale and the local transaction is restarted. When the replication site wishes to commit (e.g., update data at the primary sites), a special dummy marker is submitted and committed. The marker comprises a dummy transaction that updates a piece of data at the primary site private to the replication site. The local site waits for the dummy transaction in the stream of replication packages sent from the primary site. Once the dummy transaction is received, the replication site is assured that any subsequent replication packages from the primary site will not affect the local transaction. If the replication packages received before the marker do not affect data items referenced during the local transaction, the local transaction commits.
Inventors
- 👤 Marie-Anne Neimat
- 👤 Kurt Shoens
- 👤 Oded Shmueli
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-03 19:12
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 26
Claim 1
Independent Claim
182 words
A method for conducting transactions on replica data items replicated from a primary site, comprising: initiating a local transaction on the replica data items; referencing the replica data items with the local transaction; generating updates to the replica data items from the primary site, the updates occurring independently of the local transaction; identifying which replica data items were updated at the primary site during the local transaction; committing the local transaction to the primary site when the local transaction references to the replica data items occur independently of identified replica data items updated from the primary site; establishing a reference point in time when data items are updated at the primary site by; committing a dummy transaction to the primary site; identifying one of the updates from the primary site returning the dummy transaction; and identifying a set of primary site updates occurring from the initiation of the local transaction to reception of the dummy transaction; and committing the local transaction only when replica data items referenced by the local transaction are not updated from the primary site before the reference point.
Claim 2
Independent Claim
182 words
A method for conducting transactions on replica data items replicated from a primary site, comprising: initiating a local transaction on the replica data items; referencing the replica data items with the local transaction; generating updates to the replica data items from the primary site, the updates occurring independently of the local transaction; identifying which replica data items were updated at the primary site during the local transaction; committing the local transaction to the primary site when the local transaction references to the replica data items occur independently of identified replica data items updated from the primary site; establishing a reference point in time when data items are updated at the primary site by; committing a dummy transaction to the primary site; identifying one of the updates from the primary site returning the dummy transaction; and identifying a set of primary site updates occurring from the initiation of the local transaction to reception of the dummy transaction; and committing the local transaction only when replica data items referenced by the local transaction are not updated from the primary site before the reference point.
Claim 3
Dependent Claim
30 words
A method according to claim 1 wherein the step of committing the dummy transaction comprises modifying one of the replica data items with a unique identifier for the local transaction.
Claim 4
Independent Claim
169 words
A method for conducting transactions on replica data items replicated from multiple primary sites, comprising: initiating a local transaction on the replica data items; referencing the replica data items with the local transaction; generating updates to the replica data items from the multiple primary sites, the updates occurring independently of the local transaction; tracking local transaction updates according to which one of the primary sites generated the replica data items; identifying which replica data items were updated by each one of the tracked primary sites during the local transaction by; committing a dummy transaction to each one of the primary sites; waiting for the dummy transaction updates from each one of the primary sites; and identifying all updates from the primary sites that occur from initiation of the local transaction to reception of all dummy transactions; and committing the local transaction to the tracked primary sites when the local transaction references to the replica data items occur independently of identified replica data items updated from the multiple primary sites.
Claim 5
Independent Claim
169 words
A method for conducting transactions on replica data items replicated from multiple primary sites, comprising: initiating a local transaction on the replica data items; referencing the replica data items with the local transaction; generating updates to the replica data items from the multiple primary sites, the updates occurring independently of the local transaction; tracking local transaction updates according to which one of the primary sites generated the replica data items; identifying which replica data items were updated by each one of the tracked primary sites during the local transaction by; committing a dummy transaction to each one of the primary sites; waiting for the dummy transaction updates from each one of the primary sites; and identifying all updates from the primary sites that occur from initiation of the local transaction to reception of all dummy transactions; and committing the local transaction to the tracked primary sites when the local transaction references to the replica data items occur independently of identified replica data items updated from the multiple primary sites.
Claim 6
Independent Claim
107 words
A method for conducting transactions on replica data items replicated from a primary site, comprising: initiating a local transaction on the replica data items; referencing the replica data items with the local transaction; generating updates to the replica data items from the primary site, the updates occurring independently of the local transaction; identifying during the local transaction which replica data items were updated at the primary site; establishing a reference point in time when data items are updated at the primary site; and committing the local transaction only when replica data items referenced by the local transaction are updated from the primary site after the reference point.
Claim 7
Independent Claim
107 words
A method for conducting transactions on replica data items replicated from a primary site, comprising: initiating a local transaction on the replica data items; referencing the replica data items with the local transaction; generating updates to the replica data items from the primary site, the updates occurring independently of the local transaction; identifying during the local transaction which replica data items were updated at the primary site; establishing a reference point in time when data items are updated at the primary site; and committing the local transaction only when replica data items referenced by the local transaction are updated from the primary site after the reference point.
Claim 8
Dependent Claim
55 words
A method according to claim 1 wherein establishing the reference point comprises the following steps: assigning numbers in sequence for each update to the replica data items made at the primary site; requesting the numbers from the primary site; and committing the local transaction when the requested numbers have previously received by the local transaction.
Claim 9
Dependent Claim
57 words
A method according to claim 1 wherein establishing a reference point comprises the following steps: requesting a marker with the local transaction; placing the marker in updates to the replica data items from the primary site; and identifying a set of primary site updates occurring from the initiation of the local transaction to reception of the marker.
Claim 10
Dependent Claim
56 words
A method according to claim 1 including the following steps: storing a set of temporary replica data items updated by the local transaction; committing the set of temporary updates to the primary site when the local transaction commits; and aborting the set of temporary updates when the local transaction references coincide with the primary site updates.
Claim 11
Dependent Claim
56 words
A methods according to claim 1 including the following steps: generating the replica data items from multiple primary sites; tracking local transaction updates according to which one of the primary sites generated the replica data items; and identifying which replica data items were updated by each one of the tracked primary sites during the local transaction.
Claim 12
Dependent Claim
25 words
A method according to claim 1 wherein updated replica data items are identified using triggers for each replica data item updated by the local transaction.
Claim 13
Dependent Claim
34 words
A method according to claim 1 including the following steps: providing a record at the primary site; and modifying the record before committing the local transaction for serializing transaction validation among the replica sites.
Claim 14
Dependent Claim
73 words
A method according to claim 1 including the following steps: temporarily storing local transaction updates to the replica data items in a transaction scope; tracking each local transaction reference to the replica data items in a first list; tracking each primary site update to the replica data items in a second list; and committing the first transaction scope to the primary site when the first and second lists comprise independent replica data items.
Claim 15
Dependent Claim
23 words
A method according to claim 11 including aborting the first transaction scope when the first and second lists include common replica data items.
Claim 16
Dependent Claim
102 words
A replicated data system, comprising: at least one primary site for storing a database, the primary site generating replication packages reflecting updates to portions of the database; at least one local site connected to the primary site, the local site storing a local replica of at least a portion of the database and conducting local transactions with the local replica; and the local site generating a marker after each local transaction and waiting for receipt of the marker from the primary site before committing each local transaction thereby identifying which of the replication packages affected the local replica during the local transaction.
Claim 17
Dependent Claim
102 words
A replicated data system, comprising: at least one primary site for storing a database, the primary site generating replication packages reflecting updates to portions of the database; at least one local site connected to the primary site, the local site storing a local replica of at least a portion of the database and conducting local transactions with the local replica; and the local site generating a marker after each local transaction and waiting for receipt of the marker from the primary site before committing each local transaction thereby identifying which of the replication packages affected the local replica during the local transaction.
Claim 18
Dependent Claim
26 words
A system according to claim 13 wherein the local site includes a local update transaction scope for temporarily storing local transaction updates to the replica data.
Claim 19
Dependent Claim
34 words
A system according to claim 13 wherein the primary site comprises a database file server and the local site comprises an application server coupled to the database file server with a local area network.
Claim 20
Dependent Claim
25 words
A system according to claim 13 wherein the local site includes a reference transaction scope for tracking each local transaction reference to the replica data.
Claim 21
Dependent Claim
26 words
A system according to claim 13 wherein the local site includes a primary update transaction scope for tracking each primary site update to the replica data.
Claim 22
Independent Claim
76 words
A method for conducting local transactions on replica data copied from a primary database, comprising: generating replication packages for updating data items in the replica data; conducting a transaction that references the replica data; establishing a reference point when data items are updated at the primary database; and committing the local transaction to the primary database when the replication packages generated prior to the reference point do not update the data items referenced during the transaction.
Claim 23
Independent Claim
76 words
A method for conducting local transactions on replica data copied from a primary database, comprising: generating replication packages for updating data items in the replica data; conducting a transaction that references the replica data; establishing a reference point when data items are updated at the primary database; and committing the local transaction to the primary database when the replication packages generated prior to the reference point do not update the data items referenced during the transaction.
Claim 24
Dependent Claim
89 words
A method according to claim 18 including the following steps: temporarily storing local transaction updates to the replica data items in a transaction scope; tracking each local transaction reference to the replica data items in a first list; tracking each primary site update to the replica data items in a second list; committing the transaction scope to the primary site when the first and second lists comprise independent replica data items; and aborting the transaction scope when the first and second lists track common portions of the replica data.
Claim 25
Dependent Claim
64 words
The method according to claim 18 wherein establishing a reference point includes the following steps: committing a marker to the primary database at the end of the transaction; identifying one of the replication packages containing the marker; and committing the transaction to the primary database when the replication packages generated prior to the marker do not update the data items referenced during the transaction.
Claim 26
Dependent Claim
21 words
A method according to claim 18 wherein the step of committing a marker comprises generating a trigger to the primary database.
References Cited (Backward Citations)
US5170480A
Cited
US5313629A
Cited
US5390316A
Cited
US5287496A
Cited
US5701480A
Cited
US5440727A
Cited
US5423037A
Cited
US5555404A
Cited
US5586310A
Cited
US5809503A
Cited
US5737601A
Cited
US5806075A
Cited
US5796999A
Cited
US5577240A
Cited
US5621795A
Cited
US5708812A
Cited
US5758337A
Cited
US5781910A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-01-03 | 2003-07-05 | 2004-01-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-01-03 | 2007-07-05 | 2008-01-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-01-03 | 2011-07-05 | 2012-01-04 | $7700.00 | Window Closed / Lapsed |