Schedule

1

9/3

Introduction
ER diagrams and the relational model

2

9/10

Relational algebra and SQL

3

9/17

SQL (cont.)
Storage and indexing

4

9/24

Storage and indexing (cont.)
Implementing a logical-to-physical mapping
Problem Set 1 due

5

10/1

Transactions and schedules; concurrency control

6

10/8

Concurrency control (cont.)

7

10/15

Semi-structured data and XML
Problem Set 2 due

8

10/22

Midterm exam

9

10/29

Distributed databases and replication;
processing distributed data using MapReduce

10

11/5

MapReduce (cont.)
NoSQL Problem Set 3 due

11

11/12

NoSQL (cont.)

12

11/19

Recovery and logging

13

11/26

Recovery and logging (cont.)
Problem Set 4 due

14

12/3

Performance tuning; wrap-up and conclusions

15

12/10

Review session
Problem Set 5 due on Sunday, December 15; no late submissions accepted after Sunday, December 15

16

12/17

Final exam