Vorlesung "Relational Database Systems 2"

Information
Classification: 
Studiengänge der Informatik und Wirtschaftsinformatik (Diplom, Master), Wahlpflicht
Credits: 
4
Exam: 
Please contact Ms. Dalkiran for an exam appointment. Exams will take place within the last week of July.
Regular Dates: 
Tuesdays 13:15h-15:30h, Hörsaal MP 23.3 (Mühlenpfordtstraße 23, Raum 160)
Contents
Contents: 

System ArchitectureStorage TechnologiesPhyical ImplementationBasic Query ProcessingQuery OptimizationTransaction ControlAccess ControlDisaster Recovery

 

Summary: 

This lecture is especially focused on implementation aspects of relational database systems.

Materials

Note

Please note that you need 50% of all exercise points to be admitted for the final exams. Exercises have to be turned in next Tuesday of the next week before the lecture and may be completed in teams of two students each.   
Please hand in your solutions on paper into the mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2nd floor). Please do not forget your name and  “Matrikelnummer” on your solutions.

 

Download

Date Topic Slides Exercise Video Recordings
08.04.2008 System Architecture Slides
Print Slides
Exercise 1 N/A
15.04.2008 Storage Hardware and Media Slides
Print Slides
Exercise 2 N/A
22.04.2008 Indexing Slides
Print Slides
Exercise 3 N/A
29.04.2008 Tree Structures Slides
Print Slides
Exercise 4 Video
06.05.2008 Query Processing Slides
Print Slides
Exercise 5 Video
20.05.2008 Query Optimization Slides
Print Slides
Exercise 6 Video
27.05.2008 Advanced Query Optimization Slides
Print Slides
Exercise 7 N/A
03.06.2008 Join Order Optimization Slides
Print Slides
N/A N/A
10.06.2008 Transactions Slides
Print Slides
Exercise 9 Video
17.06.2008 More Transactions Slides
Print Slides
Exercise 10 Video
24.06.2008 Recovery Slides
Print Slides
Exercise 11 Video
01.07.2008 Security Slides
Print Slides
Exercise 12 N/A
08.07.2008 Beyond Relational Databases Slides
Print Slides
Exercise 13 N/A
15.07.2008 More things beyond Relational Databases Slides
Print Slides
N/A Video

 

Current Exercise Statu

MatNo % Points
2870609 92.07%
2907488 55.35%
2911717 85.79%
2912198 93.73%
2921147 75.46%
2921150 75.46%
2921396 38.38%
2864644 56.83%
2861294 64.21%
2869487 77.86%
2869474 77.86%