[prev] 1 [next]

Transaction Processing

Transaction (tx) = application-level atomic op, multiple DB ops

Concurrent transactions are

  • desirable, for improved performance
  • problematic, because of potential unwanted interactions
To ensure problem-free concurrent transactions:
  • Atomic ... whole effect of tx, or nothing
  • Consistent ... individual tx's are "correct" (wrt application)
  • Isolated ... each tx behaves as if no concurrency
  • Durable ... effects of committed tx's persist