Summary: March 29, 2008 ICS 541 1
Transaction Management
March 29, 2008 ICS 541 2
- Lecture outline
Overview
Definition and motivation for transactions
The ACID properties of transactions
Transaction states
Concurrent Executions and Schedules
Conflict Serializability
Testing for Serializability
View Serializability
Transaction Definition in SQL
March 29, 2008 ICS 541 3
- Overview
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

Source: Adam, Salah - Department of Information and Computer Science, King Fahd University of Petroleum and Minerals

Collections: Computer Technologies and Information Sciences