Data Management and Data SystemsModule description #41286 / Version 1
- 6 CP
- Written exam
- Graded
- Winter semester
- English, German
| Module / Version | #41286 / #1 |
|---|---|
| Validity | Since Winter semester 2026/27 |
| Available language(s) | English, German |
| Credit points | 6 |
| Person responsible for the module | Böhm, Matthias |
| Grading | Graded |
| Exam format | Written exam |
| Language(s) of instruction | English, German |
Affiliation
| Faculty | Fakultät IV |
|---|---|
| Institute | Institut für Softwaretechnik und Theoretische Informatik |
| Academic chair | 34352900 FG Big Data Engineering |
Contact
| Office | TEL 8-1 |
|---|---|
| Contact person | Böhm, Matthias |
| E-mail address | matthias.boehm@tu-berlin.de |
| Website | https://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.
• 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:
| Courses | Type | Number | Frequency | Language | Hours per week | Course catalog |
|---|---|---|---|---|---|---|
| Datenmanagement und Datensysteme | Lecture | Winter semester | [de] | 2 | WS 2026/27 (1) ISIS | |
| Datenmanagement und Datensysteme | Exercise | Winter semester | [de] | 2 | WS 2026/27 (4) 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
Datenmanagement und Datensysteme (Exercise) 4
- Datenmanagement und Datensysteme (DMS) (Übung) Do. 22.10 - 17.12.26, wöchentlich, Do. 07.01 - 11.02.27, wöchentlich, 16:00 - 18:00 Charlottenburg, ER 164
- Datenmanagement und Datensysteme (DMS) (Übung) Fr. 23.10 - 11.12.26, wöchentlich, Fr. 08.01 - 12.02.27, wöchentlich, 12:00 - 14:00 Charlottenburg, EW 203
- Datenmanagement und Datensysteme (DMS) (Übung) Mi. 21.10 - 16.12.26, wöchentlich, Mi. 06.01 - 10.02.27, wöchentlich, 12:00 - 14:00 Charlottenburg, C 243
- Datenmanagement und Datensysteme (DMS) (Übung) Warteliste
Workload and credit points
Datenmanagement und Datensysteme (Lecture)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Attendance | 15 | 2 h | 30 h |
| Pre/post processing | 15 | 1 h | 15 h |
| 45 h | |||
Datenmanagement und Datensysteme (Exercise)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Attendance | 15 | 2 h | 30 h |
| Pre/post processing | 15 | 1 h | 15 h |
| 45 h | |||
Course-independent workload
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Exam Preparation | 1 | 30 h | 30 h |
| Prerequisite Programming Tasks | 3 | 20 h | 60 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)
• 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
| Grading | Graded |
|---|---|
| Exam format | Written exam |
| Language | English, German |
| Duration/Extent | 90 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)
========================================
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 version | Semester(s) | Curriculum component |
|---|---|---|
| Computer Science Computer Science (B. Sc.) - StuPO 2025 | WS 2026/27 | Pflichtbereich › Systemkompetenzen |
| Information Systems Management Information Systems Management (B. Sc.) - StuPO 2025 | WS 2026/27 | Pflichtbereich › Grundlagen der Informatik |
Miscellaneous
Not specified