Transactions: the story so far
Transactions should obey ACID properties
Isolation can be compromised by uncontrolled concurrency
Serializable schedules avoid potential update anomalies
- less safe (more concurrent) isolation levels exist
- read uncommitted, read committed, repeatable read
Styles of concurrency control
- locking (two-phase, deadlock)
- optimistic concurrency control (try, then fix problems)
- multi-version concurrency control (less locking needed)
|