Skip to content. | Skip to navigation

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

Implementation of Databases

Type Weekly Lecture
Term WS 17/18
Mentor(s)
Assistant(s)
Certificate exam 01. Mar 2018 10:00
AH V, 5056, 5053.2
Repeat exam 04. Apr 2018 10:00
5053.2

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, 10:15 - 11:45 5053.2 (B-IT Research School, opposite AH6) 10. October 2017
Thursday, 14:15 - 15:45 5053.2 (B-IT Research School, opposite AH6) 12. October 2017
Exercise Thursday, 14:15 - 15:45 5053.2 (B-IT Research School, opposite AH6) 26. October 2017

Prerequisites

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