Advanced Database Models
| Lecturer: | Eike Schallehn |
| SWS: | 2 V, 2 Ü |
| Target Audience: | DKEM, IF, WIF, CV |
| Time/place: | Friday 11:15-12:45, G22A-218, |
| Exercise: | Thursday 13:00 - 14:30, G22A-210, Starting April 21! |
Exams
The exams take place as oral examinations. Registration during last weeks of the lecture period. A credit / participation certificate (Schein) can be achieved by an informal oral examination after the lecture period. Exams can be taken in English or German depending on the students preferences.
Contents
The main topic of the lecture are developments in database management systems beyond the currently state of the art relational database systems. This includes among others
- historic roots such as the NF2 model,
- object-oriented models (ODMG, ODBMS),
- object-relational models (SQL99, SQL2003, ORDBMS), and
- semi-structured models (XML).
The full set of lecture slides [PDF] is here.
Excercises and Practicals
- Basic Terms and Concepts (PDF)
- Principles of DBMS and Relational Algebra (PDF, PDF)
- Conceptual Design and NF2 (PDF)
- NF2, eNF2, Type Constructors (PDF)
- Practical exercises will start on May 26 in room 29/144
- Practical Exercise on NF2/Type Constructors in G29-144 (PDF, Hints for working with Oracle in 29/144,
Oracle Documentation)
Full solution for 1st practical exercise - Practical Exercise: Object Types (PDF)
Full solution for 2nd practical exercise - Practical Exercise: References + Recursive Queris (PDF)
Full solution for 3rd practical exercise - XML, DTDs, XPath, and XQuery (PDF, XML Playground)
Official DTD for the mondial database
Full solution for 4th practical exercise
Prerequisites
A lecture comparable to the Database I or Data Management lecture held in Magdeburg is a necessary prerequisite to successfully take part in this lecture.