Databases are a proven technology for managing large data sets. The oldest database model, the hierarchical database model, has been largely replaced by other models such as the relational or object-oriented data model. However, hierarchical data storage has become more important again, particularly as a result of the eXtensible Markup Language (XML). XML is a data format for representing structured, semi-structured and unstructured data and supports efficient data exchange. The consistent and reliable storage of XML documents requires the use of databases or extensions to existing database technologies. The following topics are covered in this lecture: Data model and query languages for XML, storage of XML documents, concepts of XML-oriented database systems.

Note on the form of the event:

The course Database Systems and XML will take place in WS 23/24 in a "flipped classroom" format. Videos and supporting materials will be provided for the lecture content, which students can work through independently and at their own pace. During the semester, interactive face-to-face events will take place at regular intervals in which the lecture content will be practiced and deepened.

Learning objectives:

Students

• know the basics of XML and create XML documents,
• work independently with XML database systems and use these systems specifically to solve practical problems,
• formulate queries for XML documents,
• evaluate the use of XML in business practice in different application contexts.

Workload:

The total workload for this course unit is approx. 135 hours (4.5 credit points).

• Lecture 30h
• Exercise 15h
• Preparation and follow-up of the lecture 24h
• Preparation and follow-up of the exercise 25h
• Exam preparation 40h
• Exam 1h

• M. Klettke, H. Meyer: XML & Databases: Concepts, Languages and Systems. dpunkt.verlag 2003
• H. Schöning: XML and Databases: Concepts and Systems. Carl Hanser Publishing House 2003
• W. Kazakos, A. Schmidt, P. Tomchyk: Databases and XML. Springer-Verlag 2002
• R. Elmasri, S. B. Navathe: Fundamentals of database systems. 2009
• G. Vossen: Database models, database languages and database management systems. Oldenbourg 2008

Further literature will be announced in the lecture.