Navigation To modulepage
Display language

Informationssysteme und Datenanalyse
Information Systems and Data Analysis

6 LP

German

#40002 / #9

Seit SS 2020

Fakultät IV

EN 7

Institut für Softwaretechnik und Theoretische Informatik

34351500 FG Datenbanksysteme und Informationsmanagement

Markl, Volker

Borusan, Alexander

sekr@dima.tu-berlin.de

POS-Nummer PORD-Nummer Modultitel
6440 32384 Informationssysteme und Datenanalyse

Learning Outcomes

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. Upon completion of this course, students will have: (i) mastered basic concepts in information management and relational database management systems (RDBMS), (ii) learned how to develop information models, and (iii) grasped how to formulate queries in relational algebra and express these in SQL. They will be able to describe a data warehouse, compare it to transaction systems, and decide which requirements are essential for a given application profile. Furthermore, they will learn about data analytics using classification & clustering algorithms and apply them to a database using SQL and Java.

Content

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

Module Components

Pflichtteil:

All Courses are mandatory.

Course Name Type Number Cycle Language SWS
Informationssysteme und Datenanalyse UE 0434 L 500 SS German 2
Informationssysteme und Datenanalyse VL 0434 L 500 SS German 2

Workload and Credit Points

Informationssysteme und Datenanalyse (UE):

Workload description Multiplier Hours Total
No information 15.0 2.0h 30.0h
No information 15.0 2.0h 30.0h
60.0h(~2 LP)

Informationssysteme und Datenanalyse (VL):

Workload description Multiplier Hours Total
No information 15.0 2.0h 30.0h
No information 15.0 1.0h 15.0h
45.0h(~2 LP)

Course-independent workload:

Workload description Multiplier Hours Total
No information 1.0 30.0h 30.0h
No information 2.0 22.5h 45.0h
75.0h(~3 LP)
The Workload of the module sums up to 180.0 Hours. Therefore the module contains 6 Credits.

Description of Teaching and Learning Methods

No information

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

No information

Mandatory requirements for the module test application:

No information

Module completion

Grading:

graded

Type of exam:

Portfolio examination

Language:

German

Typ of portfolio examination

100 points in total

Test elements

Name Points Categorie Duration/Extent
No information 40 written No information
No information 40 written No information
No information 20 practical No information

Grading scale

1.01.31.72.02.32.73.03.33.74.0
86.082.078.074.070.066.062.058.054.050.0

Test description (Module completion)

No information

Duration of the Module

This module can be completed in one semester.

Maximum Number of Participants

This module is not limited to a number of students.

Registration Procedures

No information

Recommended reading, Lecture notes

Lecture notes

Availability:  unavailable

Electronical lecture notes

Availability:  unavailable

Literature

Recommended literature
Elmasri und Navathe: "Fundamentals of Database Systems", Benjamin Cummings, bzw. Deutsche Ubersetzung: “Grundlagen von Datenbanksystemen,“ Pearson, 2002
Garcia-Molina, Ullman, Widom: “Database Systems: The Complete Book,” Prentice Hall, 2000
Kemper, Eickler: “Datenbanksysteme – Eine Einführung,” Oldenburg, 5. Auflage 2004
Özsu und P. Valduriez: "Principles of Distributed Database Systems", Prentice Hall, 1999

Assigned Degree Programs

Zur Zeit wird die Datenstruktur umgestellt. Aus technischen Gründen wird die Verwendung des Moduls während des Umstellungsprozesses in zwei Listen angezeigt.

This module is used in the following modulelists:

This module is used in the following Degree Programs (new System):

    Miscellaneous

    No information