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

Information Systems and Data AnalysisModule description #40002 / Version 14

← Module page Deutsche Fassung
Module / Version#40002 / #14
ValiditySince Summer semester 2026
Available language(s)English, German
Credit points6
Person responsible for the moduleMarkl, Volker
GradingGraded
Exam formatWritten exam
Language(s) of instructionGerman

Affiliation

FacultyFakultät IV
InstituteInstitut für Softwaretechnik und Theoretische Informatik
Academic chair34351500 FG Datenbanksysteme und Informationsmanagement (DIMA)

Contact

OfficeFR 7-1
Contact personBorusan, Alexander
E-mail addresssekr@dima.tu-berlin.de
Websitehttps://www.tu.berlin/dima

Learning outcomes

As a participant of this module you will be able to name the basic concepts of information management with (relational) databases, develop information models and formulate queries to a database in relational algebra and SQL. In particular, you will learn about the problems that can occur when human users interact with the database system. You will be able to describe a data warehouse and compare it to transactional systems and decide which requirements a system must fulfill in order to match a specific application profile. Furthermore, you will be able to name basic data analysis algorithms such as classification and clustering algorithms and suggest their use for supervised and unsupervised machine learning. Last, you will learn how to process continuously evolving data using a data stream management system and when to use such systems.

Content

Information systems are fundamental in business and industrial applications. Flight bookings, online shopping, large enterprise resource planning and production control systems are just a few examples. Driving modern economy and science today are individuals with competences in efficient data management and deep data analysis, whose contributions lead to new insights and facilitate decision-making.

Contents of this module especially are:

1. Architecture of Information Systems
2. Relational Data Model
3. Relational Algebra
4. Query Language SQL
5. Transaction systems
6. Data Warehousing
7. Data Base Management vs Data Streams Management
8. Introduction to Data Science
9. Algorithms for Data Analytics: Classification & Clustering algorithms

Module components

Compulsory area

The following courses are mandatory for this module:

CoursesTypeNumberFrequencyLanguageHours per weekCourse catalog
Informationssysteme und DatenanalyseLecture0434 L 500 Summer semester[de]2 ISIS
Informationssysteme und DatenanalyseExercise0434 L 500 Summer semester[de]2 ISIS

Workload and credit points

Informationssysteme und Datenanalyse (Lecture)

Workload descriptionMultiplierHoursTotal
lecture152 h30 h
lecture preparation151 h15 h
45 h

Informationssysteme und Datenanalyse (Exercise)

Workload descriptionMultiplierHoursTotal
tutorial152 h30 h
lecture preparation151 h15 h
45 h

Course-independent workload

Workload descriptionMultiplierHoursTotal
prerequisites320 h60 h
Exam preparation130 h30 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 to convey the material with accompanying weekly exercises (tutorials) for interactive consolidation and practical practice. Exercises will deepen the theoretical parts of the lecture and also use realistic examples for developing different queries, which you have to solve using problem-centric thinking.

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Basic knowledge of Python is required for solving the programming exercise. At the beginning of the lecture, we provide an exercise sheet containing the expected level of knowledge.

Mandatory requirements for the module examination registration:

The examination requirements could not be retrieved.

Completion of the module

GradingGraded
Exam formatWritten exam
LanguageGerman
Duration/Extent120 min

Exam description

Description of Prerequisites
========================

Database creation
-------------------------

Creation and modification of a database based on a specification

Effort: about 20h

passing criterion: 75 % of possible points

Mode: unlimited attempts within the processing period


relational database systems
---------------------------------------

Development of queries for an existing database

Effort: about 28h

passing criterion: 75 % of possible points

Mode: unlimited attempts within the processing period


data stream management systems
------------------------------------------------

Development of queries for a non-relational data system

Effort: about 12h

passing criterion: 75 % of possible points

Mode: unlimited attempts within the processing 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: Summer semester.

Maximum number of participants

This module is not limited to a number of students.

Registration procedures

The allocation of tutorials is done via MOSES before the start of the lecture -- please note the announcement.
The registration and deregistration deadlines will be announced in the lecture. The teaching materials will be provided via ISIS.
Please be sure to follow all regulations of your course of study!

Recommended reading, lecture notes

Lecture notes

unavailable

Electronic lecture notes

unavailable

Recommended literature

  • Elmasri und Navathe: "Grundlagen von Datenbanksystemen", Pearson, 3. Auflage, 2009
  • Gunter Saake, Kai-Uwe Sattler, Andreas Heuer: " Datenbanken - Konzepte und Sprachen", mitp, 2018
  • Guttag, John V: "Introduction to computation and programming using Python," MIT Press, 2013
  • Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems - The Complete Book, Pearson Prentice Hall, 2009.
  • Kemper, Eickler: “Datenbanksysteme - Eine Einführung,” Oldenburg, 5. Auflage 2004

