|
0
|
1/21, 1/23
|
- Course overview and introduction
- Database design and ER diagrams
- The relational model
- No labs this week.
|
|
1
|
1/26, 1/28, 1/30
|
- The relational model (cont.)
- Relational algebra and SQL
|
|
2
|
2/2, 2/4, 2/6
|
- SQL (cont.)
- Storage fundamentals; record formats
- 2/2: last day to add a class
- Problem Set 1, part I due on 2/3
|
|
3
|
2/9, 2/11, 2/13
|
- Index structures
- Implementing a logical-to-physical mapping
- Problem Set 1, part II due on 2/10
|
|
4
|
2/17, 2/18,
2/20
|
- Query processing
- Semi-structured data and XML
- No lecture on 2/16 (holiday)
- Lecture on 2/17 (Monday schedule)
- Problem Set 2 (all) due on 2/17
|
|
5
|
2/23, 2/25, 2/27
|
- XML queries
- Transactions and schedules
- 2/24: last day to drop without a ‘W’
- Midterm 1 on 2/27
|
|
6
|
3/2, 3/4, 3/6
|
- Transactions and schedules (cont.)
- Problem Set 3, part I due on 3/5 (Thursday)
|
|
|
Spring break
|
|
7
|
3/16, 3/18, 3/20
|
|
|
8
|
3/23, 3/25, 3/27
|
- Concurrency control (cont.)
- Problem Set 3, part II due on 3/24
|
|
9
|
3/30, 4/1, 4/3
|
- Distributed databases and replication
- Map-reduce
- 4/3: last day to drop with a ‘W’ or change
to Pass/Fail
- Problem Set 4, part I due on 3/31
|
|
10
|
4/6, 4/8, 4/10
|
- Map-reduce (cont.); NoSQL
- Midterm 2 on 4/10
|
|
11
|
4/13, 4/15, 4/17
|
- NoSQL (cont.); recovery and logging
|
|
12
|
4/22, 4/24
|
- Recovery and logging (cont.)
- No lecture on 4/20 (holiday)
- Problem Set 4, part II due on 4/21
|
|
13
|
4/27, 4/29
|
- Two-phase commit; wrap-up and review
- Problem Set 5 (all) due on 4/28
- 5/1-3: Study period
|
|
14
|
|
- Final exam: Fri, 5/8, 9:00-11:00 am
The exam must be taken at this time, so please
plan your travel accordingly!
|