Database Management and Tuning

Lecturer: Nikolaus Augsten
Teaching assistant: Nikolaus Augsten
Teaching language:English
Prerequisites: Introduction to Programming, Introduction to Databases, Database Management Systems, Data Structures and Algorithms
Office hours: Tuesday 10:45–12:15 (March 1–May 24)
Additional office hours: Wed June 15, 10:00–12:00 (office 2.19)
Academic Year 2010 / 2011, 2nd Semester
Home | General | Lecture Notes | Exercises | Exam

General

Course evaluation by students 2009/2010 [PDF] and 2010/2011 [PDF]

Start date: March 1, 2010
Lectures: Tuesday 8:30-10:30, room E411
Labs: Tuesday 14:00-15:00, room E531

Lecture notes: The lecture notes for this course will be published as we progress through the semester. There is a set of lecture notes for each topic.

Reading: Database Tuning - Principles, Experiments, and Troubleshooting Techniques. Dennis Shasha, Philippe Bonnet. Morgan Kaufmann Publishers, 2003.

Exercise: The exercise part of this course consists in the elaboration of assignments and contributes with up to 6/30 points to the final grade.

See also: Course Presentation Form

Lecture Notes

The lecture notes for this course will be published as we progress through the semester. There is a set of lecture notes for each topic.
Date Topics Slides
1. Tue 2011-03-01 General Introduction: Introduction, Tuning Principles, Course Organization [1up] [4up]
2. Tue 2011-03-08 Query Tuning: Query Processing, Tuning Examples [1up] [4up]
3. Tue 2011-03-15 Query Tuning: Minimizing DISTINCTs, Unnesting Queries; Index Tuning: Query Types [1up] [4up]
4. Tue 2011-03-22 Index Tuning: Index Types [1up] [4up]
5. Tue 2011-03-29 Index Tuning: Data Structures, Composite Indexes [1up] [4up]
6. Tue 2011-04-05 Index Tuning: Indexes and Joins [1up] [4up]
7. Tue 2011-04-12 Index Tuning: Tuning Examples; Concurrency Tuning: Introduction to Transactions [1up] [4up]
8. Tue 2011-04-19 Concurrency Tuning: Lock Tuning [1up] [4up]
9. Tue 2011-04-26 Concurrency Tuning: Weaken Isolation Guarantees [1up] [4up]
10. Tue 2011-05-03 Concurrency Tuning: Transaction Chopping [1up] [4up]
11. Tue 2011-05-10 Recovery Tuning: Log, WAL Buffer, Checkpoints [1up] [4up]
12. Tue 2011-05-17 Tuning the Storage Subsystem [1up] [4up]

Literature

The following text book covers most topics of the course:

If a topic is not covered by the above reference, this will explicitly be metioned. These topics are then covered by

Both text books can be found in our library.

Exercises

The exercise part of the course consists in the elaboration of assignments. The assignments must be handed in on the due date at the beginning of the lab. Late assignements will not be considered - no exception.
Assignment Due Date Max Grade Downloads
1. [PDF] 2011-03-15, 14:00
1
 DBLP data
2. [PDF] 2011-03-29, 14:00
1
3. [PDF] 2011-04-05, 14:00
1
4. [PDF] 2011-04-19, 14:00
1
 DBLP data
5. [PDF] 2011-05-03, 14:00
1
 Java demo
6. [PDF] 2011-05-17, 14:00
1

Exam

The assessment is either based on the assignments and the final oral exam or on the final oral exam only. The final oral exam follows the standard grading system, i.e., 30 is the highest grade and 18 is lowest passing grade. The assignments can contribute with up to 6 grading points to the final grade. The grading points from the assignments are valid for all three regular exam sessions. There is no midterm.