Skip to content. | Skip to navigation

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

Implementation of Databases

Type Weekly Lecture
Term WS 18/19
Mentor(s)
Assistant(s)
Certificate exam 01. Mar 2019 10:00
AH V, 5056, 5053.2
Repeat exam 29. Mar 2019 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.

Information about course materials and L2P Course Room

We have enabled the registration for the course in the RWTH Online system. Please register yourself for the course. After your registration, there still needs to be a manual process by us, and automatic synchronization between RWTH-Online and L2P. The synchronization is performed only a few times per day, thus, it might take several hours or even a day until you are enrolled in the L2P room. There, you can access the L2P Learning Room for Lecture Materials and Assignments. If you are not able to get access to L2P room by the end of this week (Sunday, October 21,2018), although you registered in RWTH Online before Oct 17, then please contact the course organisers by mail.

Update Oct 17, 9am

About 115 students have been successfully registered in L2P (those that registered until Monday, Oct 15, 10pm), another batch is currently processed and should have access by Thursday morning.

Lecture Slides

The lecture slides for the Introductory meeting and the Recap Lectures can be downloaded from here, as long as the L2P registration problems have not been resolved:

 
The dataset used in the MongoDB tutorial can be downloaded from here: Mini-Lecture data.zip

Assignments

Exercises can be downloaded from the links below: 
 

Course dates

Meeting typeDate/TimeRoomStarting on
Lecture Tuesday, 14:30 - 16:00 5053.2 (B-IT Research School, opposite AH6) 09. October 2018
Thursday, 14:30 - 16:00 5053.2 (B-IT Research School, opposite AH6) 11. October 2018
Exercise Thursday, 14:30 - 16:00 5053.2 (B-IT Research School, opposite AH6) 25. October 2018

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