25 ms·

Great article. The book Database Internals looks amazing. Are there any other such books that deep dive into internals?

cmrdporcupine 3y ago
Not a book, but I recommend the database class lectures from @apavlo's group at CMU. https://www.youtube.com/c/cmudatabasegroup 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/ http://webdam.inria.fr/Alice/
- senderista 3y ago
  Another excellent DB textbook covering both theory and implementation is Weikum & Vossen: https://www.google.com/books/edition/_/wV5Ran71zNoC?hl=en&gbpv=1&pg=PP1&dq=Weikum+%26+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/Transactional-Information-Systems-Theory-Algorithms-and-the-Practice-of-Concurrency-Control.pdf?rlkey=f28gwoeh1kc1w41fk59xc6swu&dl=0 https://www.dropbox.com/scl/fi/r0fros5y2kzeqv57v7myz/Transac...
flashgordon 3y ago
Another book I found very useful (though this DI book is more modern) is Raghu Ramakrishnan Database Management Systems book.
why-el 3y ago
There is a another famous one, focusing on Postgres: https://www.interdb.jp/pg/ https://www.interdb.jp/pg/.
- dgellow 3y ago
  Is it available as a print or ebook?
  - why-el 3y ago
    addressed in the FAQ: https://www.interdb.jp/pg/faq.html https://www.interdb.jp/pg/faq.html. Short answer is no.
big_whack 3y ago
This is a good paper for a similar kind of overview: https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf

Not a book, but I recommend the database class lectures from @apavlo's group at CMU. https://www.youtube.com/c/cmudatabasegroup 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/ http://webdam.inria.fr/Alice/

senderista 3y ago
Another excellent DB textbook covering both theory and implementation is Weikum & Vossen: https://www.google.com/books/edition/_/wV5Ran71zNoC?hl=en&gbpv=1&pg=PP1&dq=Weikum+%26+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/Transactional-Information-Systems-Theory-Algorithms-and-the-Practice-of-Concurrency-Control.pdf?rlkey=f28gwoeh1kc1w41fk59xc6swu&dl=0 https://www.dropbox.com/scl/fi/r0fros5y2kzeqv57v7myz/Transac...

flashgordon 3y ago

Another book I found very useful (though this DI book is more modern) is Raghu Ramakrishnan Database Management Systems book.

why-el 3y ago

There is a another famous one, focusing on Postgres: https://www.interdb.jp/pg/ https://www.interdb.jp/pg/.

dgellow 3y ago
Is it available as a print or ebook?
- why-el 3y ago
  addressed in the FAQ: https://www.interdb.jp/pg/faq.html https://www.interdb.jp/pg/faq.html. Short answer is no.

big_whack 3y ago

This is a good paper for a similar kind of overview: https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf