UnivIS
Information system of Friedrich-Alexander-University Erlangen-Nuremberg © Config eG 

Transaktionssysteme / Transaction Systems (TRASYS)

Lecturer
Prof. Dr. Richard Lenz

Details
Vorlesung
2 cred.h
nur Fachstudium, Sprache Deutsch
Time and place: Tue 14:15 - 15:45, 0.031-113

Fields of study
WF WINF-BA 4-6
WPF INF-BA-V-DB 5-6
WPF INF-MA 1-3
WPF INF-LAR 1-6
WPF INF-LAG 1-6
WPF IuK-MA-ES-INF 1-3
WPF IuK-MA-KN-INF 1-3
WPF IuK-MA-ÜTMK-INF 1-3
WPF SIM-DH 5-9
WPF SIM-MA 1-3
WF M-BA 4-6
WPF IIS-MA 2-3

Prerequisites / Organisational information
Inhalt: http://www6.informatik.uni-erlangen.de/DE/teaching/curriculum/trasys/
StudOn: http://www.studon.uni-erlangen.de/crs441577.html

Contents
Transactions are the core mechanism to guarantee database consistency in the presence of failures. The lecture introduces the cornerstones of the Transaction Concept and related techniques and system architectures. Topics are:
  • Reconstructing the Transaction Model

  • Advanced Transaction Models

  • Queued transaction processing

  • Implementing the ACID properties of transactions: Concurrency control, logging and recovery

  • TP Monitors: TRPC, Architecture of TP Monitor, Transaction Manager

This course generalizes the transaction concept from its traditional database system domain to the broader context of client-server computing. The course begins by defining basic terminology and concepts. The role of a transaction processing system in application design, implementation, and operation is covered. Subsequent lectures cover the theory and practice of implementing locking, logging, and the more generic topic of implementing transactional resource managers.

Recommended literature
Text books:
Gray and Reuter: Transaction Processing: Concepts and Techniques, Bernstein, Newcomer: Principles of Transaction Processing
BERNSTEIN, P. A. ; NEWCOMER, E.: Principles of Transaction Processing. Morgan Kaufmann, 1997
GRAY, J.N. ; REUTER, A.: Transaction Processing : Concepts and Techniques. Morgan Kaufmann, 1992

Additional information
Expected participants: 40

Verwendung in folgenden UnivIS-Modulen
Startsemester SS 2012:
Data Warehousing und Transaktionssysteme (DWTAS)
Datenbanken in Rechnernetzen und Transaktionssysteme (DBRNTAS)
Datenstromsysteme und Transaktionssysteme (DSSTAS)
Knowledge Discovery in Databases und Transaktionssysteme (KDDTAS)

Department: Chair of Computer Science 6 (Data Management)
UnivIS is a product of Config eG, Buckenhof