May 02, 2024  
2021-2022 Graduate Catalog 
    
  Catalog Home
  Notices & Updates
  About the University
  Accreditation
  Trustees & Administrative Leadership
  Academic Calendar
  Student Rights & Responsibilities
  Academic & Administrative Policies
  Colleges, Schools, & Departments
  Graduate Programs
  Course Descriptions
  Admissions
  Costs, Financial Aid, & Assistantships
  Research Facilities & Services
  Contact Information
  Maps & Directions
HELP
2021-2022 Graduate Catalog [ARCHIVED CATALOG]

CS 634 - Architecture of Database Systems

3 Credit(s) |  |
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.

Enrollment Requirements:
CS 430 or 630

013125:1