2PL is Good Stuff
2PL is widely used
- Can be adapted to variety of situations, such as distributed processing
Variations:
- Basic 2PL (as described)
- Conservative 2PL: T locks all items before execution
- Strict 2PL: T doesn't unlock any items until T is finished (i.e., after COMMIT or ABORT).