|
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
|
|
|
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: Fri, 5/9, 12:00-2:00 pm
The exam must be taken at this time, so please
plan your travel accordingly!
|