
Database Internals
Alex Petrov · 2019
Programming and computer science › Databases and distributed data
#905 most recommended
Hacker News
54
mentions by 46 people · top 6% of 15,732 books
Open Library
4.50★★★★★★★★★★
2 ratings · 22 want to read
Wikipedia
—
No article yet
About the book
Database Internals is a 2019 book by Alex Petrov on how database systems are built. It covers two broad areas: storage engines, including B-tree variants, LSM trees, on-disk layout, buffer management, and recovery, and distributed systems, including replication, consensus, partitioning, and transaction coordination across nodes. The book's core position is that a database's observable behavior, such as its read and write performance, space use, and consistency guarantees, follows from the internal structures and algorithms it uses, so understanding those components is necessary for reasoning about trade-offs. It presents storage structures as choices with costs that must be weighed against each other rather than as interchangeable. It then extends the same reasoning to distributed systems, where network failures, coordination, and agreement among nodes add constraints that a single-node design does not face.
Written by Claude from what it knows of this book.
What Hacker News says 67% recommend · 0% critical
In the commenters’ own words
This is a very good list. Adrian's blog is, particularly, a treasure. I wrote this post a while ago, aiming to answer a similar question about finding paper…
I started my career as a Network Technician/Engineer (5 years), then moved to Linux Administration (5 years), then DevOps/SRE (8 years). Note that I never…
What Open Library readers say 4.50 from 2 ratings
- 51
- 41
- 30
- 20
- 10
- 22 want to read
- 2 reading
- 3 have read
Only 2 ratings: treat the average as a hint.
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
The threads it came up in
- Ask HN: Which books do you consider real gems in your field of work/study?
- Ask HN: What are the best tech books you read in 2021?
- Ask HN: Recommended books and papers on distributed systems?
- Ask HN: What are the good books on filesystems or storage?
- Ask HN: Books on designing disk-optimized data structures?
- Ask HN: What are some other books as fundamental as DDIA?
- Distributed Systems Reading List
Details
- First published
- 2019
- ISBN
- 9781492040347
- Editions known
- 2 at Open Library
- Open Library
- OL21360140W
Read next: its neighbours on the mosaic
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · 8 people recommended both
Database System ConceptsKorth · 2005 · recommended by 4 people · named together in 2 comments
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 people · named together in 2 comments
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
Database systemsPeter Rob · 2006 · recommended by 4 people · similar by subject and what people say about it
Database management systemsRaghu Ramakrishnan · 2001 · recommended by 7 people · similar by subject and what people say about it
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · similar by subject and what people say about it
The Datacenter as a ComputerLuiz André Barroso · 1900 · recommended by 9 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Pro SQL Server InternalsDmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
Understanding MySQL internalsAlexander Sasha Pachev · 2006 · recommended by 2 people · similar by subject and what people say about it
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Data and RealityWilliam Kent · 1978 · recommended by 15 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Seven Databases in Seven WeeksEric Redmond · 2012 · recommended by 8 people · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
An introduction to database systemsC. J. Date · 1975 · recommended by 14 people · similar by subject and what people say about it
Performance modeling and design of computer systemsMor Harchol-Balter · 2013 · recommended by 5 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 people · similar by subject and what people say about it
Foundations of databasesSerge Abiteboul · 1994 · recommended by 1 person · similar by subject and what people say about it
A Philosophy of Software DesignJohn K. Ousterhout · 2018 · recommended by 163 people · 3 people recommended both