CS 631 - Implementation Techniques for Relational Database Systems

Course content
  • Physical storage and indexing structures, Query processing algorithms, Query optimization, Transaction processing and serializability, Concurrency Control, Recovery.
  • Big data management: transaction and query processing on parallel and distributed databases including issues of availability, replication, consistency, concurrency control, and recovery. Emerging database trends.
References
  • Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts 6th Ed, McGraw Hill, 2010
  • Transaction Processing, Concepts and Techniques, J. Gray and A. Reuter, Morgan Kauffman, 1994.
  • Research papers from leading conferences
Pre-requisite : Must have done a basic course in databases either as part of curriculum or online, which covers relational databases, SQL, functional dependencies and normalization at a minimum, and read up on other material on your own.
Total credits : 6
Type :
Duration : Autumn 2022
Name(s) of other Academic units to whom the course may be relevant : N/A