Database Systems Design - From Storage Engines to Query Optimization #1008542

Database Systems Design is a comprehensive guide to how modern database systems work, from the physics of storage devices all the way to the query plans that answer your SQL in milliseconds. Beginning with the relational model and relational algebra, it walks through storage engines, B-tree and hash indexing, buffer management, query processing, cost-based optimization, join algorithms, and transaction management with ACID guarantees. Later chapters cover concurrency control, write-ahead logging, snapshot isolation, distributed databases, replication, NoSQL stores, column stores, in-memory engines, NewSQL systems, and query compilation.

Written for engineers who want to understand what happens inside the database — not just how to use one — it treats every design decision as a trade-off between flexibility, performance, isolation, and durability. Each chapter includes worked examples, comparison tables, and references to the systems that shaped the field.