I'll start with the simplest transaction variety, the tightly coupled single-resource transaction. Because all single-resource transactions are tightly coupled, I'll simplify the terminology by calling them single-resource transactions. Let me take you through a typical single-resource transaction involving a database.
Consider writing an application to withdraw money from a checking account. Let's say that “withdrawing money from a checking account” means the following:
Finding the specific account record in the CheckingAccount table.
Reading the CurrentBalance field.
Deducting the amount from the current balance.
Logging the withdrawal in a Logging table.
Imagine the problems that ...