Skip to main content

Transaction Processing

(in German: Transaction Processing - )

Module-ID: FIN-INF-103202
Link: LSF
Responsibility: Gunter Saake
Lecturer: Thomas Leich
Classes:
  • Lecture Transaction Processing
  • Exercise Transaction Processing
 
Applicability in curriculum: - M.Sc. INF: Informatik
- M.Sc. INGINF: Informatik
- M.Sc. WIF: Informatik
- M.Sc. DKE: Data Processing for Data Science
- M.Sc. DE: Methoden der Informatik
- M.Sc. DE: Fachliche Spezialisierung
- M.Sc. VC: Computer Science

Abbreviation

TP

Credit Points

6

Semester

Winter

Term

ab 1.

Duration

1 Semester

Language

english

Level

Master

Intended learning outcomes:
The students ...

  • understand the theoretic concepts of serializability
  • have a broad knowledge of transaction management strategies
  • can apply methods of transaction management for relational databases
  • can assess the performance of transaction protocols in different use cases
  • understand database recovery mechanisms
  • know distributed and advanced transaction processing principles

Content:

  • Concepts of transaction processing
  • Theory of serializability and syncronization
  • Pessimistic and optimistic transaction processing
  • Advanced transaction models
  • Database backup and recovery
  • Transaction processing in distributed database systems (distributed serializability, distributed commit, etc.)
  • Replication

Workload:
56h contact hours
124h self study

Type of examination: Teaching method / lecture hours per week (SWS):

  • Written Exam 120 minutes
  • Requirements for exam admittance will be announced in the first lecture

  • Lecture 2 SWS
  • Exercise 2 SWS
Prerequisites according to examination regulations: Recommended prerequisites:

keine

Lecture Database Concepts / Datenbanken I

Media: Literature:

Datenbanken: Implementierungstechniken. Gunter Saake, Kai-Uwe Sattler, Andreas Heuer, 4. Auflage mitp-Verlag, Bonn, 2019, ISBN: 978-3-95845-779-9

Comments: