Jump label

Service navigation

Main navigation

You are here:

Main content

Basic Module "Architecture & Implementation of DBMS"

Organization

Lecturer

  • Prof. Dr. Jens Teubner

Schedule (Lecture)

  • Mondays, 8-10h, OH12/E.003
  • Wednesdays, 10-12h, OH12/E.003

Schedule (Exercises)

  • TBA

This course will be taught in English.

Description

Database systems form the heart of virtually any enterprise application. They manage vast amounts of data, yet allow for fast and efficient search; they handle tousands of updates every second, yet won't trip over problems due to concurrency; and guarantee consistency and data integrity even in the case of catastrophic events (loss of hardware, etc.).

In this course we learn how database systems can provide this service and performance. We will look “under the hoods” and understand how a database is built internally. We will get to see techniques that allow to construct a system in a scalable and robust manner.

More specifically, our agenda includes: space management (buffer manager), index structures (single- and multi-dimensional), query processing (e.g., external sorting, join processing), query optimization, concurrency control (e.g., two-phase locking), failure tolerance (ARIES), distributed database systems.

Exam Dates

There will be a 90-minute exam for this course (two chances to participate).

  • Thursday, July 18, 2019; 14:30h-16:00h; Room HG2/HS5
  • Friday, September 27, 2019; 13:30-15:00h; Room HG2/HS5

Allowed material for the exam: one piece of DIN A4 paper, hand-written (both sides, if you want); pocket calculator.

News

Dec 29, 2018

Web page set up.

Material

Lecture Slides

Lecture slides will be made available for download here.

Exercises

Exercise-related material will be made available for download here.



Sub content

Contact

Prof. Dr. Jens Teubner
Tel.: 0231 755-6481