This module provides an in-depth study of the concepts and implementation issues related to database management systems. The first part covers the physical implementation of relational data model, which includes storage management, access methods, query processing, and optimization. The second part covers issues and techniques dealing with multi-user application environments, namely, transactions, concurrency control and recovery.

A key component of the module is the system-oriented project where students will work on developing components of a Java-based DBMS engine.

Learning Outcomes

At the end of the module, students will understand the algorithmic and systems aspects of a database management systems. They will be equipped with sufficient knowledge for them to implement their own database management systems.