6.830 | Fall 2010 | Graduate, Undergraduate

Database Systems

Calendar

CC = Carlo Curino
MS = Michael Stonebraker

LEC # TOPICS KEY DATES
1 Introduction (CC)  
2 The relational model (MS) Problem set 1 out
3 Schema design (MS)  
4 Introduction to database internals (CC)

Problem set 1 due

Lab 1 out

5 Database operators and query processing (CC)  
6 Indexing and access methods (CC)

Problem set 2 out

Project teams due

7 Buffer pool design and memory management (CC)

Lab 1 due

Lab 2 out

8 Join algorithms (CC)  
9 Query optimization (CC)  
10 Transactions and locking (MS) Problem set 2 due
11 Optimistic concurrency control (MS)

Project proposal due

Lab 2 due

  Exam 1  
12 Recovery (MS) Lab 3 out
13 Recovery (MS)  
14 Degrees of consistency (MS) Problem set 3 out
15

C-store

Guest lecture: Sam Madden, MIT CSAIL

Lab 3 due
16 Distributed transactions (CC) Lab 4 out (6.814)
17 Parallel databases (CC)  
18 Scientific databases (MS)  
19 NOSQL (CC)  
20 ORM, DryadLINQ (CC) Lab 4 due (6.814)
21 Streaming databases (MS)

Problem set 3 due

Lab 5 out (6.814)

  Exam 2  
22 Database as a service (CC)  
23 Final project presentations

Final project due (6.830)

Lab 5 due (6.814)

Learning Resource Types
Exams with Solutions
Lecture Notes
Programming Assignments