 |
CMPT 454 E1 Database Systems II |
News:
Back to Top
03/12/09 - exam office hours on Wednesday, December 9, from 5:30 to 7:30 pm in room TASC1 9231 (Burnaby campus)
05/11/09 - no class next Wednesday, November 11 (Rememberance Day)
01/10/09 - assignment submission mode changed from electronic to hard copy
14/09/09 - new class room HC 2270
08/09/09 - course website goes live
05/11/09 - no class next Wednesday, November 11 (Rememberance Day)
01/10/09 - assignment submission mode changed from electronic to hard copy
14/09/09 - new class room HC 2270
08/09/09 - course website goes live
Back to Top
Course Information:
Back to Top
Classroom: HC 2270
Lecture: Wednesday 5:30 - 8:20 pm
Course Textbook: Database Systems - The Complete Book by Garcia-Molina, Ullman and Widom, Prentice Hall, 2rd edition, 2008.
Online material provided by the authors
Solutions for the odd-numbered chapter exercises of the Ramkrishnan/Gehre book
Lecture: Wednesday 5:30 - 8:20 pm
|
Instructor: Email: Office: Office Hours: |
Martin Ester ester@cs.sfu.ca HCC 2270 Wednesday, 8:30 pm |
TA: Email: Office: Office Hours: |
Yi Liu yliu1@fas.sfu.ca by email N/A |
Course Textbook: Database Systems - The Complete Book by Garcia-Molina, Ullman and Widom, Prentice Hall, 2rd edition, 2008.
Online material provided by the authors
Solutions for the odd-numbered chapter exercises of the Ramkrishnan/Gehre book
Back to Top
Tentative Schedule:
Back to Top
Week of Sept 7 Sept 14 Sept 21 Sept 28 Oct 5 Oct 12 Oct 19 Oct 26 Nov 2 Nov 9 Nov 16 Nov 23 Nov 30 Dec 14 |
Lectures (sections of the textbook) Introduction / Secondary Storage (13.1 - 13.2) Secondary Storage / File Organization (13.3 - 13.5) File Organization / Indexing (13.6 - 13.8) Indexing (14.1 - 14.2) Indexing (14.2 - 14.3) Query optimization (16.1 - 16.3) Review for the midterm / Query optimization (16.4 - 16.5) Midterm exam (Wednesday, October 28) / Query optimization (15.1 - 15.2) Query optimization (15.3 - 15.6) Coping with system failures (17.1 - 17.5) Concurrency Control (18.1 - 18.3) Concurrency Control (18.4 - 18.7 and 18.9) Data Mining (22.1 - 22.2) Final exam on Wednesday, December 16, 7:00 - 10:00 pm |
Back to Top
Assignments:
Back to Top
Solutions to be submitted to the Online Submission Server. Deadline for the assignments is Wednesday before class, i.e. 5:30 pm.
Assignment 1, assigned September, 17 and due September, 30
Solution Assignment 1
Assignment 2, assigned October,1 and due October, 14
Solution Assignment 2
Assignment 3, assigned October,17 and due October, 28
Solution Assignment 3
Assignment 4, assigned November,6 and due November, 18
Solution Assignment 4
Assignment 5, assigned November,19 and due December, 2
Solution Assignment 5
* All assignments are due at the start of class on the day indicated. Late assignments will not be accepted unless there is a documented medical reason. There will be no makeup midterm or final exams. If you are unable to write the midterm or final, please contact the instructor before the exam.
* Grading scheme: Assignments 40%, Midterm exam 15%, Final exam 45%.
* Students must attain an overall passing grade on the weighted average of exams in the course in order to obtain a clear pass (C or better).
Assignment 1, assigned September, 17 and due September, 30
Solution Assignment 1
Assignment 2, assigned October,1 and due October, 14
Solution Assignment 2
Assignment 3, assigned October,17 and due October, 28
Solution Assignment 3
Assignment 4, assigned November,6 and due November, 18
Solution Assignment 4
Assignment 5, assigned November,19 and due December, 2
Solution Assignment 5
* All assignments are due at the start of class on the day indicated. Late assignments will not be accepted unless there is a documented medical reason. There will be no makeup midterm or final exams. If you are unable to write the midterm or final, please contact the instructor before the exam.
* Grading scheme: Assignments 40%, Midterm exam 15%, Final exam 45%.
* Students must attain an overall passing grade on the weighted average of exams in the course in order to obtain a clear pass (C or better).
Back to Top