Summary: March 29, 2008 ICS 541 1
March 29, 2008 ICS 541 2
- Lecture outline
Definition and motivation for transactions
The ACID properties of transactions
Concurrent Executions and Schedules
Testing for Serializability
Transaction Definition in SQL
March 29, 2008 ICS 541 3
The database system must ensure that the data stored in the
database is always consistent.
There are several possible types of failures that may cause the
data to become inconsistent.
A transaction is an atomic program that executes on the