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