University of Alberta - Department of Computing Science

CMPUT 391: Database Management Systems
Fall 2001

CMPUT 391: Database Management Systems
Instructor: Osmar R. Zaiane (zaiane@cs.ualberta.ca)
Course Home Page: http://www.cs.ualberta.ca/~zaiane/courses/cmput391/

OBJECTIVE/DESCRIPTION:

Expertise and skills in web technologis are very sought for in This is a second course in our two-course serial on the database management systems. The first course (CMPUT291) introduces the basic concepts and elements of file and database systems with enphasis on the entity-relationship model and SQL query language. The second course covers advanced aspects of database management systems including concurrency control, query optimization, security issues, data mining, etc.
By the end of the course, students are expected to understand the basic concepts in all these advanced database topics, as well as get some practical hands-on experience with ORACLE through a small term project to design and implement a web-based database application.

TOPICS:

The course will cover the following topics:
  1. Physical Database design
  2. Query processing and optimization
  3. Concurrency control
  4. Database recovery
  5. Security and access control
  6. Object-Oriented databases
  7. Parallel and Distruibuted databases
  8. Data warehousing
  9. Data mining
  10. Querying XML repositories

GRADING: subject to change

Homeworks (5 assignments) (16%), Midterm exam (19%), Project (35%), Final (30%)

Final grades will be assigned in a way that the grade histogram approximates (as long as it is feasible) a normal (bell) curve.

TEXTBOOKS and REFERENCES: R. Ramakrishnan and J. Gehrke, Database Management Systems, 2nd Edition, McGraw-Hill

Distributed: April 30, 2000 (Osmar R. Zaiane)