Transactions
Transactions and transaction strategies play a central role in every architecture. A knowledge of the options available and the differences between them is essential when choosing suitable data access strategies. This section covers the aspects relating to integration. These include transactional systems, isolation levels, two-phase commit, and XA transactions.
Transactional systems: These allow for controlled "all-or-nothing" data manipulation.
Isolation levels: These levels coordinate data access by parallel transactions and, depending on the level, determine the visibility of the manipulated data. There are four different isolation levels:
serializable
repeatable read
read committed
read uncommitted
Two-phase commit: The two-phase commit is the algorithm on which transactions are based. It requires all the systems participating in a transaction to commit to the successful completion of the transaction.
XA transactions: An XA transaction is a standardized, global transaction...