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.

2021S, VU, 4.0h, 6.0EC
TUWEL

Properties

  • Semester hours: 4.0
  • Credits: 6.0
  • Type: VU Lecture and Exercise
  • Format: Distance Learning

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

  • Lectures
  • Three exercises (one to each block), which are worked on in groups
  • Before each exercise interview, we offer sessions with tutors for any questions regarding the exercise

Due to the COVID-19 crisis, this course will be held on-line using the
TUWEL platform. At the beginning of each block the students will receive videos of lectures of the block. Exercises will be managed using TUWEL. The exercise discussions with tutors will be held online using Zoom. A discussion forum on TUWEL will be used to answer student questions and to clarify issues.For each block we also offer a zoom meeting for questions and answers.

Exams are held via zoom, answers are written on paper and uploaded to TUWEL at the end of the exam time. If it becomes possible to safely hold exams in-person again and if sufficienct lecture room capacities are available, we will try to hold in-person exams in lecture rooms. The layout of the exams will remain the same.

Infrastructure requirements at the student site

  • A room for yourself
    You should not be talking with any other people for the duration of the exam.
  • A webcam (or any device with a camera that can run Zoom)
    The webcam needs to be placed so that it can show you and your workplace, including
    the paper you write on, as well as the printed out sheet for the exam.
  • A printer OR a second electronic device
    You either print the exam, or use a second device (laptop, tablet, monitor, etc.) to
    display the PDF. You may not interact with this device, other than navigating the PDF.

Mode of examination

Immanent

Additional information

ECTS Breakdown:

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

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Mon15:00 - 17:0001.03.2021 online, Zoom link: https://tuwien.zoom.us/j/97521645787?pwd=M0Y2ZWpTNnlITjhscUJocGM1Z2tiZz09 (LIVE)first class, start of block 1
Mon15:00 - 17:0015.03.2021 online, link will be provided in TUWEL (LIVE)Questions & Answers concerning block 1
Fri15:00 - 17:0026.03.2021 online, link will be provided in TUWEL (LIVE)Summary of block 1, start of block 2
Mon15:00 - 17:0019.04.2021 online, link will be provided in TUWELQuestions & Answers concerning block 2
Fri15:00 - 17:0030.04.2021 online, link will be provided in TUWEL (LIVE)Summary of block 2, start of block 3
Mon15:00 - 17:0017.05.2021 online, link will be provided in TUWEL (LIVE)Questions & Answers concerning block 3
Fri15:00 - 17:0028.05.2021 online, link will be provided in TUWEL (LIVE)Summary of block 3

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

In the summer term 2021, the written exams will presumably be organized remotely:

  • students participate in the exam via Zoom
  • the exam questions will be provided via TUWEL
  • the exam is  "open book"
  • no electronic devices other than calculators are allowed
  • at the end, students upload their solutions as a single PDF file via TUWEL

If the Covid-situation allows and the lecture hall capacities are available, the written exams may be shifted to lecture halls. Neither date nor format of the exams are thus affected.

Further details concerning the exams are provided on TUWEL.

 

 

Course registration

Begin End Deregistration end
29.01.2021 00:00 28.02.2021 23:59 03.03.2021 23:59

Curricula

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