Course Catalog

all > GRAD > CS

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.

Pre Requisites: Pre-req = CS 430 or 630

Offered in:

2018 Spring

Section Class Number Schedule/Time Instructor Location
01 11050 MW
5:30 - 6:45 pm
O'Neil,Elizabeth J M03-0204
Session: Regular
Class Dates: 01/22/2018 - 05/09/2018
Capacity: 35
Enrolled: 23
Status: Open
Credits: 3/3
Class Notes:
Pre Requisites: Pre-req = CS 430 or 630
Course Attributes: