4 ms·

Ask HN: Book Recommendation on Database Internals

2 points by finlaybw 3y ago

I am looking for books (any other resource will do too) that can help with learning database internals. Specifically the core components that makes up a database and how to implements. The book should probably cover the query engine parts (sql parsing, query plans etc) and the persistence part. Recommendations will be appreciated.

sitkack 3y ago
https://www.youtube.com/@CMUDatabaseGroup https://www.youtube.com/@CMUDatabaseGroup
billconan 3y ago
https://news.ycombinator.com/item?id=35666598 https://news.ycombinator.com/item?id=35666598
- sitkack 3y ago
  In that vein https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=database%20internals&sort=byPopularity&type=story https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...
jpamata 3y ago
"How Query Engines Work" by Andy Grove, you build one in Kotlin: https://leanpub.com/how-query-engines-work https://leanpub.com/how-query-engines-work The author also made it available for free at https://howqueryengineswork.com/00-introduction.html https://howqueryengineswork.com/00-introduction.html On implementation, my favourite is "Database Design and Implementation" by Ed Sciore, you write a relational DB in Java, including the parser.
- finlaybw 3y ago
  > "How Query Engines Work" by Andy Grove, you build one in Kotlin: https://leanpub.com/how-query-engines-work https://leanpub.com/how-query-engines-work I have come across this, but unfortunately it feels like a book written for someone who already knows the topic. For example, the logical plans did not even bother explaining what logical plans are, where it fits into the whole picture etc https://howqueryengineswork.com/05-logical-plan.html https://howqueryengineswork.com/05-logical-plan.html
mejutoco 3y ago
I don‘t know if you: - did not do any research - want someone to link to the book "database internals" But, in the spirit of the most charitable interpretation and, as it is a good book: https://www.goodreads.com/book/show/44647144-database-internals https://www.goodreads.com/book/show/44647144-database-intern...
- finlaybw 3y ago
  Took a look at this, but it looks like it is missing the query engine parts, which is one of the things I am currently interesting in learning more about - perhaps more so than the persistence and distributed parts

2 points by finlaybw 3y ago

sitkack 3y ago

https://www.youtube.com/@CMUDatabaseGroup https://www.youtube.com/@CMUDatabaseGroup

billconan 3y ago

https://news.ycombinator.com/item?id=35666598 https://news.ycombinator.com/item?id=35666598

sitkack 3y ago
In that vein https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=database%20internals&sort=byPopularity&type=story https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...

jpamata 3y ago

"How Query Engines Work" by Andy Grove, you build one in Kotlin: https://leanpub.com/how-query-engines-work https://leanpub.com/how-query-engines-work The author also made it available for free at https://howqueryengineswork.com/00-introduction.html https://howqueryengineswork.com/00-introduction.html On implementation, my favourite is "Database Design and Implementation" by Ed Sciore, you write a relational DB in Java, including the parser.

finlaybw 3y ago
> "How Query Engines Work" by Andy Grove, you build one in Kotlin: https://leanpub.com/how-query-engines-work https://leanpub.com/how-query-engines-work I have come across this, but unfortunately it feels like a book written for someone who already knows the topic. For example, the logical plans did not even bother explaining what logical plans are, where it fits into the whole picture etc https://howqueryengineswork.com/05-logical-plan.html https://howqueryengineswork.com/05-logical-plan.html

mejutoco 3y ago

I don‘t know if you: - did not do any research - want someone to link to the book "database internals" But, in the spirit of the most charitable interpretation and, as it is a good book: https://www.goodreads.com/book/show/44647144-database-internals https://www.goodreads.com/book/show/44647144-database-intern...

finlaybw 3y ago
Took a look at this, but it looks like it is missing the query engine parts, which is one of the things I am currently interesting in learning more about - perhaps more so than the persistence and distributed parts