Assigned programs

This module version is used in the following programs:

Program / program versionSemester(s)Curriculum component
Computational Engineering Science (Informationstechnik im Maschinenwesen)
StuPO 2018
SS 20265. Ingenieurwissenschaftliche Wahlpflichtmodule › 5.5 Informationstechnik
WS 2026/275. Ingenieurwissenschaftliche Wahlpflichtmodule › 5.5 Informationstechnik
Computer Engineering
Computer Engineering (B. Sc.) - StuPO 2015
SS 2026Wahlpflichtbereich › Informatik
WS 2026/27Wahlpflichtbereich › Kataloge › Medientechnik
Computer Science
Computer Science (B. Sc.) - StuPO 2015
SS 2026Pflichtbereich
WS 2026/27Pflichtbereich › Methodisch-praktische Grundlagen der Informatik
Digital Media and Technology
Digital Media and Technology (B. Sc.) - StuPO 2015
SS 2026Wahlpflichtbereich › Fachstudium Medientechnik
WS 2026/27Wahlpflichtbereich › Fachstudium Medientechnik
Economics
StuPO 2022
SS 2026Compulsory Elective Area › Markets and Technology
WS 2026/27Compulsory Elective Area › Markets and Technology
Electrical Engineering and Information Technology (Q-Master ET/IT, teacher training)
Anlage 3 - StuPO 2016
SS 2026Fachwissenschaftlicher Wahlpflichtbereich
WS 2026/27Fachwissenschaftlicher Wahlpflichtbereich
Electrical Engineering and Information Technology (Q-Master ET/IT, teacher training)
StuPO 2016
SS 2026Fachwissenschaftlicher Wahlpflichtbereich
WS 2026/27Fachwissenschaftlicher Wahlpflichtbereich
Industrial Engineering and Management
Industrial Engineering and Management (B. Sc.) - StuPO 2015
SS 2026Integrationsbereich › Integrationsbereich (Wahlpflicht)
WS 2026/27Integrationsbereich › Integrationsbereich (Wahlpflicht)
Information Systems Management
Information Systems Management (B. Sc.) - StuPO 2015
SS 2026Pflichtbereich
WS 2026/27Pflichtbereich › Grundlagen der Informatik
Information Systems Management
Information Systems Management (B. Sc.) - StuPO 2021
SS 2026Pflichtbereich
WS 2026/27Pflichtbereich › Grundlagen der Informatik
Information Technology (teacher training)
Kernfach StuPO 2016
SS 2026Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich
WS 2026/27Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich
Information Technology (teacher training)
Kernfach StuPO 2016
SS 2026Fachwissenschaftlicher Wahlpflichtbereich
WS 2026/27Fachwissenschaftlicher Wahlpflichtbereich
Information Technology (teacher training)
Zweitfach StuPO 2016
SS 2026Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich
WS 2026/27Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich
Information Technology (teacher training)
Zweitfach StuPO 2016
SS 2026Fachwissenschaftlicher Wahlpflichtbereich
WS 2026/27Fachwissenschaftlicher Wahlpflichtbereich
MINTgruen pre-study orientation program
MINTgruen pre-study orientation program (OS.) - Studienaufbau MINTgrün
SS 2026Wahlpflicht MINT › Module aus der Informatik
WS 2026/27Wahlpflicht MINT › Module aus der Informatik
Media Technology
Media Technology (B. Sc.) - StuPO 2018
SS 2026Wahlpflichtbereich › Katalog Medientechnik
WS 2026/27Wahlpflichtbereich › Katalog Medientechnik
Natural Sciences in the Information Society
StuPO 2018
SS 2026Wahlpflichtbereich › Informatik › Grundlagenmodule
WS 2026/27Wahlpflichtbereich › Informatik › Grundlagenmodule
Natural Sciences in the Information Society
Natural Sciences in the Information Society (B. Sc.) - StuPO 2025
SS 2026Wahlpflichtbereich › Wahlpflichtbereich Informatik › Grundlagenmodule Informatik
WS 2026/27Wahlpflichtbereich › Wahlpflichtbereich Informatik › Grundlagenmodule Informatik
Sociology and Technology Studies
StuPO 2014 (7. Mai 2014)
SS 2026Technisches Fach › Medieninformatik › Vertiefungsbereich
WS 2026/27Technisches Fach › Medieninformatik › Vertiefungsbereich

Miscellaneous

Handed-in exercise solutions can be evaluated for scientific reasons according to sec. 35 BlnDSG.