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 (Summersemester 2015) will be on September 8th 10:00 - 12:00 in S101/A5

Slides

Lecture Topic Slides
1 Slides(preliminary) Slides WS13-14 (22.10.14)
2 Additional Slides Flash and FBARC (10.11.14)
3 Mindmap of the Course Map (FreeMind Mindmap, 32KB)

Exercises

Exercise Slides Assignments
1 Orga Slides -
2 Session 1 Slides (22.10.14) 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 Flashed Session Slides (Part 1) NoFTL
10 Session 7 Slides Assignment
11 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 11:40-13:20
in S202 | C205
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