Method of controlling whether an uncompleted transaction applied against a database goes forward using either synchronous or asynchronous replication, or using either encrypted replication or unencrypted replication
Transactions are applied against a database on a transaction processing system. A tracking engine identifies an uncompleted transaction to be joined, joins the uncompleted transaction, and collects one or more non-durable attributes of the joined uncompleted transaction. Collected attributes of the joined uncompleted transaction are compared against rules in a rules engine that are applicable to the transaction to determine whether an applicable rule in the rules engine is met. The joined uncompleted transaction is allowed to go forward and be applied against the database of the transaction processing system using a synchronous replication engine when the applicable rule is met, and an asynchronous replication engine when the applicable rule is not met. Alternatively, the joined uncompleted transaction is allowed to go forward using a replication engine that replicates using encryption when the applicable rule is met, or replicates unencrypted when the applicable rule is not met.
1. A method of applying transactions against a database on a transaction processing system either synchronously or asynchronously, the method comprising:
(a) using a tracking engine to:
(i) identify an uncompleted transaction to be joined, wherein the uncompleted transaction is a transaction that has begun but has been neither committed nor aborted,
(ii) join the uncompleted transaction, and
(iii) collect one or more non-durable attributes of the joined uncompleted transaction, wherein the one or more non-durable attributes are attributes that are not otherwise needed in order to complete a transaction;
(b) comparing the collected one or more non-durable attributes of the joined uncompleted transaction against rules in a rules engine that are applicable to the transaction to determine whether an applicable rule in the rules engine is met; and
(c) allowing the joined uncompleted transaction to go forward and be applied against the database of the transaction processing system using:
(i) a synchronous replication engine when the applicable rule is met, and
(ii) an asynchronous replication engine when the applicable rule is not met.
2. The method of claim 1 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include changes to the database.
3. The method of claim 1 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include a time of day of the transaction.
4. The method of claim 1 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include a user ID that started the transaction.
5. The method of claim 1 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include a program identifier that participated in the transaction.
6. The method of claim 1 wherein the tracking engine joins the uncompleted transaction explicitly.
7. The method of claim 1 wherein the tracking engine joins the uncompleted transaction implicitly.
8. A method of applying transactions against a database on a transaction processing system either using encryption or not using encryption, the method comprising:
(a) using a tracking engine to:
(i) identify an uncompleted transaction to be joined, wherein the uncompleted transaction is a transaction that has begun but has been neither committed nor aborted,
(ii) join the uncompleted transaction, and
(iii) collect one or more non-durable attributes of the joined uncompleted transaction, wherein the one or more non-durable attributes are attributes that are not otherwise needed in order to complete a transaction;
(b) comparing the collected one or more non-durable attributes of the joined uncompleted transaction against rules in a rules engine that are applicable to the transaction to determine whether an applicable rule in the rules engine is met; and
(c) allowing the joined uncompleted transaction to go forward and be applied against the database of the transaction processing system using a replication engine that (i) replicates using encryption when the applicable rule is met, and (ii) replicates unencrypted when the applicable rule is not met.
9. The method of claim 8 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include changes to the database.
10. The method of claim 8 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include a time of day of the transaction.
11. The method of claim 8 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include a user ID that started the transaction.
12. The method of claim 8 wherein the collected one or more non-durable attributes of the joined uncompleted transaction include a program identifier that participated in the transaction.
13. The method of claim 8 wherein the tracking engine joins the uncompleted transaction explicitly.
14. The method of claim 8 wherein the tracking engine joins the uncompleted transaction implicitly.