Moses - Informationssysteme und Datenanalyse

Display language

Diese Modulbeschreibung gilt nicht im aktuellen Semester.

Die Modulbeschreibung gilt nur für den Zeitraum SoSe 2022 - WiSe 2022/23. Die Version für das aktuelle Semester (SoSe 2024) finden Sie hier: Modulbeschreibung des SoSe 2024

Module / Version:
#40002 / #10

Validity:
SoSe 2022 - WiSe 2022/23

Default display language:
German

Module title:
Informationssysteme und Datenanalyse
Information Systems and Data Analysis

Credits:
6

Responsible person:
Markl, Volker

Grading:
benotet

Type of exam:
Portfolioprüfung

Zugehörigkeit

Faculty:
Fakultät IV

Institute:
Institut für Softwaretechnik und Theoretische Informatik

Area of expertise:
34351500 FG Datenbanksysteme und Informationsmanagement (DIMA)

Prüfungsausschuss:
No information

Kontakt

Office:
EN 7

Contact person:
Borusan, Alexander

E-mail address:
sekr@dima.tu-berlin.de

Website:

https://www.tu.berlin/dima

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	VZ
Informationssysteme und Datenanalyse	UE	0434 L 500	SoSe	German	2
Informationssysteme und Datenanalyse (ISDA)	VL	0434 L 500	SoSe	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 (ISDA) (VL):

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

Course-independent workload:

Workload description	Multiplier	Hours	Total
No information	2.0	22.5h	45.0h
No information	1.0	30.0h	30.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:

This module has no requirements.

Module completion

Grading

graded

Type of exam

Portfolio examination

Type of portfolio examination

100 Punkte insgesamt

Language

German

Test elements

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

Grading scale

Notenschlüssel »Notenschlüssel 1: Fak IV (1)«

Gesamtpunktzahl	1.0	1.3	1.7	2.0	2.3	2.7	3.0	3.3	3.7	4.0
100.0pt	86.0pt	82.0pt	78.0pt	74.0pt	70.0pt	66.0pt	62.0pt	58.0pt	54.0pt	50.0pt

Test description (Module completion)

No information

Duration of the Module

The following number of semesters is estimated for taking and completing the module:
1 Semester.

This module may be commenced in the following semesters:
Sommersemester.

Maximum Number of Participants

This module is not limited to a number of students.

Registration Procedures

No information

Recommended literature
Elmasri und Navathe: "Fundamentals of Database Systems", Benjamin Cummings, bzw. Deutsche Ubersetzung: “Grundlagen von Datenbanksystemen,“ Pearson, 2002
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
Özsu und P. Valduriez: "Principles of Distributed Database Systems", Prentice Hall, 1999

Assigned Degree Programs

Semester:

Zeige auch ausgelaufene Studiengänge und StuPOs

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

	Studiengang / StuPO	StuPOs	Verwendungen	Erste Verwendung	Letzte Verwendung
This module is not used in any degree program.

Miscellaneous

No information

Informationssysteme und Datenanalyse

Zugehörigkeit

Kontakt

Learning Outcomes

Content

Module Components

Pflichtteil:

Workload and Credit Points

Informationssysteme und Datenanalyse (UE):

Informationssysteme und Datenanalyse (ISDA) (VL):

Course-independent workload:

Description of Teaching and Learning Methods

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Mandatory requirements for the module test application:

Module completion

Grading

Type of exam

Type of portfolio examination

Language

Test elements

Grading scale

Notenschlüssel »Notenschlüssel 1: Fak IV (1)«

Test description (Module completion)

Duration of the Module

Maximum Number of Participants

Registration Procedures

Recommended reading, Lecture notes

Lecture notes

Electronical lecture notes

Literature

Assigned Degree Programs

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

Miscellaneous