Module Number:
| 13839
|
Module Title: | Advanced Database Models |
|
Erweiterte Datenbankmodelle
|
Department: |
Faculty 1 - Mathematics, Computer Science, Physics, Electrical Engineering and Information Technology
|
Responsible Staff Member: | -
Prof. Dr.-Ing. habil. Schmitt, Ingo
|
Language of Teaching / Examination: | English |
Duration: | 1 semester |
Frequency of Offer: |
Every summer semester
|
Credits: |
6
|
Learning Outcome: | Students understand
- SQL:2003,
- object-relational and object-oriented database model,
- XML-queries,
- spatial data and queries.
|
Contents: | For special applications from the areas of manufacturing and science classical relational database modelling basing on table structures is not adequate. Alternatively, several new database models and technologies were developed. The course covers SQL:2003, ODMG and XML. Focus is on data modelling and query techniques as well as implementation of behaviour in form of methods. Further focus is on spatial data and queries for geographical information systems. Acquired knowledge will be applied within a project. |
Recommended Prerequisites: | The module cannot be successfully completed without knowledge of the content of
|
Mandatory Prerequisites: | None |
Forms of Teaching and Proportion: | -
Lecture
/ 2 Hours per Week per Semester
-
Exercise
/ 1 Hours per Week per Semester
-
Laboratory training
/ 1 Hours per Week per Semester
-
Self organised studies
/ 120 Hours
|
Teaching Materials and Literature: | - "SQL:1999 & SQL:2003" von Can Türker, dpunkt.verlag, 2003
- "Objektrelationale Datenbanken: Ein Lehrbuch" von Can Türker und Gunter Saake, Punkt.verlag 2006
|
Module Examination: | Prerequisite + Final Module Examination (MAP) |
Assessment Mode for Module Examination: | Prerequisite:
- successful completion in practical training tasks and in exercises tasks
Final module examination:
- Written examination, 90 min. OR
- Oral examination, 30-45 min. (with small number of participants)
In the first lecture it will announced, whether the examination will organized in written or oral form. |
Evaluation of Module Examination: | Performance Verification – graded |
Limited Number of Participants: | 80 |
Part of the Study Programme: | -
Master (research-oriented) /
Artificial Intelligence /
PO 2022
-
Master (research-oriented) /
eBusiness /
PO 2007
-
Abschluss im Ausland /
Elektrotechnik /
keine PO
-
Abschluss im Ausland /
Informatik /
keine PO
-
Master (research-oriented) /
Künstliche Intelligenz Technologie /
PO 2022
-
Abschluss im Ausland /
Mathematik /
keine PO
|
Remarks: | - Study programme Informatik B.Sc.: Compulsory elective module in complex "Praktische Informatik" (level 300).
- Study programme Informations- und Medientechnik M.Sc.: Compulsory elective module in complex "Multimedia-Systeme"
- Study programme Artificial Intelligence M.Sc.: Compulsory elective module in complex „Knowledge Acquisition, Representation, and Processing“
- Study programme Künstliche Intelligenz Technologie M.Sc.: Compulsory elective module in complex “Software-basierte Systeme“
|
Module Components: | - Lecture: Advanced Data Models
- Accompanying exercises (with integrated laboratory)
- Related examination
|
Components to be offered in the Current Semester: | |