Architecture of Database Systems
Course #: CS 634
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.
Pre Requisites: Pre-req = CS 430 or 630
Offered in:
2026 Fall
| Section | Class Number | Schedule/Time | Instructor | Location | |
|---|---|---|---|---|---|
| 01 | 12722 | TuTh 2:00 - 3:15 pm |
Papon,Md Tarikul Islam | Wheatley-Peters W02-0125 | |
|
Session:
Regular
Class Dates:
09/08/2026 - 12/11/2026
Capacity:
24
Enrolled:
5
Status:
Open
Credits:
3/3
Class Notes:
Pre Requisites:
Pre-req = CS 430 or 630
Course Attributes:
|
|||||