Course Title:
Implementation of Database Management Systems
Course Description:
Explores the internals of database management systems. Topics include SQL query optimization in centralized and parallel systems, use of B-tree indexes for efficiency, nested loop, sort/merge and hash-partition, joins, histograms for estimation, and lock and unlock. Introduces recovery, log record structure, log functions, fuzzy checkpointing, buffer manager structure, LRU replacement, FIX rule, WAL rule, and two-phase commit with presumed abort optimization and replication.
Fall Offering:
Lab/Coreq 1:
Spring Offering:
Lab/Coreq 2:
Summer Offering:
Lab/Coreq Remarks:
Summer 1 Offering:
Prerequisite 1:
CS G130
Summer 2 Offering:
Prerequisite 2:
Cross-Listed Course 1:
Prerequisite 3:
Cross-Listed Course 2:
Prerequisite 4:
Cross-Listed Course 3:
Prerequisite 5:
Cross-Listed Course 4:
Prerequisite Remarks:
Cross-Listed Course 5:
Repeatable:
N
