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