Bidirectional database replication scheme for controlling ping-ponging
First Claim
1. A method of selectively preventing transaction ping-pong in a bidirectional database replication system including (i) a first database and (ii) a second database, the system further including (iii) a first transaction transmitter which sends transactions posted to the first database to the second database for replication in the second database, and (iv) a second transaction transmitter which sends transactions posted to the second database to the first database for replication in the first database only after the transactions are actually posted to the second database, each transaction being one or more transaction steps or transaction operations, the method comprising:
- (a) detecting all transactions to be posted to the second database that were sent by the first transaction transmitter; and
(b) inhibiting the first database from posting selective transactions which were detected as being originally sent by the first transaction transmitter, wherein any transaction sent by the second transaction transmitter is replicated in the first database only after the transaction is actually posted to the second database.
5 Assignments
0 Petitions
Accused Products
Abstract
Transaction ping-pong is selectively prevented in a bidirectional database replication system. The system has a plurality of nodes connected via communication media in a topology. Each node includes a database and a transaction transmitter or collector which sends transactions posted to the database to a database at one or more other nodes for replication in the databases of the one or more other nodes. All transactions to be posted to databases in remote nodes that were sent by a local node are detected, and the database at the local node is inhibited from posting selective transactions which were detected as being originally sent by the local node.
-
Citations
99 Claims
-
1. A method of selectively preventing transaction ping-pong in a bidirectional database replication system including (i) a first database and (ii) a second database, the system further including (iii) a first transaction transmitter which sends transactions posted to the first database to the second database for replication in the second database, and (iv) a second transaction transmitter which sends transactions posted to the second database to the first database for replication in the first database only after the transactions are actually posted to the second database, each transaction being one or more transaction steps or transaction operations, the method comprising:
-
(a) detecting all transactions to be posted to the second database that were sent by the first transaction transmitter; and (b) inhibiting the first database from posting selective transactions which were detected as being originally sent by the first transaction transmitter, wherein any transaction sent by the second transaction transmitter is replicated in the first database only after the transaction is actually posted to the second 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, 29)
-
-
30. A method of selectively preventing transaction ping-pong in a bidirectional database replication system including a plurality of nodes connected via communication media in a topology, each node including a database and a transaction transmitter which sends transactions posted to the database to a database at one or more other nodes for replication in the databases of the one or more other nodes only after the transactions are actually posted to the database of the sending node, each transaction being one or more transaction steps or transaction operations, the method comprising:
-
(a) detecting all transactions to be posted to databases in remote nodes that were sent by a local node; and (b) inhibiting the database at the local node from posting selective transactions which were detected as being originally sent by the local node, wherein any transaction sent by a transaction transmitter of a node is replicated in the databases of the one or more other nodes only after the transaction is actually posted to the database of the sending node. - View Dependent Claims (31, 32, 33)
-
-
34. A system for selectively preventing transaction ping-pong in a bidirectional database replication system which includes a plurality of nodes connected via communication media in a topology, each node including a database and a transaction transmitter which sends transactions posted to the database to a database at one or more other nodes for replication in the databases of the one or more other nodes only after the transactions are actually posted to the database of the sending node, each transaction being one or more transaction steps or transaction operations, the system comprising:
-
(a) means for detecting all transactions to be posted to databases in remote nodes that were sent by a local node; and (b) means for inhibiting the database at the local node from posting selective transactions which were detected as being originally sent by the local node, wherein any transaction sent by a transaction transmitter of a node is replicated in the databases of the one or more other nodes only after the transaction is actually posted to the database of the sending node. - View Dependent Claims (35, 65, 66)
-
-
36. A system for selectively preventing transaction ping-pong in a bidirectional database replication system which includes (i) a first database and (ii) a second database, the system further including (iii) a first transaction transmitter which sends transactions posted to the first database to the second database for replication in the second database, and (iv) a second transaction transmitter which sends transactions posted to the second database to the first database for replication in the first database only after the transactions are actually posted to the second database, each transaction being one or more transaction steps or transaction operations, the system for selectively preventing transaction ping-pong comprising:
-
(a) means for detecting all transactions to be posted to the second database that were sent by the first transaction transmitter; and (b) means for inhibiting the first database from posting selective transactions which were detected as being originally sent by the first transaction transmitter, wherein any transaction sent by the second transaction transmitter is replicated in the first database only after the transaction is actually posted to the second database. - View Dependent Claims (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, 62, 63, 64)
-
-
67. An article of manufacture comprising a computer usable medium having computer readable code means therein for selectively preventing transaction ping-pong in a bidirectional database replication system which includes a plurality of nodes connected via communication media in a topology, each node including a database and a transaction transmitter which sends transactions posted to the database to a database at one or more other nodes for replication in the databases of the one or more other nodes only after the transactions are actually posted to the database of the sending node, each transaction being one or more transaction steps or transaction operations, the computer readable program code means in the article of manufacture comprising:
-
(a) computer readable program code means for detecting all transactions to be posted to databases in remote nodes that were sent by a local node; and (b) computer readable program code means for inhibiting the database at the local node from posting selective transactions which were detected as being originally sent by the local node, wherein any transaction sent by a transaction transmitter of a node is replicated in the databases of the one or more other nodes only after the transaction is actually posted to the database of the sending node. - View Dependent Claims (68, 69, 70)
-
-
71. An article of manufacture comprising a computer usable medium having computer readable code means therein for selectively preventing transaction ping-pong in a bidirectional database replication system, the system including (i) a first database and (ii) a second database, the system further including (iii) a first transaction transmitter which sends transactions posted to the first database to the second database for replication in the second database, and (iv) a second transaction transmitter which sends transactions posted to the second database to the first database for replication in the first database only after the transactions are actually posted to the second database, each transaction being one or more transaction steps or transaction operations, the computer readable program code means in the article of manufacture comprising:
-
(a) computer readable program code means for detecting all transactions to be posted to the second database that were sent by the first transaction transmitter; and (b) computer readable program code means for inhibiting the first database from posting selective transactions which were detected as being originally sent by the first transaction transmitter, wherein any transaction sent by the second transaction transmitter is replicated in the first database only after the transaction is actually posted to the second database. - View Dependent Claims (72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99)
-
Specification