This is a special topics course on how to build a SQL optimizer from scratch covering foundational and state-of-the-art implementations. All lectures available on Youtube: https://15799.courses.cs.cmu.edu/spring2025/
One topic we will discuss is the Cascades optimizer architecture. There has never been a good description of how to implement it but the Microsoft Research Database Group just published a book that describes SQL Server's implementation. Microsoft has made the entire book available for free: https://www.microsoft.com/en-us/research/publication/extensi...
Query optimization is the hardest topic in databases and this is the first time I am offering this course. I am going to make mistakes and say incorrect things in my lectures. Send corrections to db-mistakes@cs.cmu.edu"
Lectures YouTube Playlist: https://www.youtube.com/playlist?list=PLSE8ODhjZXjYCZfIbmEWH...
Announcement: https://discuss.systems/@andy_pavlo/113839208543526204
"New @CMUDB Course: Database Query Optimization
This is a special topics course on how to build a SQL optimizer from scratch covering foundational and state-of-the-art implementations. All lectures available on Youtube: https://15799.courses.cs.cmu.edu/spring2025/
One topic we will discuss is the Cascades optimizer architecture. There has never been a good description of how to implement it but the Microsoft Research Database Group just published a book that describes SQL Server's implementation. Microsoft has made the entire book available for free: https://www.microsoft.com/en-us/research/publication/extensi...
Query optimization is the hardest topic in databases and this is the first time I am offering this course. I am going to make mistakes and say incorrect things in my lectures. Send corrections to db-mistakes@cs.cmu.edu"