6.5830/6.5831 lectures are held from 2:30 – 4:00 pm on Mondays and Wednesdays in 45-230.
| Monday | Tuesday | Wednesday | Thursday | Friday |
| Sep 2 Labor Day |
Sep 3 Registration Day |
Sep 4 First Day of Classes Lec 1: Introduction to Databases / Relational Model / SQL Part 1 Assigned: Lab 0 |
Sep 5 |
Sep 6 Registration Deadline |
| Sep 9 Lec 2: SQL Part 2 Reading Assignment Assigned: PS 1 TA OH: 4-6pm Virtual (Link) |
Sep 10 |
Sep 11 Lec 3: Schema Design Reading Assignment Assigned: Lab 1 Due: Lab 0 |
Sep 12 |
Sep 13 Sylvia OH: 4-6pm 32-G9 Lounge |
| Sep 16 Lec 4: Intro to Database Internals Reading Assignment Mark OH: 4-6pm 32-G9 Lounge |
Sep 17 |
Sep 18 Lec 5: Database Operators and Query Processing Reading Assignment Due: PS 1 |
Sep 19 Lab 1 Bootcamp: 5-6pm 32-G449 (Kiva) |
Sep 20 |
| Sep 23 Lec 6: Indexing and Access Methods Reading Assignment Assigned: Lab 2 Mark OH: 4-6pm 32-G9 Lounge |
Sep 24 |
Sep 25 Lec 7: Join Algorithms Reading Assignment Due: Lab 1 Due: Project teams (if doing final project) Assigned: PS 2 |
Sep 26 |
Sep 27 Sylvia OH: 4-6pm 32-G9 Lounge |
| Sep 30 Lec 8: Query Optimization Reading Assignment Mark OH: 4-6pm 32-G9 Lounge |
Oct 1 |
Oct 2 Lec 9: Database Layout for Analytic Databases Reading Assignment |
Oct 3 |
Oct 4 ADD DATE Quiz 1 review session: 4-5pm 32-D463 (Star) Lab 2 Bootcamp: 5-6pm 32-D463 (Star) |
| Oct 7 Lec 10: Database Layout for Analytic Databases Part 2 Reading Assignment Due: PS 2 Mark OH: 4-6pm 32-G9 Lounge |
Oct 8 Sylvia OH: 5:30-6:30pm 32-G9 Lounge (Quiz review/pset, no lab debugging) |
Oct 9 Quiz 1 |
Oct 10 |
Oct 11 Due: Project proposals (if doing a final project) Sylvia OH: 4-6pm 32-G9 Lounge (This OH will end at 5:30pm if there is no attendance) |
| Oct 14 Indigenous Peoples' Day |
Oct 15 Student Holiday |
Oct 16 Lec 11: Transaction and Locking Reading Assignment Other: Project meetings | Oct 17 |
Oct 18 Sylvia OH: 5-7pm 32-G9 Lounge |
| Oct 21 Lec 12: Recovery Reading Assignment Due: Lab 2 Assigned: Lab 3 Other: Project meetings Mark OH: 4-6pm 32-G9 Lounge |
Oct 22 |
Oct 23 Lec 13: Recovery Part 2 Reading Assignment |
Oct 24 |
Oct 25 Sylvia OH: 4-6pm 32-G9 Lounge (This OH will end at 5:00pm if there is no attendance) |
| Oct 28 Lec 14: Optimistic Concurrency Control and Snapshot Isolation Reading Assignment Mark OH: 4-6pm 32-G9 Lounge |
Oct 29 |
Oct 30 Lec 15: Distributed Databases Reading Assignment Assigned: PS 3 Due: Lab 3 checkpoint |
Oct 31 Lab 3 Bootcamp: 32-D463 (Star Room) |
Nov 1 Sylvia OH: 4-6pm 32-G9 Lounge |
| Nov 4 Lec 16: Distributed Transactions Reading Assignment Assigned: Lab 4 Sylvia OH: 5-6:45pm 32-G9 Lounge |
Nov 5 |
Nov 6 Lec 17: Advanced Cardinality Estimation Due: Lab 3 Other: Project meetings |
Nov 7 |
Nov 8 Due: Mid-term reports Mark OH: 4-6pm 32-G9 Lounge |
| Nov 11 Veterans Day |
Nov 12 |
Nov 13 Lec 18: Eventual Consistency Reading Assignment Due: Lab 4 Plan |
Nov 14 |
Nov 15 |
| Nov 18 Lec 19: Cluster Computing (Spark) Reading Assignment |
Nov 19 |
Nov 20 Quiz 2 DROP DATE |
Nov 21 |
Nov 22 |
| Nov 25 Lec 20: High Performance Transactions Reading Assignment Due: PS 3 |
Nov 26 |
Nov 27 No class: Day Before Thanksgiving |
Nov 28 Thanksgiving |
Nov 29 Institute Holiday |
| Dec 2 Lec 21: SnowFlake Reading Assignment |
Dec 3 |
Dec 4 Lec 22: Additional Topics |
Dec 5 |
Dec 6 |
| Dec 9 Lec 23: Final Project Presentations Due: Lab 4 (6.5831 only) Due: Project Report + Video submission (6.5830 only) |
Dec 10 |
Dec 11 Lec 24: Final Project Presentations Last Day of Classes |
Dec 12 |
Dec 13 |
Last change: November 08 2024.
|
Questions or comments regarding 6.5830/6.5831? Send e-mail to the 6.5830/6.5831 staff at 6.5830-staff at mit.edu. Accessibility |