6.5830/6.5831: Database Systems
Fall 2022

6.5830/6.5831 lectures are held from 2:30 – 4:00 pm on Mondays and Wednesdays in 32-155.

Monday Tuesday Wednesday Thursday Friday
Sep 5
Labor Day
Sep 6
Registration Day
Sep 7
First Day of Classes
Lec 1: Introduction to Databases
Sep 8
Sep 9
Sep 12
Lec 2: The Relational Model / SQL Part 1
Reading Assignment

Assigned: PS 1
Sep 13
Sep 14
Lec 3: SQL Part 2
Reading Assignment

Assigned: Lab 1
Sep 15
Sep 16
Sep 19
Lec 4: Schema Design
Reading Assignment
Sep 20
Sep 21
Lec 5: Intro to Database Internals
Reading Assignment
Due: PS 1
Sep 22
Sep 23
Student Holiday
Sep 26
Lec 6: Database Operators and Query Processing
Reading Assignment

Assigned: Lab 2
Sep 27
Sep 28
Lec 7: Indexing and Access Methods
Reading Assignment

Due: Lab 1
Due: Project teams (6.5830 only)
Assigned: PS 2
Sep 29
Sep 30
Oct 3
Lec 8: Join Algorithms
Reading Assignment
Oct 4
Oct 5
Lec 9: Database Layout for Analytic Databases
Reading Assignment

Due: Lab 2
Assigned: Lab 3
Oct 6
Oct 7
ADD DATE
Oct 10
Indigenous Peoples' Day
Oct 11
Student Holiday
Oct 12
Lec 10: Query Optimization
Reading Assignment

Due: Project proposals (only if doing final project)
Oct 13
Oct 14
Oct 17
Lec 11: Advanced Cardinality Estimation

Due: PS 2
Quiz 1 Review Session
(7 to 8 pm in 32-155)
Oct 18
Oct 19
Quiz 1
Oct 20
Oct 21
Oct 24
Lec 12: Transactions And Locking
Reading Assignment

Assigned: Lab 4
Oct 25
Oct 26
Lec 13: Optimistic Concurrency Control and Snapshot Isolation
Reading Assignment

Due: Lab 3
Oct 27
Oct 28
Oct 31
Lec 14: Recovery
Reading Assignment

Assigned: PS 3
Nov 1
Nov 2
Lec 15: Recovery (cont.)
Reading Assignment
Nov 3
Nov 4
Nov 7
Lec 16: Distributed Databases
Reading Assignment
Nov 8
Nov 9
Lec 17: Distributed Transactions
Reading Assignment

Due: Lab 4
Assigned: Lab 5 (6.5831 only)
Nov 10
Nov 11
Veterans Day
Nov 14
Lec 18: Eventual Consistency
Reading Assignment

Final projects meetings & mid-term reports this week (6.5830 only)
Nov 15
Nov 16
Lec 19: High Performance Transactions
Reading Assignment
Nov 17
Nov 18
Nov 21
Lec 20: Cluster Computing Part 1 (MapReduce / Hadoop)
Reading Assignment

Due: Lab 5 (6.5831 only)
Nov 22
Nov 23
No Lecture
DROP DATE
Nov 24
Thanksgiving
Nov 25
Institute Holiday
Nov 28
Lec 21: Cluster Computing Part 2
Reading Assignment

Assigned: Lab 6 (6.5831 only)
Nov 29
Nov 30
Lec 22: Learned Data Systems
Reading Assignment
Dec 1
Dec 2
Dec 5
Lec 23: Project Meetings / Quiz Review
Due: PS 3
Dec 6
Dec 7
Quiz 2
Dec 8
Dec 9
Dec 12
Lec 24: Research Topics
Dec 13
Dec 14
Last Day of Classes
Final project presentations.
Due: Lab 6 (6.5831 only)
Due: Project Report and Presentations (6.5830 only)
Dec 15
Dec 16
Last change: November 26 2022.

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