CS 245  DATABASE SYSTEMS PRINCIPLES              Winter 1999
 
INSTRUCTOR:
Hector Garcia-Molina  Office: Gates Hall 434  Email: hector@cs.stanford.edu
Office Hours: Tuesdays, Thursdays 10 - 11am
(Try to make an appointment with Marianne Siroker to ensure I can see you.)
 
TEACHING ASSISTANTS:
Neil Daswani  Office: Gates Hall 496;  Email: daswani@cs.stanford.edu
Office Hours: Monday 8:00pm - 9:00pm; Wednesday: 11:00am - 12:00noon   (Gates 496) 
Phone: 650-725-7359 (office)

Junghoo Cho
Office: Gates Hall 193A;  Email:  cho@db.stanford.edu;  
Office Hours: Tuesday: 1:00-2:00PM; Thursday: 1:00-2:00PM  (Gates 193A)
Phone: 650-723-6059

SECRETARY:
Marianne Siroker   Office: Gates Hall 436;   Email: siroker@cs.stanford.edu
Phone: 650-723-0872
 
LECTURES:  Tuesday, Thursday 11:00am to 12:15pm, HP Auditorium (Gates B1)
 
TEXTBOOK:  Garcia-Molina, Ullman, Widom; "DATABASE SYSTEM IMPLEMENTATION"
A draft of this new book is available as a course reader at the bookstore.

ASSIGNMENTS:  Seven written homework assignments. No programming. 
Also readings in Textbook.
 
GRADING:  Homeworks: 20%, Midterm: 30%, Final: 50%.

WEB SITE:  All handouts and assignments will be posted on our Web site at:
        http://www-leland.stanford.edu/class/cs245
Plase check it periodically for last minute announcements.

TENTATIVE SYLLABUS
 
DATE                    CHAPTER         TOPIC
Tuesday January 5                       Introduction
Thursday January 7      Ch. 2           Hardware
Tuesday January 12      Ch. 3           File and System Structure
Thursday January 14     Ch. 3           File and System Structure
Tuesday January 19      Ch. 4           Indexing and Hashing
Thursday January 21     Ch. 4           Indexing and Hashing
Tuesday January 26      Ch. 5           Indexing and Hashing
Thursday January 28     Ch. 6           Query Processing
Tuesday February 2      Ch. 6           Query Processing
Thursday February 4     Ch. 7           Query Processing
Tuesday February 9                      Midterm
Thursday February 11    Ch. 8           Crash Recovery
Tuesday February 16     Ch. 8           Crash Recovery
Thursday February 18    Ch. 9           Concurrency Control
Tuesday February 23     Ch. 9           Concurrency Control
Thursday February 25    Ch. 9           Concurrency Control
Tuesday March 2         Ch. 10          Transaction Processing
Thursday March 4        Ch. 10          Transaction Processing
Tuesday March 9         Ch. 11          Information Integration
Thursday March 11                       Review