Module: Transaction processing

Introduction to ACID, concurrency control.

Learning Outcomes

Understand basic transaction processing concepts

You understand transactions and their properties (ACID)
You understand the anomalies that occur without ACID
You understand the locking protocols used to ensure Isolation
You understand the logging techniques used to ensure Atomicity and Durability
You understand Recovery techniques used to recover from crashes

Readings

Chapter 17.1: Transaction processing

Transaction processing

20 pages

Chapter 18 (Sections 1-2): Transaction processing

Transaction processing

20 pages

Transaction processing

Introduction to transaction processing: atomicity, scheduling

Lecture Notes

Transaction processing (Part 2)

Introduction to transaction processing: concurrency control

Lecture Notes

Experiential Learning

Exercise 15

Reasoning with Transactions

Exercise 16

Practice use of locking, logging, and recovery