|
COSC-4411(A)
Database Management Systems
York University
Fall 2004
|
|
Class Homepage
|
|
|
|
Instructor:
|
Parke Godfrey
|
|
Office:
|
#2050 CSB
|
|
Office Hours:
|
We 2:00-4:30pm
|
|
& by appointment
|
|
Ph#:
|
416-736-2100 x66671
|
|
e-mail:
|
godfrey@cs.yorku.ca
|
|
|
|
|
Term:
|
Fall 2004
|
|
Time:
|
Tu&Th 5:30-7:00pm
|
|
Place:
|
FS #109
|
|
|
|
|
COSC-4411
|
|
Welcome
to the Database Management Systems
course, COSC-4411,
for fall term 2003.
Materials, instructions, and notices
for the course will accumulate here over the semester.
|
|
Class Bulletin Board
|
Unofficial grades (and component scores) available via
- % courseInfo 4411 2004-05 F
The final exam approaches.
- Date & Time: 19:00-22:00 Wednesday 8 December 2004
- Location: CLH M
Final Exam Preparation Guide.
Some folks have requested more time for project #2.
You can submit it late up to 11:59pm Friday 10 December,
with a 20% penalty.
To submit late, say
- % submit 4411 mj-late dir
where dir is the directory in which you have your code.
To submit your project #2, say
- % submit 4411 mj dir
where dir is the directory in which you have your code.
|
|
Materials
|
|
-
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
- External Sorting,
Chapter 13 R&G textbook slides:
PS,
6-per PS
- Query Evaluation
- Overview of Query Evaluation,
Chapter 12 R&G textbook slides:
PS,
6-per PS
- Evaluation of Relational Operators: Joins,
Chapter 14-A R&G textbook slides:
PS,
6-per PS
- Evaluation of Relational Operators: ,
Chapter 14-B R&G textbook slides:
PS,
6-per PS
- Relational Query Optimization,
Chapter 15 R&G textbook slides:
[PS],
[6-per PS]
Strategies for an Optimizer:
[PS],
[4-per PS],
PDF,
[4-per PDF]
|
|
Projects, Assignments, & Exams
|
|
The Final Exam
|
|
Useful On-line Information
|
|
|
|
|
|
Parke Godfrey
|
|
|