Advanced Database Models
prac4.txt Organization
| Lecturer: | Dr. Eike Schallehn |
| Lecture: | LSF-Entry |
| Exercise: | LSF-Entry |
Exam requirements
- The exam will take place as a written exam. Registration using the LSF/HISQUIS system is required according to the general procedures.
News
- Because of the Covid-19 situation this year's lecture will use the Moodle system and ALL RELEVANT INFORMATION will be available here:
https://elearning.ovgu.de/course/view.php?id=7645 - Material on this site will not be maintained and may be outdated
Lecture and Exercise Materials
Lecture handouts will be made available here over the course of the lecture.
Advanced Database Models (PDF slides) adbm.pdf
Exercise sheets will be made available here over the course of the lecture.
- Basic Terms and Concepts [PDF]
- Principles of Databases [PDF]
- Relational Algebra
- Conceptual Design
- NF2
- NF2 with Oracle
Some guidelines for working with Oracle can be found here.
prac1Solution - Object-relational with Oracle
prac2Solution - Recursive Queries and Methods
prac3Soluition - XML, DTDs, XPath and XQuery
Use http://www.semwebtech.org/xquery-demo/ for the XPath and XQuery tasks.
prac4Solution
Old Exams
As an orientation for upcoming exams, an old exam paper can be found here.
The focal points can be found here .
Literature
Literature references and recommended readings are listed in the lecture handouts.