Assumptions
Two-phase locking, holding write locks until after a transaction commits. This implies
- recoverability
- no cascading aborts
- strictness (never overwrite uncommitted data)
Page-level everything (for now)
- page-granularity locks
- database is a set of pages
- a transaction’s read or write operation operates on an entire page
- we’ll look at record granularity later