Skip to content. | Skip to navigation

Informatik 5
Information Systems
Prof. Dr. M. Jarke
Sections
Personal tools
You are here: Home Teaching WS 14/15 Implementation of Databases

Implementation of Databases

Type Weekly Lecture
Term WS 14/15
Mentor(s)
Assistant(s)
ZPA exam 06. Mar 2015 14:00
AH V and seminar room 5056
Repeat exam 30. Mar 2015 10:00
5053.2 (opposite to AH VI)
Campus visit

The lecture introduces basic technologies of the realization of database systems. Beside the coarse architecture (e.g. layered architecture) detailed procedures for the solution of special database tasks (especially query analysis and transaction management) will be discussed. The concepts of implementation will be applied to classical (relational model) as well as to more recent data models (distributed, XML). In addition to necessary theoretical fundamentals, practical concepts will be introduced that allow database administrators the efficient tuning of databases.

Course dates

Meeting typeDate/TimeRoomStarting on
Lecture Tuesday, 15:15 - 16:45 5053.2 (opposite to AH VI) 21. October 2014
Thursday, 15:15 - 16:45 5053.2 (opposite to AH VI) 16. October 2014
Exercise Thursday, 15:15 - 16:45 5053.2 (opposite to AH VI) 30. October 2014

Prerequisites

Introductionary course to database systems (e.g., Datenbanken und Informationssysteme) which includes basic knowledge about the relational data model, query languages, database architectures, and query processing

Literature

  • R. Ramakrishnan, J. Gehrke: Database Management Systems, 3rd Ed., McGraw-Hill, 2003.
  • H. Garcia-Molina, J.D. Ullman, J. Widom: Database Systems – The Complete Book. 2nd Ed., Pearson, 2008.
  • A. Kemper, A. Eickler: Datenbanksysteme – Eine Einführung. Oldenbourg, 2013, 9. Auflage.
  • G. Weikum, G. Vossen: Transactional Information Systems, Morgan Kaufmann Publ., 2002.
  • M.T. Özsu, P. Valduriez: Principles of Distributed Database Systems. 3rd Ed., Springer, 2011.
  • T. Härder, E. Rahm: Datenbankssysteme - Konzepte und Techniken der Implementierung, Springer, 2001, 2. Ausgabe.
  • P. A. Bernstein, V. Hadzilacos, N. Goodman: Concurrency Control and Recovery In Database Systems, online available here
  • D.E. Shasha, P. Bonnet: Database Tuning: Principles, Experiments and Troubleshooting Techniques. Morgan Kaufmann, 2003.

Document Actions