CPSC 404 101 2023W
Instructor(s)
Extended Description
This course continues with database topics beyond CPSC 304. Whereas CPSC 304 focuses on using a relational database management system (RDBMS), CPSC 404 focuses on the internals and performance issues of an RDBMS. Topics include disks and the storage hierarchy, the I/O cost model, buffer pool management, disk scheduling, record layouts, metadata, system catalogs, tree-structured indexes, hash indexes, query evaluation, query optimization, transaction processing, concurrency, and crash recovery. Note that some of these important topics also have applicability to areas outside of database systems.