========================================================================== CSI3130 -- Databases II Iluju Kiringa ++1-613-5625800x2164 kiringa@site.uottawa.ca --------------------------------------------------------------------------- General Information Professor: Iluju Kiringa (kiringa@eecs.uottawa.ca) Office Hours: Thursday 12:00PM-1:30PM. Lectures: Wednesday 16:00-17:30 Montpetit 201 Friday 14:30-16:00 Montpetit 201 Tutorials and labs: Check your course schedule TA: Sachin Arora (saror061@uottawa.ca); Parvaneh Pouladzadeh (ppoul017@uottawa.ca); Germanjit Singh Randhawa (grand018@uottawa.ca) --------------------------------------------------------------------------- Announcements Watch the announcements on the web for homeworks, due dates for assignments, exam dates and locations, and the like. Overview External sorting. Query processing and optimization. Transaction processing, concurrency control and recovery. Distributed databases. Data integration (Data warehousing). Design and implementation of a database component in a team project. Prerequisites Database I --------------------------------------------------------------------------- Course Outline and Schedule Overview of File Structures -- Chap 8 External Sort -- Chap 13 Evaluation of Relational Operators (Joins) -- Chap 14, 14.4 Evaluation of Relational Operators (Other Operators) -- Chap 14 Sample Query Optimizer: System R -- Chap 15 Transaction Processing (RG Chap 16; Sections of Chap 17,18): Overview -- Chap 16 Concurrency Control -- Chap 17 Recovery -- Chap 18 Distributed Databases (RG Chap 16; Sections of Chap 22, 22.6-22.14) Data Warehousing (RG Chap 25, 25.1-25.7) Data Warehousing (RG Chap 25, 25.8-25.10) Text book (required): Raghu Ramakrishnan and Johannes, Database Management Systems. 3rd Edition, McGraw Hill, 2003. Recommended: Brian W. Kernighan and Dennis M. Ritchie, The C Programming Language. Second Edition. Prentice Hall, 1988. --------------------------------------------------------------------------- Coursework and Marking Scheme The final grade for this course will be made of 15% for assignments, 25% for the project, 20% for the mid-term, and 40% for the final exam. To pass the course, you must obtain at least 50% on the exams (i.e., midterm + final). Submission instructions will be included in the assignment handouts. Do expect to have one assignment per month for the next 3 months. Late assignments will not be accepted more than 72 hours after deadlines. Only under very exceptional circumstances will I accept assignments more than 72 hours after deadlines. To submit an late assignment, do so in the usual way and then send me an e-mail message or bring me a written justification. Late assignments will be penalized. Assignments returned in class or in tutorials. Any remarking request must be submitted to the TA within one week. Plagiarism is considered very serious offense by all universities, including U of O, and I will treat it consequently. --------------------------------------------------------------------------- Contacting the professor When emailing me, please state clearly your full name in the body of the message, and also put "CSI 3130" in the title. This is VERY IMPORTANT if you want a reasonably quick answer from me.