Summary: March 23, 2008 Databases: CCR 1
Concurrency Control and
Recovery
March 23, 2008 Databases: CCR 2
Objectives
Introduction to Concurrency Control +
Concurrency Control Techniques +
Introduction to Recovery +
March 23, 2008 Databases: CCR 3
- Introduction to Concurrency Control ...
The objective of a concurrency control is to schedule transactions
in such a way as to avoid any interference.
We could run transactions serially, but this limits degree of
concurrency or parallelism in system.
A schedule is a sequence of reads/writes by set of concurrent
transactions.
A serial schedule is a schedule where operations of each
transaction are executed consecutively without any interleaved
operations from other transactions.
A nonserial schedule where operations from set of concurrent