Information Systems and Data AnalysisModule description #40002 / Version 14
- 6 CP
- Written exam
- Graded
- Summer semester
- German
| Module / Version | #40002 / #14 |
|---|---|
| Validity | Since Summer semester 2026 |
| Available language(s) | English, German |
| Credit points | 6 |
| Person responsible for the module | Markl, Volker |
| Grading | Graded |
| Exam format | Written exam |
| Language(s) of instruction | German |
Affiliation
| Faculty | Fakultät IV |
|---|---|
| Institute | Institut für Softwaretechnik und Theoretische Informatik |
| Academic chair | 34351500 FG Datenbanksysteme und Informationsmanagement (DIMA) |
Contact
| Office | FR 7-1 |
|---|---|
| Contact person | Borusan, Alexander |
| E-mail address | sekr@dima.tu-berlin.de |
| Website | https://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
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:
Workload and credit points
Informationssysteme und Datenanalyse (Lecture)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| lecture | 15 | 2 h | 30 h |
| lecture preparation | 15 | 1 h | 15 h |
| 45 h | |||
Informationssysteme und Datenanalyse (Exercise)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| tutorial | 15 | 2 h | 30 h |
| lecture preparation | 15 | 1 h | 15 h |
| 45 h | |||
Course-independent workload
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| prerequisites | 3 | 20 h | 60 h |
| Exam preparation | 1 | 30 h | 30 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
| Grading | Graded |
|---|---|
| Exam format | Written exam |
| Language | German |
| Duration/Extent | 120 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
========================
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!
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 version | Semester(s) | Curriculum component |
|---|---|---|
| Computational Engineering Science (Informationstechnik im Maschinenwesen) StuPO 2018 | SS 2026 | 5. Ingenieurwissenschaftliche Wahlpflichtmodule › 5.5 Informationstechnik |
| WS 2026/27 | 5. Ingenieurwissenschaftliche Wahlpflichtmodule › 5.5 Informationstechnik | |
| Computer Engineering Computer Engineering (B. Sc.) - StuPO 2015 | SS 2026 | Wahlpflichtbereich › Informatik |
| WS 2026/27 | Wahlpflichtbereich › Kataloge › Medientechnik | |
| Computer Science Computer Science (B. Sc.) - StuPO 2015 | SS 2026 | Pflichtbereich |
| WS 2026/27 | Pflichtbereich › Methodisch-praktische Grundlagen der Informatik | |
| Digital Media and Technology Digital Media and Technology (B. Sc.) - StuPO 2015 | SS 2026 | Wahlpflichtbereich › Fachstudium Medientechnik |
| WS 2026/27 | Wahlpflichtbereich › Fachstudium Medientechnik | |
| Economics StuPO 2022 | SS 2026 | Compulsory Elective Area › Markets and Technology |
| WS 2026/27 | Compulsory Elective Area › Markets and Technology | |
| Electrical Engineering and Information Technology (Q-Master ET/IT, teacher training) Anlage 3 - StuPO 2016 | SS 2026 | Fachwissenschaftlicher Wahlpflichtbereich |
| WS 2026/27 | Fachwissenschaftlicher Wahlpflichtbereich | |
| Electrical Engineering and Information Technology (Q-Master ET/IT, teacher training) StuPO 2016 | SS 2026 | Fachwissenschaftlicher Wahlpflichtbereich |
| WS 2026/27 | Fachwissenschaftlicher Wahlpflichtbereich | |
| Industrial Engineering and Management Industrial Engineering and Management (B. Sc.) - StuPO 2015 | SS 2026 | Integrationsbereich › Integrationsbereich (Wahlpflicht) |
| WS 2026/27 | Integrationsbereich › Integrationsbereich (Wahlpflicht) | |
| Information Systems Management Information Systems Management (B. Sc.) - StuPO 2015 | SS 2026 | Pflichtbereich |
| WS 2026/27 | Pflichtbereich › Grundlagen der Informatik | |
| Information Systems Management Information Systems Management (B. Sc.) - StuPO 2021 | SS 2026 | Pflichtbereich |
| WS 2026/27 | Pflichtbereich › Grundlagen der Informatik | |
| Information Technology (teacher training) Kernfach StuPO 2016 | SS 2026 | Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich |
| WS 2026/27 | Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich | |
| Information Technology (teacher training) Kernfach StuPO 2016 | SS 2026 | Fachwissenschaftlicher Wahlpflichtbereich |
| WS 2026/27 | Fachwissenschaftlicher Wahlpflichtbereich | |
| Information Technology (teacher training) Zweitfach StuPO 2016 | SS 2026 | Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich |
| WS 2026/27 | Fachwissenschaft › Fachwissenschaftlicher Wahlpflichtbereich | |
| Information Technology (teacher training) Zweitfach StuPO 2016 | SS 2026 | Fachwissenschaftlicher Wahlpflichtbereich |
| WS 2026/27 | Fachwissenschaftlicher Wahlpflichtbereich | |
| MINTgruen pre-study orientation program MINTgruen pre-study orientation program (OS.) - Studienaufbau MINTgrün | SS 2026 | Wahlpflicht MINT › Module aus der Informatik |
| WS 2026/27 | Wahlpflicht MINT › Module aus der Informatik | |
| Media Technology Media Technology (B. Sc.) - StuPO 2018 | SS 2026 | Wahlpflichtbereich › Katalog Medientechnik |
| WS 2026/27 | Wahlpflichtbereich › Katalog Medientechnik | |
| Natural Sciences in the Information Society StuPO 2018 | SS 2026 | Wahlpflichtbereich › Informatik › Grundlagenmodule |
| WS 2026/27 | Wahlpflichtbereich › Informatik › Grundlagenmodule | |
| Natural Sciences in the Information Society Natural Sciences in the Information Society (B. Sc.) - StuPO 2025 | SS 2026 | Wahlpflichtbereich › Wahlpflichtbereich Informatik › Grundlagenmodule Informatik |
| WS 2026/27 | Wahlpflichtbereich › Wahlpflichtbereich Informatik › Grundlagenmodule Informatik | |
| Sociology and Technology Studies StuPO 2014 (7. Mai 2014) | SS 2026 | Technisches Fach › Medieninformatik › Vertiefungsbereich |
| WS 2026/27 | Technisches Fach › Medieninformatik › Vertiefungsbereich |
Miscellaneous
Handed-in exercise solutions can be evaluated for scientific reasons according to sec. 35 BlnDSG.