Database Internals

This book guides developers through the essential concepts of modern database and storage engine internals.

It explores storage classification and taxonomy, including B-Tree-based and immutable Log Structured storage engines.

The book also delves into how database files are organized, using auxiliary data structures such as Page Cache, Buffer Pool, and Write-Ahead Log. Additionally, it covers distributed systems, explaining how nodes and processes connect and build complex communication patterns, and discusses consistency models and how distributed storage systems achieve consistency.

The book draws from numerous books, papers, blog posts, and the source code of several open source databases to provide a comprehensive understanding of database internals.