Universität Wien FIND

Due to the COVID-19 pandemic, changes to courses and exams may be necessary at short notice (e.g. cancellation of on-site teaching and conversion to online exams). Register for courses/exams via u:space, find out about the current status on u:find and on the moodle learning platform. NOTE: Courses where at least one unit is on-site are currently marked "on-site" in u:find.

Further information about on-site teaching and access tests can be found at https://studieren.univie.ac.at/en/info.

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) (2021S)

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

Registration/Deregistration

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

Details

max. 50 participants
Language: English

Lecturers

Classes (iCal) - next class is marked with N

This course will be completely digital. Webcam and microphone are recommended for participation.

Tuesday 02.03. 09:45 - 11:15 Digital
Wednesday 03.03. 11:30 - 13:00 Digital
Tuesday 09.03. 09:45 - 11:15 Digital
Wednesday 10.03. 11:30 - 13:00 Digital
Tuesday 16.03. 09:45 - 11:15 Digital
Wednesday 17.03. 11:30 - 13:00 Digital
Tuesday 23.03. 09:45 - 11:15 Digital
Wednesday 24.03. 11:30 - 13:00 Digital
Tuesday 13.04. 09:45 - 11:15 Digital
Wednesday 14.04. 11:30 - 13:00 Digital
Tuesday 20.04. 09:45 - 11:15 Digital
Wednesday 21.04. 11:30 - 13:00 Digital
Tuesday 27.04. 09:45 - 11:15 Digital
Wednesday 28.04. 11:30 - 13:00 Digital
Tuesday 04.05. 09:45 - 11:15 Digital
Wednesday 05.05. 11:30 - 13:00 Digital
Tuesday 11.05. 09:45 - 11:15 Digital
Wednesday 12.05. 11:30 - 13:00 Digital
Tuesday 18.05. 09:45 - 11:15 Digital
Wednesday 19.05. 11:30 - 13:00 Digital
Wednesday 26.05. 11:30 - 13:00 Digital
Tuesday 01.06. 09:45 - 11:15 Digital
Wednesday 02.06. 11:30 - 13:00 Digital
Tuesday 08.06. 09:45 - 11:15 Digital
Wednesday 09.06. 11:30 - 13:00 Digital
Tuesday 15.06. 09:45 - 11:15 Digital
Wednesday 16.06. 11:30 - 13:00 Digital
Tuesday 22.06. 09:45 - 11:15 Digital
Wednesday 23.06. 11:30 - 13:00 Digital
Tuesday 29.06. 09:45 - 11:15 Digital
Wednesday 30.06. 11:30 - 13:00 Digital

Information

Aims, contents and method of the course

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 project presentations. Students will work on their projects in interdisciplinary groups.

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

Assessment and permitted materials

Midterm test (30%, 5th May 2021)
Final test (20%, 30th June 2021 )
Pen and Paper homework (10%, during the second part)
Project Work (40%, ongoing work )

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: We 21.04.2021 11:25