Lecture "Relational Database Systems 2"

Information
Classification: 
Master (Informatik / Wirtschaftsinformatik)
Credits: 
5
Exam: 
oral
Regular Dates: 
Wednesdays, 12:15 – 14:45
IZ 161
First lecture on April, 5
Contents
Contents: 

Oral Exams:

As of now, appointments for the oral exams can be made.

Available dates are:

27.07.

07.-11.08.

Please contact our secretary Regine Dalkiran soon to get your individual slot. The exams will be 25-30 minutes each.

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!

Which pre-requisites are there?

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

 

Schedule

  Date Topic Slides Exercises Videos Comments
1 05.04.2017 System Architecture Lecture 1   Video 1  
2 12.04.2017 Physical Data Storage Lecture 2   Video 2 (video from last year)  
3 19.04.2017 Indexing and Access Paths Lecture 3   Video 3 (video from last year)  
4 26.04.2017 Trees and Advanced Indexes Lecture 4
  •  
Video 4  
5 03.05.2017 Query Processing Lecture 5   Video 5  
6 10.05.2017 Query Optimization 1 Lecture 6   Video 6  
7 17.05.2017 Query Optimization 2 Lecture 7
  •   
Video 7  
8 24.05.2017 Query Optimization 3 Lecture 8   Video 8  
9 31.05.2017 Transaction Processing 1 Lecture 9   Video 9  
  07.06.2017 Exkursionswoche         
10 14.06.2017 Transaction Processing 2 Lecture 10   Video 10  
11 21.06.2017 Recovery Lecture 11   Video 11  
12 28.06.2017 Security Lecture 12   Video 12  
13 05.07.2017 Privacy Lecture 13   Video 13  
14 12.07.2017 Beyond Relational Databases       Not relevant for the exams.