6.830/6.814 Schedule and Readings

Monday

Tuesday

Wednesday

Thursday

Friday

Sept 6

Labor Day Holiday

Sept 7

Reg. Day

No class

Sept 8

Sept 9

Introduction (Carlo)

Sept 10

Sept 13

Sept 14

The Relational Model (Mike)

PS1 Out

Suggested Reading Lect. 2

Sept 15

Sept 16

Schema Design (Mike)

Suggested Reading Lect. 3

Sept 17

Sept 20

Sept 21

Introduction to Database Internals (Carlo)

Suggested Reading Lect. 4

PS1 Due

Lab1 Out

Sept 22

Sept 23

Database Operators and Query Processing (Carlo)

Suggested Reading Lect. 5 (nothing new)

Sept 24

Sept 27

Sept 28

Indexing and Access Methods (Carlo)

Suggested Reading Lect. 6

PS 2 Out

Project Teams Due

Sept 29

Sept 30

Buffer Pool Design and Memory Management (Carlo)

Suggested Reading Lect. 7

Lab 2 Out

Oct 1

Lab 1 Due

Oct 4

Oct 5

Join Algortithms (Carlo)

Suggested Reading Lect. 8

Oct 6

Oct 7

Query Optimization (Carlo)

Suggested Reading Lect. 9

Oct 8

Oct 11

Columbus Day Holiday

Oct 12

Transactions and Locking (Mike)

Suggested Reading Lect.10

PS2 Due

Oct 13

Oct 14

Optimistic Concurrency Control (Mike)

Suggested Reading Lect. 11

Project Proposal Due




Oct 15

Lab 2 Due

Oct 18

Oct 19

Exam 1


Sample Quiz | Solns

Oct 20

Lab 3 Out

Oct 21

Recovery (Mike)

Suggested Reading Lect. 12
.Doc | .Pdf

Oct 22

Oct 25

Oct 26

Recovery, Cont. (Mike)

Suggested Reading Lec. 13

Oct 27

Oct 28

Degrees of Consistency (Mike)

Suggested Reading Lec. 14


PS3 Out

Oct 29

Nov 1

Nov 2

C-Store (Sam)

Suggested Reading Lect. 15

Lab 3 Due

Nov 3

Nov 4

Distributed Transactions (Carlo)

Suggested Reading Lect. 16

Lab 4 Out (6.814 only)

Nov 5

Nov 8

Nov 9

Parallel Databases (Carlo)

Suggested Reading Lect. 17

Nov 10


Nov 11

Veterans Day Holiday

Nov 12

Nov 15


Nov 16

Scientific Databases (Mike)

Suggested Reading Lect. 18

Nov 17

Drop Date

Nov 18

NOSQL (Carlo)

Suggested Reading Lect. 19

Nov 19

Nov 22

Nov 23

ORM (Carlo)

Suggested Reading Lect. 20

Lab 4 Due (6.814 only)

Nov 24

Nov 25

Thanksgiving Holiday

No Class

Nov 26

Nov 29

Lab 5 Out (6.814 only)

Nov 30

Streaming Databases (Mike)

PS3 Due

Dec 1

Dec 2

Exam 2


Sample Quiz | Solns

Dec 3

Dec 6

Dec 7

Database as a Service (Carlo)

Dec 8

Dec 9

Final Project Presentations

Final projects due (6.830)

Lab 5 Due (6.814)

Last Day of Classes

Dec 10

Last change: 9/9/2009.