Course Catalog

GRAD > CS > 634

Architecture of Database Systems

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.

Offered in:

2016 Spring

Section Class Number Weekly Schedule Time Instructor Location
01 7048 MW 07:00 PM - 08:15 PM O'Neil,Elizabeth J M02-0207 More Info