Lecture "Relational Database Systems 2"

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

Oral Exams:

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

Available dates are: July 20-22, August 1, 2, 4

August 26 and September 1-2 are fully booked (No time-slots available anymore).

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 06.04.2016 System Architecture Lecture 1   Video 1  
2 13.04.2016 Physical Data Storage Lecture 2   Video 2  
3 20.04.2016 Indexing and Access Paths Lecture 3   Video 3  
4 27.04.2016 Trees and Advanced Indexes Lecture 4
  •  
Video 4 (video from last year)  
5 04.05.2016 Query Processing Lecture 5   Video 5  
6 11.05.2016 Query Optimization 1 Lecture 6   Video 6  
  18.05.2016 Exkursionswoche   
  •   
   
7 25.05.2016 Query Optimization 2 Lecture 7   Video 7  
8 01.06.2016 Query Optimization 3 Lecture 8   Video 8  
9 08.06.2016 Transaction Processing 1 Lecture 9   Video 9  
10 15.06.2016 Transaction Processing 2 Lecture 10   Video 10  
11 22.06.2016 Recovery Lecture 11   Video 11  
12 29.06.2016 Security Lecture 12   Video 12  
13 06.07.2016 Privacy Lecture 13   Video 13  
14 13.07.2016 Beyond Relational Databases Lecture 14     Not relevant for the exams.

AttachmentDateSize
File 03-Indexing.mp422/04/16 5:09 pm369.16 MB
File 06-Query-Optimization.mp411/05/16 5:33 pm353.97 MB
File 07-Query-Optimization-2.mp425/05/16 4:37 pm280.87 MB
File Query_Optimization_03.mp402/06/16 10:44 am308.54 MB
File 09-Transaction-Processing-01.mp408/06/16 4:05 pm385.02 MB
File 10-Transaction-Processing-02.mp415/06/16 5:13 pm328.95 MB
File 11-Recovery.mp422/06/16 6:47 pm316.97 MB
File 12-Security.mp429/06/16 5:12 pm272.09 MB
File 13-Data-Privacy.mp406/07/16 4:40 pm356.69 MB