Transaction Processing

Organization

Lecturer:  Thomas Leich
Lecture:  LSF-Entry
Exercise Instructor:  Paul Blockhaus

Exercise:

 LSF-Entry

Moodle:

Moodle Link

News

  • The first lecture will take place on the 13.10.2023 in G02-109 from 15-17h .Please check the Moodle for more information regarding the lecture and exercise.
  • The first exercise session will be on the TBA.
  • In order to be eligible for the exam, you have to register for the Moodle-course till October 20 and vote for at least 50% of the exercise tasks.

Content

  • Motivation and Database Concepts
  • Transaction Models
  • Transaction Management
  • Advanced Transaction Models
  • Recovery and Back-up
  • Distributed Transactions
  • Replication

Lecture

  • The lecture slides will be published on the Moodle.

Exercise

  • Exercise sheets will be published one week in advance.
  • Exercise tasks need to be prepared before the exercise and will be discussed within the exercise.

Literature

  • The lecture is based on the following books:
    • Gunter Saake, Kai-Uwe Sattler, Andreas Heuer: Datenbanken Implementierungstechniken, Mitp-Verlag, 3. Auflage, 2011. (Kapitel 9-11)
    • Erhard Rahm, Gunter Saake, Kai-Uwe Sattler: Verteiltes und Paralleles Datenmanagement - Von verteilten Datenbanken zu Big Data und Cloud, Springer-Verlag, 2015.
  • Further literature:
    • Härder, T.; Rahm, E.: Datenbanksysteme Konzepte und Techniken der Implementierung. Springer-Verlag, 2001
    • Garcia-Molina, H.; Ullman, J.; Widom, J.: Database System Implementation. Addison-Wesley, 1999.
    • Silberschatz, A.; Korth, H. F.; Sudarshan, S.: Database System Concepts. Wiley & Sons, 2001.

Last Modification: 07.09.2023 - Contact Person: