Schedule

0

1/22, 1/24

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

1

1/27, 1/29, 1/31

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

2

2/3, 2/5, 2/7

• SQL (cont.)
• Storage fundamentals
• 2/3: last day to add a class
• Problem Set 1, part I due on 2/4

3

2/10, 2/12, 2/14

• Storage (cont.)
• Indexing

4

2/18, 2/19, 2/21

• Semi-structured data and XML databases
• No lecture on 2/17 (holiday)
• Lecture on 2/18 (Monday schedule)
• Problem Set 1, part II due on 2/18

5

2/24, 2/26, 2/28

• Implementing a logical-to-physical mapping
• Query processing
• Transactions and schedules
• 2/25: last day to drop without a ‘W’
• Problem Set 2, part I due on 2/25

6

3/3, 3/5, 3/7

• Transactions and schedules (cont.)
• Midterm 1 on 3/3

Spring break

7

3/17, 3/19, 3/21

• Concurrency control
• Problem Set 2, part II due on 3/20 (Thursday)

8

3/24, 3/26, 3/28

• Concurrency control (cont.)

9

3/31, 4/2, 4/4

• Distributed databases and replication
• Map-reduce
• 4/4: last day to drop with a ‘W’ or change to Pass/Fail
• Problem Set 3 (all) due on 4/1

10

4/7, 4/9, 4/11

• Map-reduce (cont.)
• NoSQL
• Problem Set 4, part I due on 4/8

11

4/14, 4/16, 4/18

• NoSQL (cont.)
• Recovery and logging
• Midterm 2 on 4/16

12

4/23, 4/25

• Recovery and logging (cont.)
• No lecture on 4/21 (holiday)
• Problem Set 4, part II due on 4/22

13

4/28, 4/30

• Two-phase commit; wrap-up and review
• Problem Set 5 (all) due on 4/29
• 5/2-4: Study period

14

• Final exam: date and time TBD
• Please wait until your instructor informs you of the date before you make any travel plans.
• Make sure you are available through the end of the exam period on Friday, May 9!