Hasso-Plattner-Institut
Prof. Dr. Felix Naumann
 

Database Systems I

Instructors

Content

Database systems are at the core of almost all large applications and are used in all enterprises. In this lecture, we will discuss database systems from an application perspective. We start with the conceptual design of databases using ER diagrams and their translation into the relational data model.  Then, we dig into the relational algebra that enables us to operate on top of these models. We also learn the SQL querying language, i.e., how we can create, update and search data tables. The second part of this lecture discusses advanced topics such as transaction management, programming database systems. From time to time, we will leave the application perspective and learn how a database system implements user instructions, for example during query processing or for consistency assurance.

Registration for participation takes place via Moodle. If you are interested, please register there, as further communication will take place via this platform during the course. The lecture is accompanied by an exercise, the successful participation of which is a prerequisite for admission to the examination. The performance will be assessed through a written exam. 

Lectures will be given in English.

Announcements

  • The slides will each be available in the internal area.

 

Schedule

  • Monday and Wednesday 
  • Time: 13:30 - 15:00
  • Location: HS 1  

Date

Topic

Monday17.04.Introduction and organization
Wednesday19.04.History, terms and architecture (in L-E.03)
Monday24.04.Relational Database Design
Wednesday26.04.Relational Database Design
Monday01.05.Labor Day
Wednesday03.05.Normalization
Monday08.05.Normalization
Wednesday10.05.Relational Algebra
Monday15.05.Relational Algebra
Wednesday17.05.SQL
Monday22.05.SQL
Wednesday24.05.SQL
Monday29.05.Whit Monday
Wednesday31.05.No lecture
Monday05.06.No lecture
Wednesday07.06.No lecture
Monday12.06.SQL
Wednesday14.06.SQL + Integrity Constraints (in L-E.03)
Monday19.06.Integrity Constraints + Transaction Management
Wednesday21.06.Transaction Management
Monday26.06.Transaction Management
Wednesday28.06.Transaction Management+ APIs
Monday03.07.APIs+ Query Processing and Optimization
Wednesday05.07.Query Processing and Optimization (in H2)
Monday10.07.Query Processing and Optimization+ DB Security
Wednesday12.07.Outlook
Monday17.07.No lecture
Wednesday19.07.No lecture
Monday24.07.Exam preparation
Wednesday26.07.No lecture
Friday18.08Exam 

 

 

Literature

  • Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems - The Complete Book, Pearson Education International, 2008. The book is available in the UP library and at our chairs library. Furthermore, at Amazon.de  (earlier editions are often available at a lower price). The book is also a textbook for DBS II.

There are also a number of other (German and English) textbooks on the subject, all of which are also suitable as study guides, such as:

  • Gunter Saake, Andreas Heuer, Kai-Uwe Sattler - Datenbanken: Konzepte und Sprachen, mitp Verlags GmbH & Co, 2018
  • Elmasri Ramez And Navathe Shamkant: Fundamentals of Database Systems, Pearson India, 2017
  • Alfons Kemper, André Eickler: Datenbanksysteme - Eine Einführung, De Gruyter Oldenbourg, 2015