Decoration
max planck institut
informatik
mpii logo Minerva of the Max Planck Society
 

Specialized Course "Query Optimization"

Lecturer: Dr. Thomas Neumann

Content:

Query optimization is addressed shortly in Database Systems, this lecture looks at a broader topic of optimization techniques. It concentrates on the central issues like join ordering and access path selections, but givens an overview of the whole query processing machinery. The main goals of the lecture are twofold: First, to learn different optimization techniques, which are also relevant in other areas. And second, to get an understanding how queries are processed and why queries are fast or slow.

Prerequisites:

Students planning to attend the course should have some basic knowledge about information systems in general (successful participation in one of the courses Information Systems or Database Systems or Information Retrieval will be fine) and should be able to write simple programs in Java.

Organization:


Evaluation:

Information about the evaluation.

Slides:


Exercises:



Working on the exercises in a group is allowed. In this case submit one solution with all names on it. The groups can be of up to 3 people. The exercises have to be submitted in the beginning of each lecture or electronically per e-mail. However, all exercises have to be submitted with respect to the specified submission date. Late submissions will be discarded.

Tools:



Exam:

Date: 2007-02-26/27 Duration: 20 min Room: 433 Building E1.4

2007-02-26 2007-02-27
TimeName
14:15David Rudi
14:40Joachim Müller
15:05Michal Falenski
TimeName
13:15Dmytro Pancitenko
13:40Nayden Nachev


Literature: