Architecture of Database Systems
Course #: CS 634, Class #: 12722, Section #: 01
Description
Indexing and query optimization in database systems. Writing programs to update a database. ACID properties. Concurrency theory: serializability, 2-phase locking, deadlock detection. Transactional Recovery: REDO and UNDO logging, different checkpoint approaches, media recovery. Examples of recovery utility use in INGRES, ORACLE and DB2. Transactional performance: the TPC-A benchmark, analysis of bottlenecks, and cost-performance considerations. Distributed database systems. Two-phase commit. Database parallelism.
Prerequisites
CS 430 or 630
Course Details
Date / Time
9/8/26 - 12/11/26
TuTh 2p.m. – 3:15p.m.
Location
Wheatley-Peters W02-0125
Credits
3
Session
Regular Academic Session
Class Dates
9/8/2026 - 12/11/2026
Location
Wheatley-Peters W02-0125
Enrolled / Capacity
9 / 24
Status
Closed