Transactions

Sequence of indivisible DML requests

  • Atomicity
  • Consistency
  • Isolation
  • Durability

Subsystems

DML processing is responsible for ensuring the part of the transaction consistency defined by the integrity constraints

Database is a finite set of independent physical objects xj that are read and written to transactions Ti

  1. ri[xj] - Transaction Ti reads object xj
  2. wi[xj] - Transaction Ti writes object xj
Transactions

Ti is a sequence of read and write operations on a database
Ti=ri[x1],ri[x2],wi[x1],,ri[x4],wi[x2],ci