Lecture "Relational Database Systems 2"

Information
Classification: 
Master (Informatik / Wirtschaftsinformatik)
Credits: 
5
Regular Dates: 
Donnerstag, 9:45 - 12:15 in IZ 160
Erster Termin: 11.04.2019
Contents
Contents: 

What is the focus?

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

What 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!

Pre-requisites:

  • No special requirements. However, successful participation in Relational Databases 1 is highly recommended.
Materials

  Date Topic Slides Exercises Videos Comments
1 11.04.2019 System Architecture Lecture 1   Video 1  
2 18.04.2019 Physical Data Storage Lecture 2   Video 2  
3 25.04.2019 Indexing and Access Paths Lecture 3   Video 3  
4 02.05.2019 Trees and Advanced Indexes Lecture 4   Video 4  
5 09.05.2019 Query Processing Lecture 5   Video 5  
6 16.05.2019 Query Optimization 1 Lecture 6   Video 6  
7 23.05.2019 Query Optimization 2 Lecture 7   Video 7  
  30.05.2019 Christi Himmelfahrt        
8 06.06.2019 Query Optimization 3 Lecture 8   Video 8  
  13.06.2019 Exkursionswoche         
9 20.06.2019 Transaction Processing 1 Lecture 9   Video 9  
10 27.06.2019 Transaction Processing 2 Lecture 10   Video 10  
11 04.07.2019 Recovery Lecture 11   Video 11 Video from 2017
12 11.07.2019 Security Lecture 12   Video 12  
13 18.07.2019 Privacy & Beyond Relational Databases Lecture 13   Video 13