Database Systems II

Understanding of the principles a DBMS relies on how is it implemented and optimised. The lecture deals with the internals of Database systems through the following topics:
  • DBMS Architecture
  • Storage Media and Hierarchy
  • DB Engineering Rules of Thumb
  • Buffer Management
  • Record, page, and file formats and organization
  • Access Paths and Indexing
  • Implementation of relational operators
  • Query Optimization
  • Transaction Models
  • Transaction Processing
  • Concurrency Control
  • Data Safety
  • Recovery
  • Cluster architectures e.g. RAC, Services, Oracle Streams

News

Written exam will be on April 1st 09:00 - 11:00 in S101/A1

There will be no oral exam!

Slides

Lecture Topic Slides
1 Slides(preliminary) Slides WS12-13
2 Mindmap of the Course Map (FreeMind Mindmap, 32KB)

Exercises

Exercise Slides Assignments
1 Orga Slides -
2 Session 1 Slides Assignment
3 Session 2 Slides Assignment
4 Session 3 Slides Assignment
5 Bonus Session Indexing Slides Assignment
6 Session 4 Slides Assignment
7 Session 5 Slides Assignment
8 Session 6 Slides Assignment
9 Session 7 Slides Assignment
10 Session 8 Slides Assignment

Papers and (online) Resources

Books

  • Haerder, Rahm, "Datenbanksysteme - Konzepte und Techniken der Implementierung", Springer 1999

Course Information

TUCaN-Link 20-00-0048-iv
Lecture Mon 14:25-16:05
in S202 | C120
Exercise Wed 11:40-13:20
in S2 02 | C120
CP (SWS) 6 (2+2)
Language English
Exam Written Exam
Office hours By Arrangement
Forum D120-DB2

Organizers

Prof. Alejandro Buchmann Robert Gottstein
A A A | Print | Contact | Legal note | Search