6.5830/6.5831: Database Systems
Fall 2023

6.5830/6.5831 lectures are held from 2:30 – 4:00 pm on Mondays and Wednesdays in 32-155. We put down a tentative lecturer for each lecture.

Monday Tuesday Wednesday Thursday Friday
Sep 4
Labor Day
Sep 5
Registration Day
Sep 6
First Day of Classes
Lec 1: Introduction to Databases / Relational Model / SQL Part 1
Assigned: Lab 0
Sep 7
Sep 8
Sep 11
Lec 2: SQL Part 2
Reading Assignment

Assigned: PS 1
Sep 12
Sep 13
Lec 3: Schema Design
Reading Assignment

Assigned: Lab 1
Due: Lab 0
Sep 14
Sep 15
Sep 18
Lec 4: Intro to Database Internals
Reading Assignment
Sep 19
Sep 20
Lec 5: Database Operators and Query Processing
Reading Assignment
Due: PS 1
Sep 21
Sep 22
Sep 25
Lec 6: Indexing and Access Methods
Reading Assignment

Assigned: Lab 2
Sep 26
Sep 27
Lec 7: Join Algorithms
Reading Assignment

Due: Lab 1
Due: Project teams (6.5830 only)
Assigned: PS 2
Sep 28
Sep 29
Oct 2
Lec 8: Query Optimization
Reading Assignment
Oct 3
Oct 4
Lec 9: Database Layout for Analytic Databases
Reading Assignment
Oct 5
Oct 6
ADD DATE
Due: PS 2
Oct 9
Indigenous Peoples' Day
Oct 10
Student Holiday
Oct 11
Quiz 1
Assigned: Lab 3
Oct 12
Oct 13
Oct 16
Lec 10: Transactions And Locking
Reading Assignment

Due: Project proposals (only if doing final project)
Oct 17
Oct 18
Lec 11: Optimistic Concurrency Control and Snapshot Isolation
Reading Assignment

Due: Lab 2
Oct 19
Oct 20
Oct 23
Lec 12: Recovery
Reading Assignment
Oct 24
Oct 25
Lec 13: Recovery (cont.)
Reading Assignment

Other: Project Meetings
Oct 26
Oct 27
Oct 30
Lec 14: Advanced Cardinality Estimation
Assigned: PS 3
Other: Project Meetings
Oct 31
Nov 1
Lec 15: Distributed Databases
Reading Assignment

Due: Lab 3
Nov 2
Nov 3
Nov 6
Lec 16: Distributed Transactions
Reading Assignment

Assigned: Lab 4
Nov 7
Nov 8
Lec 17: Eventual Consistency
Reading Assignment
Nov 9
Nov 10
Veterans Day
Nov 13
Lec 18: High Performance Transactions
Reading Assignment

Final projects meetings & mid-term reports this week (6.5830 only)
Other: Project Meetings
Nov 14
Nov 15
Lec 19: Cluster Computing Part 1 (MapReduce / Hadoop)
Reading Assignment

Due: Lab 4 Plan
Other: Project Meetings
Nov 16
Nov 17
Nov 20
Lec 20: Cluster Computing Part 2 (Spark)
Reading Assignment
Nov 21
Nov 22
No Lecture
DROP DATE
Nov 23
Thanksgiving
Nov 24
Institute Holiday
Nov 27
Lec 21: Project Meetings / Quiz Review
Other: Lab 4 Plan Feedback
Nov 28
Nov 29
Quiz 2
Nov 30
Dec 1
Dec 4
Lec 22: Learned Data Systems
Reading Assignment

Due: PS 3
Dec 5
Dec 6
Lec 23: Additional Topics
Dec 7
Dec 8
Dec 11
Lec 24: Research Topics
Dec 12
Dec 13
Last Day of Classes
Final project presentations.
Due: Lab 4 (6.5831 only)
Due: Project Report and Presentations (6.5830 only)
Dec 14
Dec 15
Last change: September 25 2023.

Questions or comments regarding 6.5830/6.5831? Send e-mail to the 6.5830/6.5831 staff at . Accessibility