Schedule

0

9/4, 9/6

• Course overview and introduction
• Database design and ER diagrams
• The relational model

1

9/9, 9/11, 9/13

• The relational model (cont.)
• Relational algebra and SQL

2

9/16, 9/18, 9/20

• SQL (cont.)
• Storage
• 9/16: last day to add a class
• Problem Set 1, part I due on 9/17

3

9/23, 9/25

• Storage (cont.)
• Indexing
• No lecture on 9/27 (Presidential inauguration)

4

9/30, 10/2, 10/4

• Indexing (cont.)
• Semi-structured data and XML databases
• Problem Set 1, part II due on 10/1

5

10/7, 10/9, 10/11

• XML databases (cont.)
• Implementing a logical-to-physical mapping
• 10/8: last day to drop without a ‘W’
• Problem Set 2, part I due on 10/8

6

10/15, 10/16, 10/18

• Transactions and schedules
• No lecture on 10/14 (holiday)
• Lecture on 10/15 (Monday schedule)
• Problem Set 2, part II due on 10/15

7

10/21, 10/23, 10/25

• Transactions (cont.)
• Midterm 1 on 10/21

8

10/28, 10/30, 11/1

• Concurrency control

9

11/4, 11/6, 11/8

• Concurrency control (cont.)
• Distributed databases and replication
• Problem Set 3 (all) due on 11/5

10

11/11, 11/13, 11/15

• Distributed databases (cont.): map-reduce
• NoSQL
• 11/12: last day to drop with a ‘W’ or change to Pass/Fail
• Problem Set 4, part I due on 11/12

11

11/18, 11/20, 11/22

• NoSQL (cont.)
• Midterm 2 on 11/18

12

11/25

• Recovery and logging
• No lecture on 11/27 or 11/29 (Thanksgiving)
• Problem Set 4, part II due on 11/25 (Monday)

13

12/2, 12/4, 12/6

• Recovery and logging (cont.)
• Performance tuning

14

12/9

• Wrap-up and review
• Problem Set 5 (all) due on 12/9 (Monday)
• 12/11-13: Study period

15

• Final exam: Fri, 12/20, 12:00-2:00 pm
  The exam must be taken at this time, so please plan your travel accordingly!