Offered: Fall 2025 (current)
This course provides an extensive study of advanced database systems, covering foundational and modern concepts. Topics include an introduction to databases and their historical evolution, online analytical processing (OLAP), and online transaction processing (OLTP). It explores indexing techniques, query compilation and execution, query optimization strategies, and data compression methods. The course also addresses concurrency control, storage models, data layout structures, and system catalogs. Additional focus areas include in-memory databases, data recovery protocols, and the architecture and implementation of distributed database systems.
The core objectives of this course are:
To introduce students to advanced database concepts and their applications.
To explore the design and implementation of efficient query processing and optimization techniques.
To understand indexing methods, concurrency control, and data storage strategies.
To study modern developments in database systems, including in-memory databases and distributed databases.
To analyze recovery mechanisms and fault tolerance in database systems.
1. To Be Added
| # | Description | Weight | Edit |
|---|
