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.

Course Info
Section
101
Term
Term 1
Session
2021W
Dates
Days
Thu
Time (start)
3:30 PM
Time (end)
5:00 PM
Date (start)
Date (end)
Location
Building
DMP
Room
310