Application and Implementation of Database Systems
Module IN2031
This module handbook serves to describe contents, learning outcome, methods and examination type as well as linking to current dates for courses and module examination in the respective sections.
Basic Information
IN2031 is a semester module in German language at Bachelor’s level and Master’s level which is offered in summer semester.
This Module is included in the following catalogues within the study programs in physics.
- Catalogue of non-physics elective courses
| Total workload | Contact hours | Credits (ECTS) |
|---|---|---|
| 180 h | 75 h | 6 CP |
Content, Learning Outcome and Preconditions
Content
- Error Handling
- Concurrency Control
- Security and Privacy
- Object Oriented und Object Relational Database Concepts
- Deductive Databases
- Distributed Databases
- Business Intelligence: Data Warehousing, Data Mining
- Main Memory Database Systems
- XML and Database Systems
- Database Concepts in the Context of Big Data Applications
- Performance Evaluation
- Concurrency Control
- Security and Privacy
- Object Oriented und Object Relational Database Concepts
- Deductive Databases
- Distributed Databases
- Business Intelligence: Data Warehousing, Data Mining
- Main Memory Database Systems
- XML and Database Systems
- Database Concepts in the Context of Big Data Applications
- Performance Evaluation
Learning Outcome
Students command the components of modern database systems in detail, they know how to implement and evaluate the underlying algorithms and data structures, and are able to develop them further under different constraints.
Preconditions
IN0008 Fundamentals of Databases, IN0007 Fundamentals of Algorithms and Data Structures
Courses, Learning and Teaching Methods and Literature
Courses and Schedule
| Type | SWS | Title | Lecturer(s) | Dates | Links |
|---|---|---|---|---|---|
| VO | 3 | Application and Implementation of Database Systems (IN2031) |
Thu, 09:00–13:00, Interims I 101 |
documents |
|
| UE | 2 | Application and Implementation of Database Systems, Exercise Session (IN2031) | dates in groups |
documents |
Learning and Teaching Methods
Lecture, tutorial, problems for individual study
Media
Lecture with animated slides
Literature
- Alfons Kemper, André Eickler: Datenbanksysteme. Eine Einführung. 10., aktualisierte und erweiterte Auflage, Oldenbourg Verlag, 2015
- A. Kemper, M. Wimmer: Übungsbuch: Datenbanksysteme. 3. Auflage Oldenbourg Verlag, 2012
- A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts. Sixth Edition, McGraw-Hill, 2010
- T. Härder, E. Rahm: Datenbanksysteme - Konzepte und Techniken der Implementierung. 2. Auflage, Springer Verlag, 2001
- J. Gray, A. Reuter: Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993
- A. Kemper, M. Wimmer: Übungsbuch: Datenbanksysteme. 3. Auflage Oldenbourg Verlag, 2012
- A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts. Sixth Edition, McGraw-Hill, 2010
- T. Härder, E. Rahm: Datenbanksysteme - Konzepte und Techniken der Implementierung. 2. Auflage, Springer Verlag, 2001
- J. Gray, A. Reuter: Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993
Module Exam
Description of exams and course work
The academic assessment will be done by a written exam of 90 minutes. Assignments checking knowledge verify the familiarity with components of modern database systems; programming assignments verify the ability to implement and critically evaluate advanced algorithms and data structures of the database components; small scenarios with defined architectures and applications have to be set up with the methods learnt which verifies the ability to develop precise partial solutions.
Exam Repetition
The exam may be repeated at the end of the semester.