CSCD 43 -- Database Systems Technology

Fall 2015


Index of this document


Contact information and meeting times

Instructor:  Nick Koudas
Office hours: Wednesday 6pm-7pm 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:  Priyank Gupta
Office hours:  TBD

Lecture time and location:  Wednesday 7pm - 9pm IC 120

Tutorial times and locations:  Thursday 2pm-3pm AA206

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 NoSQL data architectures (Spark, Hadoop, column stores).

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 9
First day of class /  Project  0
Sept 16
Project 1 handed out
Sept 30
Project 2 handed out
Oct 8
Project 1 due
Nov 5
Project 2 due at tutorial
Oct 28
Midterm in class 1 hour  duration / project 3 out
Nov 18
Last day to drop course
Nov 25
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 so 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/courses/cscd43f15/koudasni. This directory is readable but you have to spacify the entire path to list the contents. You can also you cd cscd43f15_space from your home directory to list the contents and get all course related material.


    Back to the index

    Old exams

    There are no available old exams and/or homeworks.

    Back to the index