UMass Boston

University Hall viewed from front at night with students visible through floor-to-ceiling windows.
Architecture of Database Systems

Course Overview

Date / Time Location Credits Minimium Tuition*
9/8/26 - 12/11/26
TuTh 2p.m. – 3:15p.m.		 Wheatley-Peters W02-0125 3 $2722 (guest students)
Date
9/8/26 - 12/11/26
Time
TuTh 2p.m. – 3:15p.m.
Location
Wheatley-Peters W02-0125
Credits
3
Min. Tuition*
$2722 (guest students)

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.

Prerequisites

CS 430 or 630

This course is closed for registration.

Return to Course List

Course Details

Session

Regular Academic Session

Class Dates

9/8/2026 - 12/11/2026

Location

Wheatley-Peters W02-0125

Enrolled / Capacity

11 / 24

Status

Closed

Tuition*

* The tuition estimate is based on minimum, single-course cost to a new student who is a Massachusetts resident and not enrolled in a multi-course program. State residency, online/in person modality, and matriculation to a degree program may affect cost.

Tuition Details