CMPUT 692: Modern Database Management Systems

Winter Term, 2003
Professor Li-Yan Yuan

Purpose:
This course covers research topics in advanced database management systems as well as emerging database techonologies, with ephasise on XML data and XML support for object-oriented database management systems.

The course is intended to provide students enough background in modern database management systems to enable them to understand the current research in the field, and to give each student an opportunity to participate some research projects and class presentation.

Prerequisites: CMPUT 391 or consent of the Department

Course Outline:

introduction to emerging database technologies
XML data and information retrivial
XML support of object-relational database systems
transaction management and concurrency control
multimedia support for database systems
LogicSQL: an object-relational database system

Course Project

There is one term project, involving research and developement of XML support for LogicSQL and/or other object relational database systems.

Students who choose to develop an experimental system may form a group of up to three students for the term project. Of course, all students in the group will get the same mark.
Students who choose to write a theoretical research report must complete the project individually.

Grading Policy

final examination (take home) 50%

course presentation 5%

term project 45%

Policy on Collaboration on Project and Examination

The University's policy on academic dishonesty will be strictly followed. DO collaborate and explain to others if necessary to help other students learn, but DO NOT GIVE machine-readable contents of your programs, or listings of any parts of the examination answers to others so they can merely copy. See http://www.ualberta.ca/~unisecr/chtsheet.html for details.

Tentative Lecture Schedule:

Month Dates Lecture Topics
Jan. 7 Object-Relational Database System
9, 14 OLAP and Data Mining
16, 21 XML Data
23, 28 XQuery Language
Feb. 4, 6, 11 XML and Relational databases
13 Normal Form for XML data
17-21 Reading week
25, 27 Long Durational Transaction
Web-based Database application
March 4. 6, 11, 13 LogicSQL and Its Concurrency Control Protocol
18, 20, 25 Multimedia Database Support

April 27
1, 3, 8 Student Presentation and Demo

Li-Yan Yuan 2003-01-06

final examination (take home)	50%
course presentation	5%
term project	45%

Month	Dates	Lecture Topics
Jan.	7	Object-Relational Database System
	9, 14	OLAP and Data Mining
	16, 21	XML Data
	23, 28	XQuery Language
Feb.	4, 6, 11	XML and Relational databases
	13	Normal Form for XML data
	17-21	Reading week
	25, 27	Long Durational Transaction Web-based Database application
March	4. 6, 11, 13	LogicSQL and Its Concurrency Control Protocol
	18, 20, 25	Multimedia Database Support
April	27 1, 3, 8	Student Presentation and Demo