Hacker News new | ask | show | jobs
by praveer13 923 days ago
Great article. The book Database Internals looks amazing. Are there any other such books that deep dive into internals?
4 comments

Not a book, but I recommend the database class lectures from @apavlo's group at CMU.

https://www.youtube.com/c/cmudatabasegroup

All the classes (intro and advanced) are online, as well as presentations and lectures about industry products.

They are very useful.

Also, from a more high level theoretical CS and less physical-implementation focused POV, the "Alice" book ("Foundations of Databases") is amazing (though very dense and mathematical). Focuses on the relational algebra and Datalog (and the translation of that into the Rel Algebra). Getting print copies is hard now (my used copy arrived with a broken spine and pages falling out), but the entire book is online: http://webdam.inria.fr/Alice/

Another excellent DB textbook covering both theory and implementation is Weikum & Vossen:

https://www.google.com/books/edition/_/wV5Ran71zNoC?hl=en&gb...

In case you can't afford to donate $150 to Elsevier: https://www.dropbox.com/scl/fi/r0fros5y2kzeqv57v7myz/Transac...

There is a another famous one, focusing on Postgres: https://www.interdb.jp/pg/.
Is it available as a print or ebook?
addressed in the FAQ: https://www.interdb.jp/pg/faq.html. Short answer is no.
This is a good paper for a similar kind of overview: https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf
Another book I found very useful (though this DI book is more modern) is Raghu Ramakrishnan Database Management Systems book.