Datenbanksysteme I (Sommersemester 2024)

Dozent: Prof. Dr. Felix Naumann (Information Systems) , Youri Kaminsky
Website zum Kurs: https://hpi.de/naumann/teaching/current-courses/ss-2024/datenbanksysteme-i.html

Allgemeine Information

• Semesterwochenstunden: 4
• ECTS: 6
• Benotet: Ja
• Einschreibefrist: 01.04.2024-30.04.2024
• Prüfungszeitpunkt §9 (4) BAMA-O: 08.08.2024
• Lehrform: Vorlesung / Übung
• Belegungsart: Wahlpflichtmodul
• Lehrsprache: Deutsch

Studiengänge, Modulgruppen & Module

Beschreibung

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.

Literatur

• 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

Lern- und Lehrformen

Lecture and exercise (Vorlesung und Übung)

Leistungserfassung

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. 

Termine

Siehe Webseite des Fachgebiets.

Rücktritt von der Veranstaltung bis 28.04.2024 (erste Abgabe eines Übungsblatts)

Zurück