CS448: Introduction to Relational Database Systems Implementation


Spring 2006

MWF 9:30-10:20AM
Room: CS-G066

 Tentative Class Schedule

FINAL EXAM: Tue May 02 2006 7:00pm- 9:00pm Room CS   G066

 

Date

Topic

Monday 1/9/2006

Introduction to Database Systems [ps][pdf]

Wednesday 1/11/2006

 

Friday 1/13/2006

Overview of the Relational Model [ps][pdf

Monday 1/16/2006

 

Wednesday 1/18/2006

Relational Algebra [ps][pdf

Friday 1/20/2006

 

Monday 1/23/2006

Relational Calculus [ps][pdf]

Wednesday 1/25/2006

 

Friday 1/27/2006

Overview of SQL:  Queries, Programming, Triggers [ps][pdf]

Monday 1/30/2006

 

Wednesday 2/1/2006

Disk Storage and Files  [ps][pdf]

Friday 2/3/2006

 

Monday 2/6/2006

File Organization and Indexing  [ps][pdf]

Wednesday 2/8/2006

 

Friday  2/10/2006

Tree-Structured Indexes [ps][pdf] [Video]

Monday 2/13/2006

 

Wednesday 2/15/2006

Hash-Based Indexes [ps][pdf]

Friday 2/17/2006

 

Monday 2/20/2006

External Sorting [ps][pdf]

Wednesday 2/22/2006

 

Friday 2/24/2006

 

Monday 2/27/2006

Midterm Exam (in class)

Wednesday 3/1/2006

Evaluation of Relational Operations: Part I  [ps][pdf]

Friday 3/3/2006

 

Monday 3/6/2006

Evaluation of Relational Operations: Part II [ps][pdf]

Wednesday 3/8/2006

 

Friday 3/10/2006

Introduction to Query Optimization [ps][pdf]

Monday 3/13/2006

Spring Break (no classes)

Wednesday 3/15/2006

Spring Break (no classes)

Friday 3/17/2006

Spring Break (no classes)

Monday 3/20/2006

Relational Query Optimization [ps][pdf]

Wednesday 3/22/2006

 

Friday 3/24/2006

 

Monday 3/27/2006 

Transaction Management [ps][pdf]

Wednesday  3/29/2006 

 

Friday  3/31/2006 

 

Monday 4/3/2006 

Concurrency Control [ps][pdf]

Wednesday 4/5/2006 

 

Friday  4/7/2006 

 

Monday 4/10/2006 

Crash Recovery [ps][pdf]

Wednesday 4/12/2006 

 

Friday  4/14/2006 

 

Monday 4/17/2006 

Parallel DBMS [ps][pdf]

Wednesday 4/19/2006 

 

Friday  4/21/2006 

 

Monday 4/24/2006 

Distributed Databases [ps][pdf]

Wednesday 4/26/2006 

 

Friday  4/28/2006 

 

 

 

Tuesday 5/2/2006 7:00pm- 9:00pm  Rm: CS G066

FINAL EXAM