Transaction Systems

Information

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 and Exam

  • Date, time, and location: Monday 9am–12pm (90 minutes lecture followed by 90 minutes exercise session), Room 02.09.014
    First lecture: April 24, 2017
  • Bonus: There will be optional home assignments. If you achieve 75% or more in the home assignments, you will receive a 0.3 bonus on the exam grade (iff your exam grade is between 1.3 and 4.0).
    • Example: A student achieves 82% in the home assignments, and 1.7 in the final exam. His/Her final grade will be 1.4.
  • Exam: Written exam, 90 minutes. We will practice exam-style problems in the exercise sessions and the home assignments.
  • Exam date, time, and location: will be announced in TUMonline
  • Exam registration: via TUMonline
  • Resit exam (Wiederholungsprüfung): There will be no resit exam (Wiederholungsprüfung). The next exam will probably take place at the end of Sommersemester 2018.
  • Post-exam review (Klausureinsicht): Tuesday, September 5, 1pm. More information will be announced via e-mail as soon as the grades are published.

Material

Slides

Literature

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

(The eBook is available via opac.ub.tum.de. Written copies can be found at the Chemistry library.)
 

Navigation