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.
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).
PrerequisitesThe course is aimed at Master-level students who have already taken the following (or similar) courses:
- Foundations of Computer Science
- Introduction to Databases
- 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
- 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
- Gerhard Weikum, Gottfried Vossen. Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery. Morgan Kaufmann Publishers, 2002
- 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.