Documentation

Systematic database kernel knowledge, from storage engine to distributed systems

Storage Engine

Storage Engine OverviewUnderstanding the core concepts of database storage engines: page management, file organization, buffer pools, and WAL
Buffer Pool ManagementUnderstanding buffer pool design and implementation: page pinning, replacement algorithms, concurrency control, and prefetching
Page Layout: Slotted PagesUnderstanding Slotted Pages design: variable-length field handling, row offset arrays, and comparisons with alternative page layouts

Indexing

B+Tree Index InternalsDeep dive into B+Tree mechanisms: node structure, insertion/deletion algorithms, splits/merges, concurrency control, and clustered indexes