Oral Exams

EXAMS WILL BE IN THE IFIS LIBRARY (between room IZ216 and room IZ219)

Time slots for oral exams can be allocated in the weeks  25.-29. July 2011; and 19.-23. September 2011. Please contact Regine Dalkiran for an exam apointment.

RDB 2

In contrast to Relational Databases 1, this lecture will focus on how to implement a relational database. All major challenges are discussed and different solutions are presented.

The focus will be on

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

What you 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.
• It is a Masters course. Bachelor students may attend the lecture according to their examination regulations.