Transactions and Concurrency Control
date
Jun 20, 2021
slug
comp90020-tncc
status
Published
tags
Programming
COMP90020
summary
type
Page
Year
2021
- What is Transaction
- ACID property
- Consistency model
- Consistency phenomena
- Methods for Concurrency Control
- Serial equivalence
- Pessimistic (Two-phase locking & Read-Write lock)
- Optimistic (Timestamp ordering)
- Kung-Robinson method
- Nested Transactions
- Strict executions of transactions
- Fundamentals
- Coordination in distributed transaction
- Two-Phase Commit (2PC)
- Three-Phase commit (3PC)
- Concurrency control in distributed transactions
- Locking
- Timestamp ordering
- Transaction Recovery