Computer Science › Section J · Database systems › Topic J.5
Maintaining database integrity: transactions
A bank's database serves thousands of users at once and must survive power cuts mid-operation. Transactions, logs and locks are how a DBMS keeps its data correct regardless.
In this topic
- Why integrity is hard
- Transactions and ACID
- The log and the commit point
- Rolling back
- Worked example: a transaction in SQLite
- Interleaving transactions
- Worked example: a lost update and a wrong total
- Shared and exclusive locks
- Deadlock and the wound-wait protocol
- Common mistakes to avoid
- Key takeaways
This topic is part of Wuanberri Pro. Checking your access…