deep-roots learning program · module 11

Module 11 — Database storage engines

Every chapter: first principles, What insiders know, a See it yourself lab, connections, and a quiz with worked answers.

01

The disk contract

Sectors, pages, fsync, torn writes — the physics of durable memory.

→
02

B-trees

Fanout derived, node anatomy, splits, clustered vs secondary — the read-optimal tree.

→
03

LSM trees

Memtables, levels, compaction, blooms — the write-optimal tree, aka "GC for disk".

→
04

WAL & crash recovery

Log-as-truth, LSNs, group commit, the redo/undo walk — fsync as write barrier.

→
05

MVCC

Snapshots, version chains, write skew, purge — COW at row scale.

→
the exam
fin

Module 11 final exam

Every chapter, worked answers behind the fold.

→