CS 245 DATABASE SYSTEMS PRINCIPLES Summer 2000 INSTRUCTOR: Neal Sample Office: Gates 424 Email: nsample@db.stanford.edu Office Hours: Gates 424, Monday & Wednesday, 11:00am - 12:00pm Phone: 650-723-1963 Hector Garcia-Molina (BTVI Instruction) TEACHING ASSISTANT: Shanchi Zhan Office: Gates 193B Email: szhan@stanford.edu Office Hours: Gates 193B, Tuesday, 10:00am - 12:00pm SECRETARY: Marianne Siroker Office: Gates 436; Email: siroker@cs.stanford.edu Phone: 650-723-0872 LECTURES: Monday, Wednesday 9:15am to 10:45am, Gates B03 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-db.stanford.edu/~nsample/cs245 Plase check it periodically for last minute announcements. TENTATIVE SYLLABUS DATE CHAPTER TOPIC 1. Wednesday June 21 Introduction 2. Monday June 26 Ch. 2 Hardware 3. Wednesday June 28 Ch. 3 File and System Structure 4. *Monday July 3 Ch. 3 File and System Structure 5. Wednesday July 5 Ch. 4 Indexing and Hashing 6. Monday July 10 Ch. 4 Indexing and Hashing 7. Wednesday July 12 Ch. 5 Indexing and Hashing 8. Monday July 17 Ch. 6 Query Processing 9. Wednesday July 19 Ch. 6 Query Processing 10. Monday July 24 Ch. 7 Query Processing 11. Wednesday July 26 Midterm 12. Monday July 31 Ch. 8 Crash Recovery 13. Wednesday August 2 Ch. 8 Crash Recovery 14. Monday August 7 Ch. 9 Concurrency Control 15. Wednesday August 9 Ch. 9 Concurrency Control 16. Monday August 14 Ch. 9 Concurrency Control 17. Wednesday August 16 Ch. 10 Transaction Processing 18. Monday August 21 Ch. 10 Transaction Processing 19. Wednesday August 23 Ch. 11 Information Integration 20. Monday August 28 Final, Gates B03, 9:00-12:00