Universität Wien
Warning! The directory is not yet complete and will be amended until the beginning of the term.

040310 KU Modelling and Handling of Large Databases (MA) (2022S)

6.00 ECTS (4.00 SWS), SPL 4 - Wirtschaftswissenschaften
Continuous assessment of course work
MIXED
Moodle

Registration/Deregistration

Note: The time of your registration within the registration period has no effect on the allocation of places (no first come, first served).

Details

max. 50 participants
Language: English

Lecturers

Classes (iCal) - next class is marked with N

  • Tuesday 01.03. 09:45 - 11:15 Digital
  • Wednesday 02.03. 11:30 - 13:00 Digital
  • Tuesday 08.03. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 09.03. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 15.03. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 16.03. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 22.03. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 23.03. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 29.03. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 30.03. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 05.04. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 06.04. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 26.04. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 27.04. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 03.05. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 04.05. 11:30 - 13:00 Hybride Lehre
    Seminarraum 4, Währinger Straße 29 1.UG
    Seminarraum 9, Kolingasse 14-16, OG01
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 10.05. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 11.05. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 17.05. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 18.05. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 24.05. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 25.05. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 31.05. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 01.06. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Wednesday 08.06. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 14.06. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 15.06. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 21.06. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 22.06. 11:30 - 13:00 Hybride Lehre
    Seminarraum 9, Kolingasse 14-16, OG01
  • Tuesday 28.06. 09:45 - 11:15 Hybride Lehre
    Seminarraum 18 Kolingasse 14-16, OG02
  • Wednesday 29.06. 11:30 - 13:00 Hybride Lehre
    Hörsaal 12 Oskar-Morgenstern-Platz 1 2.Stock
  • Wednesday 29.06. 15:00 - 16:30 Hybride Lehre
    Hörsaal 12 Oskar-Morgenstern-Platz 1 2.Stock

Information

Aims, contents and method of the course

The course might switch to hybrid or on-site if the situation improves.

The course introduces central methods to understand modeling and daily usage (CRUD operations) of databases and the characteristics of computer-based information systems. This knowledge will be applied to aggregate information and to facilitate and accelerate decision-making processes. Particular attention will be paid to conceptual and logical databases design, data analysis using SQL, algorithms for selecting materialized views, databases systems technology (indexes, star query optimization, physical design, query rewrite methods to use materialized views), and tools for managing a large amount of data. The student will acquire knowledge of the fundamental concepts to design and use database models. Furthermore, the student will learn to generate reports, data cubes and evaluate the performance of the modeled key processes to improve them. Beyond the relational part, we will have a look at NoSQL databases, such as Graphdatabases, Textdatabases and Document oriented databases. If there is enough time, the students will use process mining based on event-logs to model business scenarios.

This course consists of lectures, homework, and exams.

Generic goals:
- Improvement of programming skills
- Understanding of interplay in Business Administration and databases.

Assessment and permitted materials

Midterm test (35%, 4th May 2022)
Final test (35%, 29th June 2022 )
2 Homework (15% each )

Minimum requirements and assessment criteria

In total, 100 points can be achieved. Grades are assigned as follows:
1 (very good) • 100-87 %
2 (good) • 86-75 %
3 (satisfactory) • 74-63 %
4 (sufficient) • 62-50 %
5 (not enough) • 49-0 %

Examination topics

Slides and topics covered in the lectures.

Reading list

- Paulraj Ponniah, Data Warehousing Fundamentals for IT Professionals, Second Edition, Wiley
- Wil van der Aalst, Process Mining - Data Science in Action, Second Edition, Springer

Association in the course directory

Last modified: Th 11.05.2023 11:27