184.780 Advanced Database Systems
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2024S, VU, 4.0h, 6.0EC


  • Semester hours: 4.0
  • Credits: 6.0
  • Type: VU Lecture and Exercise
  • LectureTube course
  • Format: Hybrid

Learning outcomes

After successful completion of the course, students are able to

  • name basic principles of query evaluation in relational DBMS
  • to read query evaluation plans and derive measures for the improvement of the performance of queries
  • describe central „big data“ concepts, methods, and technologies using subject-specific terminology
  • use distributed data processing methods such as MapReduce and Spark
  • name basic principles of NoSQL systems
  • use various NoSQL technologies

Subject of course


  1. Evaluation and Optimization of queries on relational databases
  2. Introduction to distributed data processing techniques (with a focus on MapReduce and Spark)
  3. Basic principles of various NoSQL systems


Teaching methods

  • Recordings of the learning contents are being provided on TUWEL
  • Teaching units in presence as introduction, Q&A, and summary for each of the 3 blocks
  • Three exercises (one to each block), to which students submit solutions
  • The submitted solutions are discussed with tutors.


Mode of examination


Additional information

ECTS Breakdown:

42h   lectures + preparation for and repetition of lectures
60h   solving exercise sheets  
 2h   exercise interviews
40h   exam preparation
 6h   exam
150h (= 25h * 6ECTS)


Organisation :

  • The events announced in TISS (first class, start of a block, Q&A, summary of a block) are planned as in-peson events.These classes will also be recorded and the recordings will be provided on TUWEL.
  • The discussion of the handed in solutions to the exercises will take place online via Zoom.
  • The written exams of the 3 blocks as well as the (optional) bonus exam at the end of the semester are planned as in-person events in presumably 2 large lecture rooms. The distribution of students to the lecture rooms will be announced after the registration deadline (for the respective exam) on TUWEL.
  • Possible changes of plan will be announced on TUWEL as soon as they are known.



Course dates

Mon16:00 - 18:0004.03.2024 - 03.06.2024EI 10 Fritz Paschke HS - UIW lecture
Thu12:00 - 14:0011.04.2024 - 16.05.2024EI 3 Sahulka HS - UIW lecture
Advanced Database Systems - Single appointments
Mon04.03.202416:00 - 18:00EI 10 Fritz Paschke HS - UIW lecture
Mon11.03.202416:00 - 18:00EI 10 Fritz Paschke HS - UIW lecture
Mon08.04.202416:00 - 18:00EI 10 Fritz Paschke HS - UIW lecture
Thu11.04.202412:00 - 14:00EI 3 Sahulka HS - UIW lecture
Thu18.04.202412:00 - 14:00EI 3 Sahulka HS - UIW lecture
Thu02.05.202412:00 - 14:00EI 3 Sahulka HS - UIW lecture
Mon06.05.202416:00 - 18:00EI 10 Fritz Paschke HS - UIW lecture
Thu16.05.202412:00 - 14:00EI 3 Sahulka HS - UIW lecture
Mon03.06.202416:00 - 18:00EI 10 Fritz Paschke HS - UIW lecture

Examination modalities

The final evaluation is based on the performance at the 3 exercise sheets as well as 3 written exams. For the exercise sheets, the submission of solutions is required, which will be discussed in a meeting with a tutor. The 3 exercise sheets and written exams correspond to the 3 major blocks of the lecture (see contents of the lecture).

The individual evaluations contribute to the overall evaluation in the following proportions:

  • 20% for each of the exams
  • 15% each for exercise sheet 1 and 2
  • 10% for exercise sheet 3

A positive assessment requires at least 50% of the credits from the written exams as well as at least 50% of the total credits available.


DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Tue16:00 - 18:0004.06.2024FH Hörsaal 1 - MWB written13.05.2024 00:00 - 02.06.2024 23:59TISSExam Block 3
Tue16:00 - 18:0004.06.2024EI 7 Hörsaal - ETIT written13.05.2024 00:00 - 02.06.2024 23:59TISSExam Block 3
Tue15:00 - 17:0025.06.2024HS 18 Czuber - MB written17.06.2024 00:00 - 23.06.2024 23:59TISSBonus Exam
Tue15:00 - 17:0025.06.2024EI 9 Hlawka HS - ETIT written17.06.2024 00:00 - 23.06.2024 23:59TISSBonus Exam

Course registration

Begin End Deregistration end
12.02.2024 00:00 04.03.2024 23:59 17.03.2024 23:59


Study CodeObligationSemesterPrecon.Info
066 645 Data Science Mandatory2. Semester
066 646 Computational Science and Engineering Not specified
066 926 Business Informatics Mandatory elective
066 936 Medical Informatics Mandatory elective
066 937 Software Engineering & Internet Computing Mandatory elective


No lecture notes are available.

Previous knowledge

Database knowledge to the extent of the bachelor course "Database Systems" are absolutely necessary. Moreover, programming skills to the extent taught in the bachelor course "Introduction to Programming 1"  are also assumed.

Preceding courses