Lecture "Relational Database Systems 2"

Information
Classification: 
Master (Informatik / Wirtschaftsinformatik)
Credits: 
5
Exam: 
oral (30 minutes)
Regular Dates: 
Wednesdays, 12:15 Uhr – 14:45 Uhr
Room IZ 161

Oral Exams

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

Available dates are: August 5+6, August 19-21, and September 14-17.

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

Summary

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.

Schedule

  Date Topic Slides Exercises Videos Comments
1 15.04.2015 System Architecture Slides 1   Video 1  
2 22.04.2015 Physical Data Storage Slides 2   Video 2  
3 29.04.2015 Indexing and Access Paths Slides 3   Video 3  
4 06.05.2015 Trees and Advanced Indexes Slides 4
  •  
Video 4  
5 13.05.2015 Query Processing Slides 5   Video 5  
6 20.05.2015 Query Optimization 1 Slides 6   Video 6  
  27.05.2015 Exkursionswoche   
  •   
   
7 03.06.2015 Query Optimization 2 Slides 7   Video 7  
8 10.06.2015 Query Optimization 3 Slides 8   Video 8  
9 17.06.2015 Transaction Processing 1 Slides 9   Video 9  
10 24.06.2015 Transaction Processing 2 Slides 10   Video 10  
11 01.07.2015 Recovery Slides 11   Video 11  
12 08.07.2015 Security Slides 12   Video 12  
13 15.07.2015 Beyond Relational Databases Slides 13   Video 13  
  22.07.2015 No lecture