March 2003
Intermediate to advanced
912 pages
27h 17m
English
Let us assume in the case of 2PL and TSO that the transaction manager at the coordinating node has received a request to commit a transaction. We have to ensure:
| Atomicity | Either all nodes commit the changes or none do, and any other transaction perceives the changes made at every node or those at none. |
| Isolation | The effects of the transaction are not made visible until all nodes have made an irrevocable decision to commit or abort. |
We have set up the conditions that no scheduler will refuse to commit the transaction on correctness grounds. In 2PL and TSO we have avoided this possibility by only allowing serializable invocations to take place. For these pessimistic methods there are two remaining issues ...
Read now
Unlock full access