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

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

• 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.

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.

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.

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.