Advanced Database Systems

Course Objectives

At the end of the course, students will

• have an in-depth understanding and implementation of concurrency control, transaction management, and database security,
• be introduced to object-oriented and object-relational database design,
• learn query optimization, and
• be introduced to database security and authorization.

Course Description

This course is a continuation of the course “Fundamentals of Database Management Systems”. It extends the knowledge in the previous course by adding concepts of advanced issues in database management systems. Topics to be covered include: concepts of object-0riented databases; object relational and extended relational databases; query processing and optimization; transaction processing concepts; database recovery techniques; database security and authorization.

Course Content

1. Concepts of Object-Oriented Databases
2. Object database standard and languages and design
3. Object relational and extended relational databases
4. Query processing and optimization
5. Transaction Processing Concepts
6. Database Recovery Techniques

7.         Database Security and Authorization