Lecture “Relational Database Systems 2”

Master Informatik / Wirtschaftsinformatik
4 or 5 (depending on course of study and exam regulations)
Regular Dates: 
Friday: 15:00 - 17:15
Room 358


Als Prüfungstermine bieten wir den 15.07., 17.07. und 18.07. an. Meldungen für die Prüfungen bitte bei Frau Dalkiran im Sekretariat des IFIS in Raum 236.

The focus will be on

  •       basic architecture of relational databases
  •       index structures
  •       query processing
  •       query optimization
  •       transaction management
  •       data security
  •       non-standard Implementations


What you will you learn? Which questions are answered?

  • How to build a relational DB?
  • How does query processing work?
  • Why do index structures speed up queries? Which index structures are there? What are their advantages / disadvantages? Which one to use?
  • Why did we burden students with relational algebra in RDB1 when there is SQL?
  • How does relational algebra help in query optimization?
  • Which optimization paradigms are there? How do they work?
  • Why do database administrators get paid that well?
  • What is transaction management for? What has to be done to implement it? What alternatives are there?
  • How can you ensure that data is not lost?
  • How to harded you DB againt power outages, fires, or earthquakes?
  • How else can I implement a relational database?
  • ... and many more!

Which pre-requisites are there?

  • No special requirements. However, successful participation in Relational Databases 1 is highly recommended.
  • It is a Masters course. Bachelor students may attend the lecture according to their examination regulations.
Date Topic Slides Comment
05.04.2013 System Architecture Slides  
12.04.2013 Physical Data Storage Slides  
19.04.2013 Indexing and Access Paths Slides  
26.04.2013 Trees and Advanced Indexes Slides  
03.05.2013 Query Processing Slides  
10.05.2013 Query Optimization Slides  
17.05.2013 Query Optimization II Slides  
31.05.2013 Query Optimization III Slides  
07.06.2013 Transaction Processing Slides  
14.06.2013     Die Vorlesung fällt leider aus.
21.06.2013 Transaction Processing II Slides  
28.06.2013 Recovery Slides  
05.07.2013 Security Slides  

File RDB2_01_SystemArchitecture.pdf08/04/13 12:01 pm2.73 MB
File RDB2_02_Storage.pdf11/04/13 9:53 am9.17 MB
File RDB2_03_Indexing.pdf18/04/13 12:21 pm4.59 MB
File RDB2_04_Trees.pdf02/05/13 10:18 am6.23 MB
File RDB2_05_Query Processing.pdf02/05/13 10:19 am6.32 MB
File RDB2_06_QueryOpt1.pdf14/05/13 12:33 pm5.57 MB
File RDB2_07_QueryOpt2.pdf14/05/13 12:34 pm5.35 MB
File RDB2_08_QueryOpt3.pdf30/05/13 11:18 pm5.78 MB
File RDB2_09_Transactions1.pdf06/06/13 11:57 am4.92 MB
File RDB2_10_Transactions2.pdf20/06/13 11:07 am6.74 MB
File RDB2_11_Recovery.pdf27/06/13 1:59 pm5.71 MB
File RDB2_12_Security.pdf04/07/13 3:48 pm5.72 MB