What is this?
A curated collection of learning materials — papers, textbooks, university courses, talks and blog posts — for understanding how databases work internally, covering everything from query optimization to storage, concurrency control and distributed consensus.
A curated collection of learning materials — papers, textbooks, university courses, talks and blog posts — for understanding how databases work internally, covering everything from query optimization to storage, concurrency control and distributed consensus.Is this a self-contained course or just a collection of links?It's a reference index of external resources — links to papers, books, university course pages, conference talks and blog posts grouped by database topic, not a self-contained course.
It's a reference index of external resources — links to papers, books, university course pages, conference talks and blog posts grouped by database topic, not a self-contained course.How is the list organized?It's structured as a table of contents by database subsystem — SQL & relational algebra, query optimizer, query execution, transactions, storage, networking, replication, consensus, benchmarking, HTAP, TLA+ — each topic broken into Courses, Books, Talks, Blogs and Papers subsections.
It's structured as a table of contents by database subsystem — SQL & relational algebra, query optimizer, query execution, transactions, storage, networking, replication, consensus, benchmarking, HTAP, TLA+ — each topic broken into Courses, Books, Talks, Blogs and Papers subsections.Is every entry carefully vetted, or does anyone add resources?There's no formal vetting process described; new material gets added through community pull requests, so the list's quality depends on ongoing contributions rather than a fixed curation standard.
There's no formal vetting process described; new material gets added through community pull requests, so the list's quality depends on ongoing contributions rather than a fixed curation standard.Who is this list aimed at?Database engineers, grad students and anyone building or studying a database engine who wants to go beyond writing SQL and understand internals like optimizers, storage engines and distributed transactions — many entries are pulled from CMU, Berkeley and Stanford database courses.
Database engineers, grad students and anyone building or studying a database engine who wants to go beyond writing SQL and understand internals like optimizers, storage engines and distributed transactions — many entries are pulled from CMU, Berkeley and Stanford database courses.What topics are covered beyond basic SQL?Topics range from query optimizers, join ordering and cardinality estimation to vectorized execution, hash tables, buffer management, LSM-trees, learned indexes, replication, consensus, HTAP, and even formal verification with TLA+.
Topics range from query optimizers, join ordering and cardinality estimation to vectorized execution, hash tables, buffer management, LSM-trees, learned indexes, replication, consensus, HTAP, and even formal verification with TLA+.Is everything in English?Mostly, but several highly-regarded blog posts are in Chinese (e.g. '数据库内核杂谈' and 'SQL优化器原理'), alongside the predominantly English papers, books and courses.
Mostly, but several highly-regarded blog posts are in Chinese (e.g. '数据库内核杂谈' and 'SQL优化器原理'), alongside the predominantly English papers, books and courses.Which university courses does it recommend?It highlights CMU's Database Systems (15-445/645) and Advanced Database Systems (15-721) by Andy Pavlo, UC Berkeley's Introduction to Database Systems, Stanford's Database System Implementation, and Cornell's Introduction to Database Systems.
It highlights CMU's Database Systems (15-445/645) and Advanced Database Systems (15-721) by Andy Pavlo, UC Berkeley's Introduction to Database Systems, Stanford's Database System Implementation, and Cornell's Introduction to Database Systems.Where should a beginner start?The 'Recommended Courses, Books and Talks' section at the top is meant as the entry point before diving into the more specialized topic sections like query optimization or storage.
The 'Recommended Courses, Books and Talks' section at the top is meant as the entry point before diving into the more specialized topic sections like query optimization or storage.What are similar projects?awesome-deep-vision, awesome-distributed-systems, awesome-computer-vision, awesome-programming-books, awesome-courses, awesome-design-patterns, architect-awesome, GoBooks
awesome-deep-vision, awesome-distributed-systems, awesome-computer-vision, awesome-programming-books, awesome-courses, awesome-design-patterns, architect-awesome, GoBooksWhich topics is it in?awesome-lists, books, nosql, papers, algorithms, course, computer-science, sql, academic-research, book, awesome, distributed-systems
awesome-lists, books, nosql, papers, algorithms, course, computer-science, sql, academic-research, book, awesome, distributed-systems