The aim of the course is to impart an understanding of:

• basic principles of query evaluation and query optimization of relational database queries (in SQL),
• foundations of distributed data processing techniques: in particular MapReduce (in Hadoop) and Spark,
• concepts of modern non-relational Database Systems  (NoSQL - Not Only SQL) .

Note: This course does not serve as an introduction to relational database systems, and the contents of the course 184.686 Data Base Systems serve as a prerequisite to this course (especially the use of SQL and relational algebra)

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

Mode:

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