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.
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.