Method for ensuring referential integrity in multi-threaded replication engines
First Claim
1. A method of replicating transaction data from a source database to a target database, the transaction data being communicated from a change queue associated with the source database to the target database, the method comprising:
- (a) providing one or more multiple paths between the change queue and the target database, the one or more multiple paths causing at least some of the transaction data to become unserialized; and
(b) reserializing at least some of the unserialized data prior to or upon applying the originally unserialized transaction data to the target database.
2 Assignments
0 Petitions
Accused Products
Abstract
During replication of transaction data from a source database to a target database via a change queue associated with the source database, one or more multiple paths are provided between the change queue and the target database. The one or more multiple paths cause at least some of the transaction data to become unserialized. At least some of the unserialized data is reserialized prior to or upon applying the originally unserialized transaction data to the target database. If the current transaction load is close or equal to the maximum transaction load capacity of a path between the change queue and the target database, another path is provided. If the maximum transaction threshold limit of an applier associated with the target database has been reached, open transactions may be prematurely committed.
-
Citations
66 Claims
-
1. A method of replicating transaction data from a source database to a target database, the transaction data being communicated from a change queue associated with the source database to the target database, the method comprising:
-
(a) providing one or more multiple paths between the change queue and the target database, the one or more multiple paths causing at least some of the transaction data to become unserialized; and (b) reserializing at least some of the unserialized data prior to or upon applying the originally unserialized transaction data to the target database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27)
-
-
28. A method of replicating transaction data from a source database to a target database, the transaction data being communicated from a change queue associated with the source database to the target database, wherein the source database spans multiple nodes, the change queue receiving transaction data posted at all of the nodes, the method comprising:
-
(a) providing a source database that spans multiple nodes; (b) providing one or more multiple paths between the change queue and the target database, the aggregate of at least some of the transaction data output from the change queue being unserialized; and (c) reserializing at least some of the unserialized data prior to or upon applying the originally unserialized transaction data to the target database. - View Dependent Claims (29, 30, 31, 32, 33)
-
-
34. An article of manufacture for replicating transaction data from a source database to a target database, the transaction data being communicated from a change queue associated with the source database to the target database, the article of manufacture comprising a computer-readable medium holding computer-executable instructions for performing a method comprising:
-
(a) providing one or more multiple paths between the change queue and the target database, the one or more multiple paths causing at least some of the transaction data to become unserialized; and (b) reserializing at least some of the unserialized data prior to or upon applying the originally unserialized transaction data to the target database. - View Dependent Claims (35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60)
-
-
61. An article of manufacture for replicating transaction data from a source database to a target database, the transaction data being communicated from a change queue associated with the source database to the target database, wherein the source database spans multiple nodes, the change queue receiving transaction data posted at all of the nodes, the article of manufacture comprising a computer-readable medium holding computer-executable instructions for performing a method comprising:
-
(a) providing a source database that spans multiple nodes; (b) providing one or more multiple paths between the change queue and the target database, the aggregate of at least some of the transaction data output from the change queue being unserialized; and (c) reserializing at least some of the unserialized data prior to or upon applying the originally unserialized transaction data to the target database. - View Dependent Claims (62, 63, 64, 65, 66)
-
Specification