Function and importance of transactions.
others
Description
Lecture Objectives
Function and importance of transactions.
Properties of transactions.
Concurrency Control
Meaning of serializability.
How locking can ensure serializability.
Deadlock and how it can be resolved.
How timestamping can ensure serializability.
Optimistic concurrency control.
Granularity of locking.
Lecture Objectives
Recovery Control
Some causes of database failure.
Purpose of transaction log file.
Purpose of checkpointing.
How to recover following database failure.
Alternative models for long duration transactions.
