Transaction Systems

• Prof. Dr. Thomas Neumann
• Linnea Passing, M.Sc.

Information

Post-exam review

Wednesday, July 20, 12:30pm–2:30pm, seminar room 02.09.014
Students that registered for the exam should have received an e-mail on how to register for the post-exam review.

Content

The course gives a broad and thorough overview of the transaction systems theory. It concentrates on concurrency control and recovery (and their interaction) in database management systems, while also covering other topics (implementational issues, distributed transaction management and recovery etc).

Prerequisites

The course is aimed at Master-level students who have already taken the following (or similar) courses:

• Foundations of Computer Science
• Introduction to Databases

In particular, we assume that students already have basic knowledge about transaction processing in DBMS.

Organization

• First lecture: Monday, April 18, 2016
• Lecture + Exercise Sessions: 9am-12pm
• Room: 02.09.014 (Seminar room)
• Bonus: 75% required for the 0.3 bonus
• Exam: will be announced in TUMonline

Material

Slides

• Chapter 1: Introduction
• Chapter 2: Computational Models
• Chapter 3: Concurrency Control: Notions of Correctness for the Page Model
• Chapter 4: Concurrency Control Algorithms
• Chapter 5: Multiversion Concurrency Control
• Chapter 6: Concurrency Control on Objects: Notions of Correctness
• Chapter 7: Concurrency Control Algorithms on Objects
• Chapter 8: Concurrency Control on Relational Databases
• Chapter 9: Concurrency Control on Search Structures
• Chapter 10: Implementation and Pragmatic Issues
• Chapter 11: Transaction Recovery
• Chapter 12: Crash Recovery: Notion of Correctness
• Chapter 13: Page-Model Crash Recovery Algorithms
• Chapter 14: Object-Model Crash Recovery
• Chapter 15: Special Issues of Recovery

Literature

• Gerhard Weikum, Gottfried Vossen. Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery. Morgan Kaufmann Publishers, 2002

Exam

• The exam will be announced in TUMonline.
• Registration: via TUMonline, May 16 – June 30.
• It will be a written exam.
• There will be no resit (Wiederholungsprüfung). The next exam will probably take place at the end of Sommersemester 2017.

(No responsibility is taken for the correctness of this information, please refer to TUMonline and the department's website on exams.)