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. Hanser; 2011
• G. Saake, K.U. Sattler, A. Heuer: Datenbanken – Konzepte und Sprachen: MITP-Verlag; 3. Aufl. 2007; ISBN 978-3-8266-1644-8
• A. Kemper, A. Eickler: Datenbanksysteme – eine Einführung, Oldenbourg Verlag; 6. Aufl. 2006; ISBN 978-3486576900
• P. Kleinschmidt, Ch. Rank: Relationale DB-Systeme – Eine praktische Einführung: Springer; 3. Aufl. 2005; ISBN 978-3540224969

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