#16332
Mentioned in 3 episodes

Database Internals

A Deep Dive into How Distributed Data Systems Work
Book • 2019
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.

Mentioned by

Mentioned in 3 episodes

Mentioned by Scott Tolinski as an app for managing and starting databases without relying on homebrew.
26 snips
826: You Need These 30 Apps - PART 2
Recommended by Joe Reis as a great book for understanding database systems at a fundamental level.
13 snips
Freestyle Fridays - The Skills Gap in Data
Recommended by Joe Reis as a terrific book, although dense, that everyone should read.
12 snips
The Real Work of Data Engineering with Joe Reis

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app