KickoffSQLSystemsnanoDBTransactionsDistributedData Systems
Transactions

1. Using Transactions

Transaction Motivation ACID Properties
C
4.1: ACID at Stripe
Sample Code: Running Transactions

Concurrency correctness

Naive Concurrency Graph Refresher Correctness

Lock-based concurrency

Locks Stack & the Lock Manager DB Locks Lifecycle Two-Phase Locking Microschedules & Deadlock

Alternate Concurrency Models

MVCC Optimistic Concurrency Control Connecting It All Together

Quizzes

Q
Concurrency Control
Change Tracking The WAL Log Undo for Aborts Post-Crash Recovery

End-to-End TM

Transaction Manager Architecture Three Transactions

Capstone & Beyond

Problem Solving Next 100x

Concurrency Control Quiz

Test your understanding of locking protocols, conflict detection, and transaction scheduling.

Database Reference: Use acid-properties.html and db-locks-2pl.html for theory while answering these questions.

← PreviousConnecting It All TogetherNext →Change Tracking