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
TUWELLectureTube

Course evaluation

Properties

  • 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

Blocks:

  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

Immanent

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.

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
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
DayDateTimeLocationDescription
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.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Tue15:00 - 17:0025.06.2024HS 18 Czuber - MB written17.06.2024 00:00 - 23.06.2024 23:59TISSBonus Exam, Part 1
Tue15:00 - 17:0025.06.2024EI 9 Hlawka HS - ETIT written17.06.2024 00:00 - 23.06.2024 23:59TISSBonus Exam, Part 1
Tue15:00 - 17:0025.06.2024 see Bonus Exam, Part 1written17.06.2024 00:00 - 23.06.2024 23:59TISSBonus Exam, Part 2
Tue15:00 - 17:0025.06.2024 see Bonus Exam, Part 1written17.06.2024 00:00 - 23.06.2024 23:59TISSBonus Exam, Part 3
Wed16:00 - 18:0009.04.2025EI 7 Hörsaal - ETIT written28.02.2025 12:00 - 07.04.2025 23:59TISSExam Block 1
Wed16:00 - 18:0009.04.2025FH Hörsaal 1 - MWB written28.02.2025 12:00 - 07.04.2025 23:59TISSExam Block 1
Wed16:00 - 18:0007.05.2025FH Hörsaal 1 - MWB written07.04.2025 00:00 - 05.05.2025 23:59TISSExam Block 2
Wed16:00 - 18:0007.05.2025GM 1 Audi. Max.- ARCH-INF written07.04.2025 00:00 - 05.05.2025 23:59TISSExam Block 2
Tue16:00 - 18:0003.06.2025FH Hörsaal 1 - MWB written12.05.2025 00:00 - 01.06.2025 23:59TISSExam Block 3
Tue16:00 - 18:0003.06.2025EI 7 Hörsaal - ETIT written12.05.2025 00:00 - 01.06.2025 23:59TISSExam Block 3
Tue15:00 - 17:0024.06.2025HS 18 Czuber - MB written16.06.2025 00:00 - 22.06.2025 23:59TISSBonus Exam, Part 1
Tue15:00 - 17:0024.06.2025EI 9 Hlawka HS - ETIT written16.06.2025 00:00 - 22.06.2025 23:59TISSBonus Exam, Part 1
Tue15:00 - 17:0024.06.2025 see Bonus Exam, Part 1written16.06.2025 00:00 - 22.06.2025 23:59TISSBonus Exam, Part 2
Tue15:00 - 17:0024.06.2025 see Bonus Exam, Part 1written16.06.2025 00:00 - 22.06.2025 23:59TISSBonus Exam, Part 3

Course registration

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

Curricula

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

Literature

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

Language

English