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

• 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

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)

Organisation and Adaptation to the Covid Situation:

• The events announced in TISS (first class, start of a block, Q&A, summary of a block) are planned as in-peson events. if required by the Covid situation, the events will be switched to online via Zoom.
• 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) bonu exam at the end of the semesterare planned as in-person events.
• The following rules apply to all events (including the exams): date and time are fixed independently of the Covid situation. If an event cannot take place in-person as planned (e.g., if for a written exam the lecture room capacities are reduced due to the Covid situation and we do not have sufficently many lecture rooms at our disposal), then the event will be shifted to online via Zoom. It is not planned to change the date or time of any event.
• All 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.