3 ms·
CMU 15-799: Special Topics in Databases: Query Optimization (Spring 2025)
- matt_d 2y agoSchedule (with readings & lectures): https://15799.courses.cs.cmu.edu/spring2025/schedule.html https://15799.courses.cs.cmu.edu/spring2025/schedule.html Lectures YouTube Playlist: https://www.youtube.com/playlist?list=PLSE8ODhjZXjYCZfIbmEWH7f6MnYqyPwCE https://www.youtube.com/playlist?list=PLSE8ODhjZXjYCZfIbmEWH... Announcement: https://discuss.systems/@andy_pavlo/113839208543526204 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/ 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/extensible-query-optimizers-in-practice/ 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"