CSC627 Advanced Database Systems

[3–0, 3 cr.]

This course examines advanced concepts in the design, implementation, performance, and operation of modern database systems. Topics include database storage engines, buffer management, indexing structures, query processing and execution, cost-based optimization, materialized views, parallel and distributed query processing, replication, partitioning and sharding, distributed databases, consistency models, database recovery and logging, distributed transactions, and database performance engineering. The course also explores modern database architectures, including NewSQL systems, HTAP systems, and specialized databases. Students gain practical experience analyzing database workloads, designing physical database architectures, benchmarking systems, and optimizing database applications.