COM 1317 Transaction Processing Systems

Course Description and Catalog Information
Course Information (links to past and current course materials)
Course Format
Course Coordinator
Textbooks and References
Course Goals
Prerequisites by Topic
Major Topics Covered in Course
Laboratory Projects

Course Description

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.

Course Information

Course is offered only during the Spring quarter. CS majors are guaranteed a place in class.

Course Format

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.

Course Coordinator

Professor Raoul Smith and Robert Futrelle and

Textbooks and References

Spring 2000
  • J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques, Morgan Kaufman, 1993 (latest edition and printing).

  • Course Goals

    Prerequisites by Topic

    Algorithms and data structures
    Computer organization and programming
    Data bases

    Major Topics Covered in the Course

    Laboratory projects