Transaction Processing
(in German: Transaction Processing )
Module-ID: FIN-INF-103202 |
| Link: | LSF |
| Responsibility: | Gunter Saake |
| Lecturer: | Thomas Leich |
| Classes: |
|
| 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
| Pre-examination requirements: | Type of examination: | Teaching method / lecture hours per week (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: