Database Internals

How relational databases store, index, and retrieve data — from on-disk structures to query execution.

  1. B+Tree Index Structure
  2. Transactions and ACID
  3. Write-Ahead Log and Durability
  4. Query Execution and the Optimizer