|
CS 432 Fall 2001: Class Schedule
(Draft) |
||||
|
Date |
Chapter |
Topic |
Remarks |
Teacher |
|
31-Aug |
1 |
Introduction |
Assignment 0 out | Johannes |
|
3-Sep |
7 |
Disks and
Files (Buffer Management) |
Assignment 1 out | Jai |
|
5-Sep |
2 |
The
Entity-Relationship Model |
Assignment 0 due | Jai |
|
7-Sep |
2 |
The
Entity-Relationship Model |
Jai | |
|
10-Sep |
3 |
The
Relational Model |
Johannes | |
|
12-Sep |
3 |
The
Relational Model |
Johannes | |
|
14-Sep |
4 |
Relational
Algebra |
Johannes | |
|
17-Sep |
4 |
Relational
Calculus |
Johannes | |
|
19-Sep |
5 |
SQL |
Johannes | |
| 20-Sep |
due date |
Assignment 1 due | ||
|
21-Sep |
5 |
SQL |
Johannes | |
|
24-Sep |
5 |
|
Jai | |
|
26-Sep |
8 |
|
Jai | |
| 27-Sep | due date | Assignment 2 due | ||
|
28-Sep |
9 |
Tree-Structured Indexes |
Jai | |
|
1-Oct |
9 |
Tree-Structured
Indexes |
Jai | |
|
3-Oct |
10 |
|
Johannes | |
| 4-Oct | exam | First exam | ||
|
5-Oct |
10 |
Hash-based
Indexing |
Johannes | |
|
8-Oct |
no class | Fall break | Johannes | |
|
10-Oct |
11 |
External Sorting |
||
|
12-Oct |
11 |
External
Sorting |
CS433 Assignment due | Johannes |
|
15-Oct |
12 |
Evaluation of Relational Operators | Johannes | |
|
17-Oct |
12 |
Evaluation
of Relational Operators |
Johannes | |
|
19-Oct |
12 |
Evaluation
of Relational Operators |
Johannes | |
|
22-Oct |
13 |
Introduction to Query Optimization |
Jai | |
| 23-Oct | due date | Assignment 3 due | ||
|
24-Oct |
14 |
A Typical Relational Query Optimizer |
Jai | |
|
26-Oct |
14 |
A Typical
Relational Query Optimizer |
Jai | |
|
29-Oct |
15 |
Schema Refinement and Normal Forms |
Jai | |
| 30-Oct | due date | Assignment 4 due | ||
|
31-Oct |
15 |
Schema
Refinement and Normal Forms |
Jai | |
|
2-Nov |
16 |
Schema Refinement and Normal Forms |
Johannes | |
|
5-Nov |
Review session | Jai | ||
| 6-Nov | exam | Second Exam | ||
|
7-Nov |
16 |
Physical Database Design & Database Tuning |
Jai | |
|
9-Nov |
Special Lecture by Prof. Jennifer Widom | Jai | ||
|
12-Nov |
17 |
Security |
Jai | |
|
14-Nov |
18 |
Transaction Management Overview |
Jai | |
|
16-Nov |
19 |
Concurrency Control | Jai | |
|
19-Nov |
19 |
Concurrency Control |
Jai | |
| 20-Nov | due date | Assignment 5 due | ||
|
21-Nov |
no class |
|||
|
23-Nov |
no class |
|||
|
26-Nov |
20 |
Crash Recovery |
Johannes | |
|
28-Nov |
20 |
Crash Recovery | Johannes | |
|
30-Nov |
20 |
Crash Recovery | Johannes | |
|
3-Dec |
21 |
Parallel Database Systems | Johannes | |
| 4-Dec | due date | Assignment 6 due | ||
|
5-Dec |
23 |
Decision Support | Jai | |
|
7-Dec |
Preparation for the Final Exam |
Johannes | ||