Lecture "Relational Database Systems 2"

Master Informatik / Wirtschaftsinformatik
Regular Dates: 
Friday: 15:00 - 17:15
Room IZ251

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.
Date Topic Slides Video Exercise Comment
25.04.2014 System Architecture Slides Video NO EXERCISE  
02.05.2014 Physical Data Storage Slides Video Exercise  
09.05.2014 Indexing and Access Paths Slides Exercise, Lecture Exercise  
16.05.2014 Trees and Advanced Indexes Slides Exercise, Lecture Exercise  
23.05.2014 Query Processing Slides No sound =>
Lecture from SS12
30.05.2014 Query Optimization Slides Technical issues =>
Lecture from SS12
06.06.2014 Query Optimization II Slides Exercise,
13.06.2014 (Exkursionswoche)        
20.06.2014 NO CLASS      
ACHTUNG: Die heutige (20.06.14) Vorlesung muss aus organisatorischen Gründen leider ausfallen!
27.06.2014 Query Optimization III Slides Lecture NO EXERCISE  
04.07.2014 Transaction Processing Slides Lecture Exercise  
11.07.2014 Transaction Processing II Slides Exercise, Lecture Exercise  
18.07.2014 Recovery Slides Exercise, Lecture NO EXERCISE    
25.07.2014 Security Slides Lecture NO EXERCISE