========================================================================== CSI3130 -- Databases II Iluju Kiringa +16135625800 x 2123 kiringa@eecs.uottawa.ca --------------------------------------------------------------------------- General Information Professor: Iluju Kiringa (kiringa@eecs.uottawa.ca) Office Hours: (Tentatively: Thursday 12:00PM-1:30PM) --------------------------------------------------------------------------- Lectures, labs, and tutorials: Section Days & Times Room A00-LEC We 16:00 - 17:20 800 King Edward (STE) A0150 Fr 14:30 - 15:50 800 King Edward (STE) A0150 A01-LAB Th 11:30 - 12:50 800 King Edward (STE) 2060 A02-LAB Mo 17:30 - 18:50 800 King Edward (STE) 0131 A03-LAB Th 10:00 - 11:2 800 King Edward (STE) 2060 A04-TUT Tu 16:00 - 17:20 65 University (MRT) 256 --------------------------------------------------------------------------- Assignment 1: Query processing (Marker: TBD) Assignment 2: Transaction processing (Marker: TBD) Assignment 3: Parallel and distributed databases (Marker: TBD) --------------------------------------------------------------------------- Announcements For homeworks, due dates for assignments, exam dates, and the like, watch the announcements on the web at the following link: https://www.eecs.uottawa.ca/~kiringa/courses22/csi3130/csi3130.html --------------------------------------------------------------------------- Overview Query processing and optimization. Transaction processing, concurrency control and recovery. Distributed and parallel databases. BigData. Design and implementation of a database system component in a team project. --------------------------------------------------------------------------- Prerequisites Database I --------------------------------------------------------------------------- Course Outline Query Processing -- Chap 15 Query Opimization -- Chap 16 Transactions -- Chap 17 Concurrency Control -- Chap 18 Recovery System -- Chap 19 Distributed and Parrallel Database System Architectures -- Chap 20 Parallel and Distributed Storage -- Chap 21 Parallel and Distributed Query Processing -- Chap 22 Parallel and Distributed Transaction Processing -- Chap 23 ---------------- Time Permiting: --------------------- Big Data -- Chap 10 Data Analytics -- Chap 11 Advanced Indexing Techniques -- Chap 24 --------------------------------------------------------------------------- Text book and web platform: Required: Abraham Silberschatz, Henry F. Korth, S. Sudarshan, Database System Concepts. 7th Edition, McGraw Hill, 2020. 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 3 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. My midterms are always held in the first class after the reading week, unless otherweise stated in class. 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 send me a written justification. Late assignments will be penalized. 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.