# Schedule | CMU 15-445/645 :: Intro to Database Systems (Fall 2025) https://15445.courses.cs.cmu.edu/fall2025/schedule.html [![](https://15445.courses.cs.cmu.edu/fall2025/images/cmudb-icon-white.svg) CMU 15-445/645](https://15445.courses.cs.cmu.edu/fall2025 "CMU 15-445/645") * [Assignments](https://15445.courses.cs.cmu.edu/fall2025/assignments.html) * [FAQ](https://15445.courses.cs.cmu.edu/fall2025/faq.html) * [Schedule](https://15445.courses.cs.cmu.edu/fall2025/schedule.html) * [Syllabus](https://15445.courses.cs.cmu.edu/fall2025/syllabus.html) * [ Youtube](https://www.youtube.com/playlist?list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5 "Youtube") * [ Piazza](https://piazza.com/cmu/fall2025/15445645 "Piazza") [ **NOTICE:** This is an archived version of the course. Click here to view the latest offering. ](https://15445.courses.cs.cmu.edu/ "View latest version of 15-445/645") # Schedule Last Updated: Dec 04, 2025 Last Updated: Dec 04, 2025 | Date | Topic | Slides | Notes | Video | | --- | --- | --- | --- | --- | | Aug 25 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#aug-25-2025 "Anchor Link: Aug 25") | #01: Relational Model & Algebra Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/01-relationalmodel.pdf "SLIDES \(Lecture #01\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/01-relationalmodel.pdf "NOTES \(Lecture #01\)") Video: [Watch ](https://www.youtube.com/watch?v=7NPIENPr-zk&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=1 "VIDEO \(Lecture #01\)") Readings: Chapters 1-2 Project: [C++ Primer](https://15445.courses.cs.cmu.edu/fall2025/project0/) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/01-relationalmodel.pdf "SLIDES \(Lecture #01\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/01-relationalmodel.pdf "NOTES \(Lecture #01\)") | [](https://www.youtube.com/watch?v=7NPIENPr-zk&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=1 "VIDEO \(Lecture #01\)") | | Aug 27 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#aug-27-2025 "Anchor Link: Aug 27") | #02: Modern SQL Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/02-modernsql.pdf "SLIDES \(Lecture #02\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/02-modernsql.pdf "NOTES \(Lecture #02\)") Video: [Watch ](https://www.youtube.com/watch?v=O5gU9NQjCAs&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=2 "VIDEO \(Lecture #02\)") Flash Talk: [Drew Banin](https://www.linkedin.com/in/drewbanin) ([dbt Labs](https://www.getdbt.com/)) Readings: Chapters 3-5 Homework: [SQL](https://15445.courses.cs.cmu.edu/fall2025/homework1/) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/02-modernsql.pdf "SLIDES \(Lecture #02\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/02-modernsql.pdf "NOTES \(Lecture #02\)") | [](https://www.youtube.com/watch?v=O5gU9NQjCAs&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=2 "VIDEO \(Lecture #02\)") | | Sep 01 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-01-2025 "Anchor Link: Sep 01") | _Labor Day — No Class_ | | | | | Sep 03 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-03-2025 "Anchor Link: Sep 03") | #03: Database Storage I (⚠ No In-Class Lecture) Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/03-storage1.pdf "SLIDES \(Lecture #03\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/03-storage1.pdf "NOTES \(Lecture #03\)") Video: [Watch ](https://www.youtube.com/watch?v=PRLXdIMJhOg&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=3 "VIDEO \(Lecture #03\)") Readings: Chapter 12.1-12.4, 13.2-13.3 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/03-storage1.pdf "SLIDES \(Lecture #03\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/03-storage1.pdf "NOTES \(Lecture #03\)") | [](https://www.youtube.com/watch?v=PRLXdIMJhOg&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=3 "VIDEO \(Lecture #03\)") | | Sep 08 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-08-2025 "Anchor Link: Sep 08") | #04: Memory Management Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/04-bufferpool.pdf "SLIDES \(Lecture #04\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/04-bufferpool.pdf "NOTES \(Lecture #04\)") Video: [Watch ](https://www.youtube.com/watch?v=8-2yv4z0VZc&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=4 "VIDEO \(Lecture #04\)") Readings: Chapter 13.2-13.5 Project: [Buffer Pool Manager](https://15445.courses.cs.cmu.edu/fall2025/project1/) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/04-bufferpool.pdf "SLIDES \(Lecture #04\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/04-bufferpool.pdf "NOTES \(Lecture #04\)") | [](https://www.youtube.com/watch?v=8-2yv4z0VZc&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=4 "VIDEO \(Lecture #04\)") | | Sep 10 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-10-2025 "Anchor Link: Sep 10") | #05: Database Storage II Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/05-storage2.pdf "SLIDES \(Lecture #05\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/05-storage2.pdf "NOTES \(Lecture #05\)") Video: [Watch ](https://www.youtube.com/watch?v=2_sTdS4h-bY&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=5 "VIDEO \(Lecture #05\)") Flash Talk: [Joseph Victor](https://www.linkedin.com/in/joseph-victor-72a44174/) ([SingleStore](https://www.singlestore.com/)) Readings: Chapter 14.8.1, 24.2 Homework: [Storage](https://15445.courses.cs.cmu.edu/fall2025/files/hw2-clean.pdf) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/05-storage2.pdf "SLIDES \(Lecture #05\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/05-storage2.pdf "NOTES \(Lecture #05\)") | [](https://www.youtube.com/watch?v=2_sTdS4h-bY&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=5 "VIDEO \(Lecture #05\)") | | Sep 15 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-15-2025 "Anchor Link: Sep 15") | #06: Storage Models & Compression Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/06-storage3.pdf "SLIDES \(Lecture #06\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/06-storage3.pdf "NOTES \(Lecture #06\)") Video: [Watch ](https://www.youtube.com/watch?v=yWnToWrskXE&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=6 "VIDEO \(Lecture #06\)") Readings: Chapter 11.2, 13.6 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/06-storage3.pdf "SLIDES \(Lecture #06\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/06-storage3.pdf "NOTES \(Lecture #06\)") | [](https://www.youtube.com/watch?v=yWnToWrskXE&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=6 "VIDEO \(Lecture #06\)") | | Sep 17 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-17-2025 "Anchor Link: Sep 17") | #07: Hash Tables Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/07-hashtables.pdf "SLIDES \(Lecture #07\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/07-hashtables.pdf "NOTES \(Lecture #07\)") Video: [Watch ](https://www.youtube.com/watch?v=nuNW8IfgPNU&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=7 "VIDEO \(Lecture #07\)") Flash Talk: [Karthik Ranganathan](https://www.linkedin.com/in/kranganathan/) ([YugabyteDB](https://www.yugabyte.com/)) Readings: Chapter 14.5, 24.5 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/07-hashtables.pdf "SLIDES \(Lecture #07\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/07-hashtables.pdf "NOTES \(Lecture #07\)") | [](https://www.youtube.com/watch?v=nuNW8IfgPNU&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=7 "VIDEO \(Lecture #07\)") | | Sep 22 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-22-2025 "Anchor Link: Sep 22") | #08: Indexes & Filters I Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/08-indexes1.pdf "SLIDES \(Lecture #08\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/08-indexes1.pdf "NOTES \(Lecture #08\)") Video: [Watch ](https://www.youtube.com/watch?v=u7ii_Lvm9rM&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=8 "VIDEO \(Lecture #08\)") Readings: Chapter 14.1-14.4 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/08-indexes1.pdf "SLIDES \(Lecture #08\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/08-indexes1.pdf "NOTES \(Lecture #08\)") | [](https://www.youtube.com/watch?v=u7ii_Lvm9rM&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=8 "VIDEO \(Lecture #08\)") | | Sep 24 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-24-2025 "Anchor Link: Sep 24") | #09: Indexes & Filters II Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/09-indexes2.pdf "SLIDES \(Lecture #09\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/09-indexes2.pdf "NOTES \(Lecture #09\)") Video: [Watch ](https://www.youtube.com/watch?v=PjST2n7abAY&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=9 "VIDEO \(Lecture #09\)") Readings: Chapter 14.1-14.4, 24.1 Homework: [Indexes & Filters](https://15445.courses.cs.cmu.edu/fall2025/files/hw3-clean.pdf) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/09-indexes2.pdf "SLIDES \(Lecture #09\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/09-indexes2.pdf "NOTES \(Lecture #09\)") | [](https://www.youtube.com/watch?v=PjST2n7abAY&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=9 "VIDEO \(Lecture #09\)") | | Sep 29 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#sep-29-2025 "Anchor Link: Sep 29") | #10: Index Concurrency Control Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/10-indexconcurrency.pdf "SLIDES \(Lecture #10\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/10-indexconcurrency.pdf "NOTES \(Lecture #10\)") Video: [Watch ](https://www.youtube.com/watch?v=YgOvfXl6pss&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=10 "VIDEO \(Lecture #10\)") Readings: Chapter 18.10.2 Project: [Database Index](https://15445.courses.cs.cmu.edu/fall2025/project2/) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/10-indexconcurrency.pdf "SLIDES \(Lecture #10\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/10-indexconcurrency.pdf "NOTES \(Lecture #10\)") | [](https://www.youtube.com/watch?v=YgOvfXl6pss&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=10 "VIDEO \(Lecture #10\)") | | Oct 01 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-01-2025 "Anchor Link: Oct 01") | #11: Sorting & Aggregations Algorithms Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/11-sorting.pdf "SLIDES \(Lecture #11\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/11-sorting.pdf "NOTES \(Lecture #11\)") Video: [Watch ](https://www.youtube.com/watch?v=LzyKTpeIgts&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=11 "VIDEO \(Lecture #11\)") Flash Talk: [Boaz Leskes](https://www.linkedin.com/in/boazleskes/) ([MotherDuck](https://motherduck.com/)) Readings: Chapter 15.4-15.5 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/11-sorting.pdf "SLIDES \(Lecture #11\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/11-sorting.pdf "NOTES \(Lecture #11\)") | [](https://www.youtube.com/watch?v=LzyKTpeIgts&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=11 "VIDEO \(Lecture #11\)") | | Oct 06 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-06-2025 "Anchor Link: Oct 06") | #12: Joins Algorithms Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/12-joins.pdf "SLIDES \(Lecture #12\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/12-joins.pdf "NOTES \(Lecture #12\)") Video: [Watch ](https://www.youtube.com/watch?v=YIdIaPopfpk&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=12 "VIDEO \(Lecture #12\)") Readings: Chapter 15.4-15.6 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/12-joins.pdf "SLIDES \(Lecture #12\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/12-joins.pdf "NOTES \(Lecture #12\)") | [](https://www.youtube.com/watch?v=YIdIaPopfpk&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=12 "VIDEO \(Lecture #12\)") | | Oct 08 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-08-2025 "Anchor Link: Oct 08") | Mid-Term Exam | | | | | Oct 13 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-13-2025 "Anchor Link: Oct 13") | _Fall Break — No Class_ | | | | | Oct 15 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-15-2025 "Anchor Link: Oct 15") | _Fall Break — No Class_ | | | | | Oct 20 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-20-2025 "Anchor Link: Oct 20") | #13: Query Execution I Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/13-queryexecution1.pdf "SLIDES \(Lecture #13\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/13-queryexecution1.pdf "NOTES \(Lecture #13\)") Video: [Watch ](https://www.youtube.com/watch?v=E-UUd6cB57w&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=13 "VIDEO \(Lecture #13\)") Readings: Chapter 15.1-15.3, 15.7 Project: [Query Execution](https://15445.courses.cs.cmu.edu/fall2025/project3/) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/13-queryexecution1.pdf "SLIDES \(Lecture #13\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/13-queryexecution1.pdf "NOTES \(Lecture #13\)") | [](https://www.youtube.com/watch?v=E-UUd6cB57w&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=13 "VIDEO \(Lecture #13\)") | | Oct 22 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-22-2025 "Anchor Link: Oct 22") | #14: Query Execution II Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/14-queryexecution2.pdf "SLIDES \(Lecture #14\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/14-queryexecution2.pdf "NOTES \(Lecture #14\)") Video: [Watch ](https://www.youtube.com/watch?v=Kzf1hGjtZOU&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=14 "VIDEO \(Lecture #14\)") Flash Talk: [Will Manning](https://www.linkedin.com/in/will-manning-maker-of-things/) ([SpiralDB](https://spiraldb.com/)) Readings: Chapter 22 Homework: [Execution & Planning](https://15445.courses.cs.cmu.edu/fall2025/files/hw4-clean.pdf) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/14-queryexecution2.pdf "SLIDES \(Lecture #14\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/14-queryexecution2.pdf "NOTES \(Lecture #14\)") | [](https://www.youtube.com/watch?v=Kzf1hGjtZOU&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=14 "VIDEO \(Lecture #14\)") | | Oct 27 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-27-2025 "Anchor Link: Oct 27") | #15: Query Planning & Optimization I Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/15-optimization1.pdf "SLIDES \(Lecture #15\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/15-optimization1.pdf "NOTES \(Lecture #15\)") Video: [Watch ](https://www.youtube.com/watch?v=b53huOGcsZ8&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=15 "VIDEO \(Lecture #15\)") Readings: Chapter 16 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/15-optimization1.pdf "SLIDES \(Lecture #15\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/15-optimization1.pdf "NOTES \(Lecture #15\)") | [](https://www.youtube.com/watch?v=b53huOGcsZ8&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=15 "VIDEO \(Lecture #15\)") | | Oct 29 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#oct-29-2025 "Anchor Link: Oct 29") | #16: Query Planning & Optimization II Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/16-optimization2.pdf "SLIDES \(Lecture #16\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/16-optimization2.pdf "NOTES \(Lecture #16\)") Video: [Watch ](https://www.youtube.com/watch?v=azTHRpzl10o&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=16 "VIDEO \(Lecture #16\)") Readings: Chapter 16 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/16-optimization2.pdf "SLIDES \(Lecture #16\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/16-optimization2.pdf "NOTES \(Lecture #16\)") | [](https://www.youtube.com/watch?v=azTHRpzl10o&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=16 "VIDEO \(Lecture #16\)") | | Nov 03 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-03-2025 "Anchor Link: Nov 03") | #17: Concurrency Control Theory Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/17-concurrencycontrol.pdf "SLIDES \(Lecture #17\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/17-concurrencycontrol.pdf "NOTES \(Lecture #17\)") Video: [Watch ](https://www.youtube.com/watch?v=tMFAgvDViAI&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=17 "VIDEO \(Lecture #17\)") Readings: Chapter 18 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/17-concurrencycontrol.pdf "SLIDES \(Lecture #17\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/17-concurrencycontrol.pdf "NOTES \(Lecture #17\)") | [](https://www.youtube.com/watch?v=tMFAgvDViAI&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=17 "VIDEO \(Lecture #17\)") | | Nov 05 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-05-2025 "Anchor Link: Nov 05") | #18: Two-Phase Locking Concurrency Control Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/18-twophaselocking.pdf "SLIDES \(Lecture #18\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/18-twophaselocking.pdf "NOTES \(Lecture #18\)") Video: [Watch ](https://www.youtube.com/watch?v=drStlhNbfHI&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=18 "VIDEO \(Lecture #18\)") Flash Talk: [Benjamin Wagner 🇩🇪](https://www.linkedin.com/in/wagjamin) ([Firebolt](https://www.firebolt.io/)) Readings: Chapter 18.1-18.3, 18.9 Homework: [Transactions!](https://15445.courses.cs.cmu.edu/fall2025/files/hw5-clean.pdf) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/18-twophaselocking.pdf "SLIDES \(Lecture #18\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/18-twophaselocking.pdf "NOTES \(Lecture #18\)") | [](https://www.youtube.com/watch?v=drStlhNbfHI&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=18 "VIDEO \(Lecture #18\)") | | Nov 10 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-10-2025 "Anchor Link: Nov 10") | #19: Timestamp Ordering Concurrency Control Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/19-timestampordering.pdf "SLIDES \(Lecture #19\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/19-timestampordering.pdf "NOTES \(Lecture #19\)") Video: [Watch ](https://www.youtube.com/watch?v=risHwKeWbBM&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=19 "VIDEO \(Lecture #19\)") Readings: Chapter 18.5-18.6 Project: [Concurrency Control](https://15445.courses.cs.cmu.edu/fall2025/project4/) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/19-timestampordering.pdf "SLIDES \(Lecture #19\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/19-timestampordering.pdf "NOTES \(Lecture #19\)") | [](https://www.youtube.com/watch?v=risHwKeWbBM&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=19 "VIDEO \(Lecture #19\)") | | Nov 12 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-12-2025 "Anchor Link: Nov 12") | #20: Multi-Version Concurrency Control Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/20-multiversioning.pdf "SLIDES \(Lecture #20\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/20-multiversioning.pdf "NOTES \(Lecture #20\)") Video: [Watch ](https://www.youtube.com/watch?v=tUFha9-DuSk&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=20 "VIDEO \(Lecture #20\)") Readings: Chapter 18.7-18.8 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/20-multiversioning.pdf "SLIDES \(Lecture #20\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/20-multiversioning.pdf "NOTES \(Lecture #20\)") | [](https://www.youtube.com/watch?v=tUFha9-DuSk&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=20 "VIDEO \(Lecture #20\)") | | Nov 17 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-17-2025 "Anchor Link: Nov 17") | #21: Database Logging Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/21-logging.pdf "SLIDES \(Lecture #21\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/21-logging.pdf "NOTES \(Lecture #21\)") Video: [Watch ](https://www.youtube.com/watch?v=CedEy54pe3g&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=21 "VIDEO \(Lecture #21\)") Readings: Chapter 19.1-19.8 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/21-logging.pdf "SLIDES \(Lecture #21\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/21-logging.pdf "NOTES \(Lecture #21\)") | [](https://www.youtube.com/watch?v=CedEy54pe3g&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=21 "VIDEO \(Lecture #21\)") | | Nov 19 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-19-2025 "Anchor Link: Nov 19") | #22: Database Recovery Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/22-recovery.pdf "SLIDES \(Lecture #22\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/22-recovery.pdf "NOTES \(Lecture #22\)") Video: [Watch ](https://www.youtube.com/watch?v=X2jc4qalNy0&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=22 "VIDEO \(Lecture #22\)") Flash Talk: [Robert Schulze 🇩🇪](https://www.linkedin.com/in/robert-schulze-67951a1b8/) ([ClickHouse](https://clickhouse.com/)) Readings: Chapter 19.1-19.9 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/22-recovery.pdf "SLIDES \(Lecture #22\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/22-recovery.pdf "NOTES \(Lecture #22\)") | [](https://www.youtube.com/watch?v=X2jc4qalNy0&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=22 "VIDEO \(Lecture #22\)") | | Nov 24 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-24-2025 "Anchor Link: Nov 24") | #23: Distributed Database Systems I Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/23-distributed1.pdf "SLIDES \(Lecture #23\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/23-distributed1.pdf "NOTES \(Lecture #23\)") Video: [Watch ](https://www.youtube.com/watch?v=IFLQBWY6dlE&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=23 "VIDEO \(Lecture #23\)") Readings: Chapter 20.4-20.5, 21, 23.1-23.4 Homework: [Recovery](https://15445.courses.cs.cmu.edu/fall2025/files/hw6-clean.pdf) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/23-distributed1.pdf "SLIDES \(Lecture #23\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/23-distributed1.pdf "NOTES \(Lecture #23\)") | [](https://www.youtube.com/watch?v=IFLQBWY6dlE&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=23 "VIDEO \(Lecture #23\)") | | Nov 26 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#nov-26-2025 "Anchor Link: Nov 26") | _Thanksgiving — No Class_ | | | | | Dec 01 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#dec-01-2025 "Anchor Link: Dec 01") | #24: Distributed Database Systems II Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/24-distributed2.pdf "SLIDES \(Lecture #24\)") Notes: [Download ](https://15445.courses.cs.cmu.edu/fall2025/notes/24-distributed2.pdf "NOTES \(Lecture #24\)") Video: [Watch ](https://www.youtube.com/watch?v=pQh5fka3FC0&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=24 "VIDEO \(Lecture #24\)") Readings: Chapter 20.7, 22.9 | [](https://15445.courses.cs.cmu.edu/fall2025/slides/24-distributed2.pdf "SLIDES \(Lecture #24\)") | [](https://15445.courses.cs.cmu.edu/fall2025/notes/24-distributed2.pdf "NOTES \(Lecture #24\)") | [](https://www.youtube.com/watch?v=pQh5fka3FC0&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=24 "VIDEO \(Lecture #24\)") | | Dec 03 [](https://15445.courses.cs.cmu.edu/fall2025/schedule.html#dec-03-2025 "Anchor Link: Dec 03") | #25: Final Review + Systems Potpourri Slides: [Download ](https://15445.courses.cs.cmu.edu/fall2025/slides/25-potpourri.pdf "SLIDES \(Lecture #25\)") Video: [Watch ](https://www.youtube.com/watch?v=qiVUf9X6ItM&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=25 "VIDEO \(Lecture #25\)") Flash Talk: [Leonid Libkin](https://homepages.inf.ed.ac.uk/libkin/) ([RelationalAI](https://relational.ai/)) | [](https://15445.courses.cs.cmu.edu/fall2025/slides/25-potpourri.pdf "SLIDES \(Lecture #25\)") | — | [](https://www.youtube.com/watch?v=qiVUf9X6ItM&list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5&index=25 "VIDEO \(Lecture #25\)") | [![](https://15445.courses.cs.cmu.edu/fall2025/images/cmu-db-group.svg)](https://db.cs.cmu.edu "Carnegie Mellon Database Group") Archives * [Spring 2025 ](https://15445.courses.cs.cmu.edu/spring2025/ "View Previous Course Website") * [Fall 2024 ](https://15445.courses.cs.cmu.edu/fall2024/ "View Previous Course Website") * [Spring 2024 ](https://15445.courses.cs.cmu.edu/spring2024/ "View Previous Course Website") * [Fall 2023 ](https://15445.courses.cs.cmu.edu/fall2023/ "View Previous Course Website") * [Spring 2023 ](https://15445.courses.cs.cmu.edu/spring2023/ "View Previous Course Website") * [Fall 2022 ](https://15445.courses.cs.cmu.edu/fall2022/ "View Previous Course Website") * [Fall 2021 ](https://15445.courses.cs.cmu.edu/fall2021/ "View Previous Course Website") * [Fall 2020 ](https://15445.courses.cs.cmu.edu/fall2020/ "View Previous Course Website") * [Fall 2019 ](https://15445.courses.cs.cmu.edu/fall2019/ "View Previous Course Website") * [Fall 2018 ](https://15445.courses.cs.cmu.edu/fall2018/ "View Previous Course Website") * [Fall 2017 ](https://15445.courses.cs.cmu.edu/fall2017/ "View Previous Course Website")