Data Management (DM)

Structure and Manage Data Effectively: Model relational and NoSQL databases, design and manage data structures, use query languages effectively, and integrate databases into applications through modern interfaces.

Contents

• Relational databases
• Data models (e.g., E / R plots) and data modeling
• Relational algebra
• Database design
• Structured Query Language (SQL) and its foundations
• NoSQL and BigData
• Connecting databases to modern (web-based) applications via JDBC and JSON

Competencies

Students are able to

• designate the principles of data models, database languages and database management systems,
• consider whether to apply a NoSQL or relational approach to a given problem of data modeling,
• transfer predetermined scenarios into a database design using data modeling,
• apply the different paradigms of the request languages, and
• develop database applications from high-level languages.

Literature

• L. Piepmeyer, Grundkurs Datenbanksysteme. Von den Konzepten bis zur Anwendungsentwicklung. München: Hanser, 2011.
• G. Saake, K. U. Sattler, and A. Heuer, Datenbanken – Konzepte und Sprachen, 3. Aufl. Heidelberg: MITP-Verlag, 2007.
• A. Kemper and A. Eickler, Datenbanksysteme – eine Einführung, 6. Aufl. München: Oldenbourg Verlag, 2006.
• P. Kleinschmidt and C. Rank, Relationale DB-Systeme – Eine praktische Einführung, 3. Aufl. Berlin, Heidelberg: Springer, 2005.

Lecturer

• Prof. Dr. Markus Gumbel
• Prof. Dr. Oliver Hummel
• Prof. Dr. Sven Klaus
• Prof. Dr. Anuja Hariharan

Recommended Previous Knowledge 

• none

Module Details

Semester	3
Lecture Language	German
Frequency	Every Term
Credit Points (ECTS)	5
Course Coordinator	Prof. Dr. Sven Klaus
Duration	1 Semester
Course Achievement	None
Prerequisite for exam	Compulsory Assignment (PU)
Exam	Written Exam 90 Minutes (K90)

Weekly Hours (SWS) 

Lecture	3 SWS
Lab	1 SWS
Sum	4 SWS

Work Load 

Lecture	45 h
Lab	15 h
Self Study	90 h
Sum	150 h