Office Hours: Thursday 5:00-6:30PM (Increased on rush days) SITE 5072
Lectures:
Wednesday 16:00-17:30 Montpetit 201
Friday 14:30-16:00 Montpetit 201
Tutorials and labs: Check your schedule
TAs: Sachin Arora (saror061@uottawa.ca); Parvaneh Pouladzadeh (ppoul017@uottawa.ca); Germanjit Singh Randhawa (grand018@uottawa.ca)
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