[prev] 86 [next]

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)