Skip to content. | Skip to navigation

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

Implementation of Databases

Type Lecture
Term WS 20/21
Mentor(s)
Assistant(s)

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.

Important:

We will give the initial introduction to the lecture via Zoom on 27/10/2020. Please find the Zoom meeting information in the RWTHmoodle announcements.

Prerequisites

An introductory 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

  • H. Garcia-Molina, J.D. Ullman, J. Widom: Database Systems – The Complete Book. 2nd Ed., Pearson, 2008.
  • R. Ramakrishnan, J. Gehrke: Database Management Systems. McGraw-Hill, 2003.
  • A. Kemper, A. Eickler: Datenbanksysteme - Eine Einführung. Oldenbourg, 2013, 9. Auflage
  • D.E. Shasha, P. Bonnet: Database Tuning: Principles, Experiments and Troubleshooting Techniques. Morgan Kaufmann, 2003.
  • T. Härder, E. Rahm: Datenbankssysteme - Konzepte und Techniken der Implementierung, Springer, 2001, 2. Ausgabe (In German)
  • G. Vossen: Datenbankmodelle, Datenbanksprachen und Datenbank-Management-Systeme, Oldenbourg, 2002. (in German)
  • G. Weikum, G. Vossen: Transactional Information Systems, Morgan Kaufmann Publ., 2002
  • S. Abiteboul, R. Hull, V. Vianu: Foundations of Databases, Addison-Wesley, 1995
  • H.F. Korth, A. Silberschatz: Database System Concepts. 3rd Ed., McGraw Hill, 1998.
  • J. D. Ullman: Principles of Database and Knowledge-Base Systems; Volume I, Computer Science Press, 1988
  • J. D. Ullman: Principles of Database and Knowledge-Base Systems - Volume II: The New Technologies, Computer Science Press, 2001
  • P. A. Bernstein, V. Hadzilacos, N. Goodman: Concurrency Control and Recovery In Database Systems, http://research.microsoft.com/~philbe/ccontrol/
  • M.T. Özsu, P. Valduriez: Principles of Distributed Database Systems. 2nd Ed., Prentice Hall, 1998.
  • E. Redmond, J. R. Wilson: Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement, O'Reilly UK Ltd., 2012.

Document Actions