Skip to content
Technische Universität Berlin Deutsch
Course catalog and module transfer system

Data Management and Data SystemsModule description #41286 / Version 1

← Module page Deutsche Fassung
Module / Version#41286 / #1
ValiditySince Winter semester 2026/27
Available language(s)English, German
Credit points6
Person responsible for the moduleBöhm, Matthias
GradingGraded
Exam formatWritten exam
Language(s) of instructionEnglish, German

Affiliation

FacultyFakultät IV
InstituteInstitut für Softwaretechnik und Theoretische Informatik
Academic chair34352900 FG Big Data Engineering

Contact

OfficeTEL 8-1
Contact personBöhm, Matthias
E-mail addressmatthias.boehm@tu-berlin.de
Websitehttps://www.tu.berlin/dams

Learning outcomes

Students understand die general architecture and use of traditional, relational database systems as well as modern data management techniques and systems. Therefore, students are enabled to build, in an effective manner, efficient data-centric applications from data modelling, over persistent storage and tuning to query and transaction processing in different environments. With topics on the internals of data systems, students further deepen the existing understanding of algorithms and data structures, computer organization and distributed systems, foundations of programming, programming paradigms, as well as logic and discrete structures. The combination of lectures and exercises (in terms of practical programming tasks in freely- chosen programming languages) allows both a theoretical understanding as well as practical skills of applying the learned concepts and techniques. Ultimately, students acquire the ability to use, evaluate, and consciously select alternative data systems as well as deepen fundamental concepts of computer science.

Content

Part A: (Relational) Database Systems
• 01 Introduction and Overview
• 02 Data Modelling and Normalization (2 lectures)
• 03 Relational Algebra
• 04 Query Languages (SQL, XML, JSON) and APIs
• 05 Physical Design and Tuning (incl. compression, indexing)
• 06 Query Processing and Optimization
• 07 Transaction Processing and Concurrency

Part B: Modern Data Management (Systems)
• 08 NoSQL (incl. key-value, document, graph processing)
• 09 Arrays and Vector Processing (incl. frames/tensors)
• 10 Time Series Databases and Analytics
• 11 Distributed Storage and Data Analysis
• 12 Data Stream Processing Systems

The covered lecture contents will be complemented by exercises on data modeling database applications, query processing, and handling of different data modalities.

Module components

Compulsory area

The following courses are mandatory for this module:

CoursesTypeNumberFrequencyLanguageHours per weekCourse catalog
Datenmanagement und DatensystemeLecture Winter semester[de]2 ISIS
Datenmanagement und DatensystemeExercise Winter semester[de]2 ISIS

Courses in the course catalog

Courses created from the teaching units of this module.

Winter semester 2026/27 (5)

Datenmanagement und Datensysteme (Lecture) 1

All groups of this course in the catalog

Datenmanagement und Datensysteme (Exercise) 4

All groups of this course in the catalog

Workload and credit points

Datenmanagement und Datensysteme (Lecture)

Workload descriptionMultiplierHoursTotal
Attendance152 h30 h
Pre/post processing151 h15 h
45 h

Datenmanagement und Datensysteme (Exercise)

Workload descriptionMultiplierHoursTotal
Attendance152 h30 h
Pre/post processing151 h15 h
45 h

Course-independent workload

Workload descriptionMultiplierHoursTotal
Exam Preparation130 h30 h
Prerequisite Programming Tasks320 h60 h
90 h

The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.

Description of teaching and learning methods

Lectures for general coverage of the content, augmented by weekly exercises for interactive and practical understanding of the lecture contents. The exercise tasks cover both, the understanding of theoretical foundations as well as practical usage of database management systems (DBMS).

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

• Basic programming skills (e. g. “Foundations of Programming” module)
• Basic knowledge of computer architecture (e. g. “Computer Organization and Operating Systems” module)

Mandatory requirements for the module examination registration:

The examination requirements could not be retrieved.

Completion of the module

GradingGraded
Exam formatWritten exam
LanguageEnglish, German
Duration/Extent90 minutes

Exam description

Description of Prerequisite Programming Tasks
========================================

1. Database Creation
• Creation and modification of a database based on a specification
• Effort: about 20 h
• Passing Criterion: 75 % of possible points (unlimited attempts in the given time period)

2. Relational Database Systems
• Development of queries for an existing database
• Effort: about 28 h
• Passing Criterion: 75 % of possible points (unlimited attempts in the given time period)

3. Modern Data Management
• Development of queries for a non-relational data system
• Effort: about 12 h
• Passing Criterion: 75 % of possible points (unlimited attempts in the given time period)

Duration of the module

The following number of semesters is estimated for taking and completing the module: 1 semester(s).

This module can be started in the following semesters: Winter semester.

Maximum number of participants

This module is not limited to a number of students.

Registration procedures

Registration in ISIS

Recommended reading, lecture notes

Lecture notes

unavailable

Electronic lecture notes

available – Further reading will be announced via the ISIS course

Recommended literature

No recommended literature given

Assigned programs

This module version is used in the following programs:

Program / program versionSemester(s)Curriculum component
Computer Science
Computer Science (B. Sc.) - StuPO 2025
WS 2026/27Pflichtbereich › Systemkompetenzen
Information Systems Management
Information Systems Management (B. Sc.) - StuPO 2025
WS 2026/27Pflichtbereich › Grundlagen der Informatik

Miscellaneous

Not specified