Transaction Processing

Organization

Lecturer:  Gunter Saake
Lecture:  LSF-Entry
Exercise Instructor:  Andreas Meister 
Exercise:  LSF-Entry
Exam requirements
  • Registration for the exercise via LSF

News

  • Please register for the lecture via LSF
  • The exams are corrected, and the results should soon be available in the LSF.
  • The exam review will take place on 04. October 2018 in room G29-130 at 09:00.
  • The lecture on the 12.10.2018 is cancelled.
  • The first exercise will take place on 29.10.2018.

Content

  • Transaction concepts
  • Serialization theory
  • Synchronisation techniques
  • Recovery and data backup
  • Transaction processing in distributed database systems
  • Advanced transaction models

Lecture

  • The lecture slides will be published after each lecture.
    • Overview
    • Introduction
    • Transactions
    • Transaction Theory
    • Transaction Management
    • Advanced transaction models 
    • Recovery
    • Transaction Management for distributed databases 
    • Replication

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.
      • Motivation, ACID, Terms , Problems in Multi-User Model
      • Serializability, Lock/Unlock-Model, Schedule, R/W-Model
      • Correctness and Serializability, Closure
      • Transaction aborts, robustness, and locking model
      • Lock granularity, non-locking approaches
      • MVCC,  advanced transaction models I 
      • Advanced transaction models II, Recovery
      • Recovery strategies, REDO protocol, shadow storage, backups
      • Distributed Transaktion Management
      • Replication

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.

 

Letzte Änderung: 09.10.2018 - Ansprechpartner:

Sie können eine Nachricht versenden an: Webmaster
Sicherheitsabfrage:
Captcha
 
Lösung: