[Announcements] [Lectures] [Syllabus] [Tutorials]

General Information

Professor: Iluju Kiringa (kiringa@site.uottawa.ca)

Office Hours: Wednesday 12:00-1:00PM (Increased on rush days) SITE 5072

Lectures:
Wednesday 10:00-11:30AM in MRN 226
Friday 8:30-10:00AM in MRN 226

Tutorials: Friday 10:00-11:30AM in CBY B202

Labs: Tuesday 8:30-10:00AM in STE2052

TA: Ruiwen Chen

Overview

Topics: Advanced physical database design. Access right, privacy and security. Query processing and optimization. Transaction processing, concurrency control and recovery. Object-oriented databases. Distributed and multi-databases. Data warehousing. Data integration. Design and implementation of a database component in a team project.

Prerequisites: CSI2132 or CSI2230

Text book: R. Ramakrishnan and J. Gehrke, Database Management Systems. 3rd Ed., McGraw Hill, 2003.

Software: PostgreSQL; PGADMIN