COM 1317 Transaction Processing Systems

Course Format
Course Coordinator
Textbooks and References

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

• Spring 2001

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
rnsmith@ccs.neu.edu and futrelle@ccs.neu.edu

Textbooks and References

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

Course Goals

This is a course in online transaction processing. Its purpose is for students to learn some of the basic os OLTP including recvery, concurrency, resource managers such as the Log and Lock Managers, TP monitors, etc.

Prerequisites by Topic

Algorithms and data structures
Computer organization and programming
Data bases

Major Topics Covered in the Course

• Generic architecture. Fault tolerance
• Concurrency control: Isolation concepts and the Lock Manager
• Lock implementation
• Recovery, including the Log manager
• Transaction Manager concept
• Transaction Manager structure
• Transaction Monitors
• Optimization in distributed data bases
• Multi-dimensional data bases

Laboratory projects

n. a.