CSCD 43 -- Database Systems Technology

Fall 2011


Index of this document


Contact information and meeting times

Instructor:  Nick Koudas
Office hours: Monday 9-11 at IC468 or by appointment
Office:   IC468 (Scarborough campus);  BA 5240 (St. George campus)
Telephone:  416-287-7253 (Scarborough campus);  416-946-5819 (St. George campus) 
Email:  koudas AT utsc Dot utoronto Dot ca

NOTE: When sending email to the above address, prefix your subject line with CSCD43
Please be precise and brief. I prefer plain text emails. Do not send me pieces of code
asking me what is wrong; please see the TA's.
TAs:  Tomasz Nykiel
Office hours:  Wednesday 1-3pm IC467

Lecture time and location:  Monday 12-2, room IC320 Office hours Monday 09-11 IC468;

Tutorial times and locations:  Monday 11-12 IC326

Back to the index


Course content

Course goals:   The course is an introduction to the technolgy behind database management systems. The topics covered include: storage systems, buffer management, physical database design, indexing and searching in one and more dimensions, query processing, query optimization, transactions management, recovery and if time permits Object Relational Systems and data warehousing.

Required Text:  Ramakrishnan and Gehrke: Database Management Systems, Third Edition, McGraw Hill.

Tentative weekly schedule:  see here

Calendar of important course-related events:



 

Date Event
Sept 12
First day of class /  Project  0
Sept 12
Project 1 handed out
Oct 03
Project 1 due / Project 2 handed out
Oct 31
Project 2 due / Project 3 out
Oct 31
Midterm in class 1 hour  duration
Nov 16
Last day to drop course
Nov 28
Project 3 due
Dec
Final exam


Back to the index


Course policies

Course evaluation:   There will be three regular projects,  a midterm exam and a final exam. The purpose of the projects is to gain hands on experience working with the engine of an open source database management system. We will be using PostgreSQL in this course. You will modify the internals, adding new algorithms and functionality to the data management system. The projects follow closely the topics covered in the course. The relative weights of these components towards the final mark are shown in the table below:

Project 0
1% (this is a bonus to all)
Midterm 25%
Final 40%
Project 1
10%
Project 2
12%
Project 3
12%



Late homework policy:  No late homeworks will be accepted. If you miss an assignment deadline because of a medical or personal emergency, you must fill out the Special Consideration Form. (In case of a medical emergency, you must also submit the UTSC Student Medical Certificate, completed and signed by your physician. The medical certificate should be submitted on the first class you are able to attend after your emergency. Late certificates will not be accepted.) 

Homework  collaboration policy:   For the projects you may, if you wish, form groups of 2 students. Groups are self managed and you are fully responsible for division of labour.

Remarking policy:   If your request concerns a simple addition error, see the instructor.  To make any other kind of remarking request, you must fill this form , attach it to your homework assignment or test, and give it to the instructor of the course no later than one week from the date the marked assignment or test was made available to the class.  Remarking requests made after this deadline will not be accepted.

Missed midterm test policy:    If you miss the midterm test due to a medical or other serious emergency, get in touch with your instructor immediately, and fill out the Special Consideration Form. (In case of a medical emergency, you must also submit the UTSC Student Medical Certificate, completed and signed by your physician.)  There will be no make-up test, but if we consider your reason for missing the test to be valid, we will use your final examination mark to compute your mark for the missed midterm test.

Attendance in tutorials:  Attendance in tutorials is as mandatory as attendance in lectures.  In neither case is formal attendance actually taken. However, there will be material presented only in tutorial and not discussed in the lectures for which you are responsible and in which you may be tested in homeworks or exams.

Back to the index


Announcements

In this space we will post announcements related to the course. Please check this space at least weekly.


Back to the index

Marks

  • Marks fo far

  • Handouts

    In this space we will make available electronic versions of course material.  There will be no electronic version of solutions available on the course web page.
    Tutorial material will not be available in electronic or hardcopy form -- i.e., attendance of tutorials is essential.


    Course related material available at the mathlab under: /courses/webspace/cscd43f11/prof


    Back to the index

    Old exams

    There are no available old exams and/or homeworks.

    Back to the index