Course FormatCourse Goals
Textbooks and References
Prerequisites by Topic
Major Topics Covered in Course
Focuses on the concepts and practice of modern transaction processing systems in a distributed setting. Describes the overall architecture of systems such as TP monitor, recovery manager, log manager, and lock manager. Discusses the principles of DO/UNDO/REDO logging such as the write-ahead log rule and the force log-on-commit rule. Describes compensation log records, checkpoint and restart recovery procedures, two-phase commit, lock tables, granularity of locking, and two-phase locking.
4 QH credit
Prerequisite: COM 1201, COM 1130, COM 1315.
BSCS03 Database track
BSCS04 elective course
BACS elective course
BSIS general elective
This is a Database track course for BS CS majors graduating in the years 2003 and before. It is a CS elective for BS CS majors graduating in the years 2004 and beyond.
Professor Raoul Smith and Robert Futrelle
firstname.lastname@example.org and email@example.com
J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques, Morgan Kaufman, 1993 (latest edition and printing).
Algorithms and data structures
Computer organization and programming