CMPT 415 Outline

COURSE NUMBER:

CMPT 415

COURSE TITLE:

Advanced Database Management Systems

NAME OF INSTRUCTOR:

Dr. Joe Hoffert

CREDIT WEIGHT AND WEEKLY TIME DISTRIBUTION:

credits 3(hrs lect 3 - hrs sem 0 - hrs lab 3)

COURSE DESCRIPTION:

The objective of this course is to introduce advanced data management concepts. The course builds on students' previous introduction to database design and application of the relational database. Students will probe into the implementation details of DBMSs and learn the trade-offs between various approaches as well as the contexts that make one approach more appropriate than another. Students will receive hands-on experience of advanced data management concepts via a semester-long project. Students will also be challenged to consider how living in an information and data-centric culture aligns with the Chrisian perspective of all things glorifying the Triune God.

Prerequisites: CMPT 310

REQUIRED TEXTS:

Silberschatz, A., Korth, H., and Sudarshan, S. (2011). Database System Concepts (6th edition). New York, NY: McGraw Hill Publishing

MARK DISTRIBUTION IN PERCENT:


Quizzes	10%
Participation	10%
Midterm Exam	20%
Final Exam	25%
Course Project	35%
	100%

COURSE OBJECTIVES:

The course is designed to introduce students to architecture, design, and implementation concerns for database management systems in general and relational database management systems in particular including:

Data storage;
Transaction management;
System architecture;
Data warehousing and mining;
Specialty databases; and
The relevance of managing data and information within a Christian perspective

COURSE OUTLINE:

Storage and File Structure
Indexing and Hashing
Query Processing
Query Optimization
Transactions
Concurrency Control
Recovery System
Database System Architectures
Parallel Databases
Distributed Databases
Data Analysis and Mining
Object-Based Databases
Advanced Application Development

Required texts, assignments, and grade distributions may vary from one offering of this course to the next. Please consult the course instructor for up to date details.