Welcome to the Database Management Systems course, COSC-4411, for winter term 2003. Materials, instructions, and notices for the course will accumulate here over the semester.

• Check grades and grade break-down via courseInfo.

  % courseInfo 4411 2003-04 W

• Final Exam Preparation Guide.

• Midterm #2 with answers is up: PS, PDF.

• Syllabus
• Class news group: york.cs.course.4411
• Lecture Notes
  • The Physical Database
    • Overview of Storage and Indexing, Chapter 8 R&G textbook slides:
      PS, 6-per PS, PDF, 6-per PDF
    • Storing Data: Disks and Files, Chapter 9 R&G textbook slides:
      PS, 6-per PS, PDF, 6-per PDF
    • Tree Indexes, Chapter 10 R&G textbook slides:
      PS, 6-per PS, PDF, 6-per PDF
    • Hash-based Indexes, Chapter 11 R&G textbook slides:
      PS, 6-per PS, PDF, 6-per PDF

• Assignments
  1. One: PS, PDF
     Due Friday 30 January 2004
     With answers: PS, PDF
• Projects
  1. Buffer Pool Manager (in Java Minibase)
  2. Sort-Merge Join (in Java Minibase)
• Tests
  1. Midterm #1
     • Preparation Guide
     • The test w/ answers: PS, PDF.
  2. Midterm #2
     • Preparation Guide
     • The test w/ answers: PS, PDF.
  3. Final Exam
     • Date & Time: 19:00-22:00 Wednesday 14 April 2004
     • Location: CB 121
     • Preparation Guide

• For the textbook
  • On-line support materials by Raghu Ramakrishnan and Johannes Gehrke.
    Includes:
    • Lecture Notes at Wisconsin
    • Answers to the odd-numbered exercises in the book.