Skip to content. | Skip to navigation

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

Implementation of Databases

Type Weekly Lecture
Term WS 15/16
Mentor(s)
Assistant(s)
ZPA exam 11. Mar 2015 14:00
AHV, 5056
Repeat exam 04. Apr 2015 10:00
5053.2 (B-IT Research School, opposite AH6)
Campus visit
L2P 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 Thursday, 13:30 - 15:00 5053.2 (B-IT Research School, opposite AH6) 22. October 2015
Tuesday, 13:30 - 15:00 5053.2 (B-IT Research School, opposite AH6) 27. October 2015
Exercise Thursday, 13:30 - 15:00 5053.2 (B-IT Research School, opposite AH6) 05. November 2015

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