HomeAcademicsCourses → CS634

Architecture of Database Systems (3 credits)

Indexing, and query optimization in database systems. Writing programs to update a database. ACID properties. Concurrency theory: serializability, two-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.


CS430 or CS630 or permission of instructor.


Fall 2012 Course Website

This page was last modified on August 15, 2012
© 2012 University of Massachusetts Boston

Template by OS Templates