CS 245 DATABASE SYSTEMS PRINCIPLES Winter 2000 INSTRUCTOR: Hector Garcia-Molina Office: Gates 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: Sriram Raghavan Office: Gates 435; Email: rsram@db.stanford.edu Office Hours: Gates 193A (723-6059) : Monday 4:00pm - 5:30pm, Thursday 2:00pm - 3:30pm Phone: 650-725-3359 Orkut Buyukkokten Office: Gates 430; Email: orkut@cs.stanford.edu; Office Hours: Tuesday/Thursday 3:00pm - 5:00pm Phone: 650-723-6805 SECRETARY: Marianne Siroker Office: Gates 436; Email: siroker@cs.stanford.edu Phone: 650-723-0872 LECTURES: Tuesday, Thursday 11:00am to 12:15pm, HP Auditorium (Gates B01) TEXTBOOK: Garcia-Molina, Ullman, Widom; "DATABASE SYSTEM IMPLEMENTATION" 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.stanford.edu/class/cs245 Plase check it periodically for last minute announcements. TENTATIVE SYLLABUS DATE CHAPTER TOPIC Tuesday January 4 Introduction Thursday January 6 Ch. 2 Hardware Tuesday January 11 Ch. 3 File and System Structure Thursday January 13 Ch. 3 File and System Structure Tuesday January 18 Ch. 4 Indexing and Hashing Thursday January 20 Ch. 4 Indexing and Hashing Tuesday January 25 Ch. 5 Indexing and Hashing Thursday January 27 Ch. 6 Query Processing Tuesday February 1 Ch. 6 Query Processing Thursday February 3 Ch. 7 Query Processing Tuesday February 8 Midterm Thursday February 10 Ch. 8 Crash Recovery Tuesday February 15 Ch. 8 Crash Recovery Thursday February 17 Ch. 9 Concurrency Control Tuesday February 22 Ch. 9 Concurrency Control Thursday February 24 Ch. 9 Concurrency Control Tuesday February 29 Ch. 10 Transaction Processing Thursday March 2 Ch. 10 Transaction Processing Tuesday March 7 Ch. 11 Information Integration Thursday March 9 Review