Prof. Dr. Wolfgang May
Assistants: Oliver Fritzen, Franz Schenk

Date and Time: Wednesday 10-12 ct, Thursday 14-16 ct, MN67.
Lecture and Exercises/Lab mixed (see announcements on this page)

Module CS.M.inf.320.
The module's home is the MSc studies in Applied CS. It can also be credited in the BSc studies in Applied CS, and in several other studies:
6 ECTS credits (Studies in Applied Informatics and in BSc Wirtschaftsinformatik),
Diplom Wirtschaftsinformatik: 4 WiInf-credits, (elective/"Wahlbereich" Informatik).
Maths (Dipl, MSc), Teaching, Magister, PhD GAUSS, ...

Note: the Modulkatalog/Studienordnung requires that participants have successfully attended the module "Databases".

Course Description

One of the most important facts that lead to the overall success of XML is that the "XML world" combines a lot of already known concepts in an optimal way for coping with a broad spectrum of requirements. The course will first review some of these preceding (partially even historic) concepts (network database model, relational databases, object-oriented databases) and the integration of data and metadata (SchemaSQL). Then, the idea of "semistructured data" is introduced by showing early representatives that helped to shape the XML world (F-Logic, OEM).

In the main part, XML is presented as a data model and a markup-meta-language, and the current languages of the concepts of the XML world are systematically investigated and applied: DTD, XPath, XQuery, XSLT, XLink, XML Schema, and SQL/XML.

The lecture uses the geographical sample database "Mondial" in its XML version for illustrations.

For practical exercises, the XML software is installed in the IFI CIP Pool. The software playground page can be found here.
The sample code fragments can be found in the pool under /afs/informatik.uni-goettingen.de/course/xml-lecture/ .

Dates & Topics

• 16.4.: Administrativa, Overview, Introductory Presentation "XML".
  [Slides 2-on-1] [Slides 4-on-1]
• 17.4.: General Concepts and Notions of the database area.
  Slides: Relational Model
  
• 23.4.: Earlier database models, concepts and extensions: Basic Concepts and Notions; example and recall: relational model. Slides: early DB concepts
• 24.4.: Earlier database models, concepts and extensions: Network data model, Relational Model
• Some references to read about database history (optionally):
  • The developers of RDBMS and SQL look back in 1995.
  • Funding a Revolution (relevant here: Chapter 6 "The Rise of Relational Databases").
  • A Survey (1991) of the development of database technology, including an outlook ... to today: Database Systems: Achievements and Opportunities. A. Silberschatz, M. Stonebraker, J. Ullman, Comm. of the ACM, Oct. 1991.
• 30.4.: "History" continued: Object-Oriented Model
• 1.5.: Feiertag.
• 7.5.: "History" continued: Schema SQL, early semistructured data models.
  Slides: early semistructured data models
• 8.5.: "History" continued: early semistructured data models.
• 14.5.: "History" continued: early semistructured data models.
• 15.5.: XML: data model, language, DTDs etc.
  Slides: XML basics
• 21.5.: XML: data model, language, DTDs etc. (cont'd)
  Exercise sheet 1: XML & DTD (PostScript, PDF)
• 22.5.: XML: data model, language, DTDs etc. (cont'd)
• 28.5.: XPath: navigation and addressing language for XML
  Slides: XPath
• 29.5.: XPath (Cont'd)
  Exercise sheet 2: XPath (PostScript | PDF)
• 4.6..: Discussion of Exercise sheet 1, solution [postscript, pdf] ; XPath (Cont'd).
• 5.6.: Discussion of Exercise 2.4.
  XPath (Cont'd)
• 11.6.: Discussion of Exercise Sheet 2,
  solution [postscript, pdf];
  sample XML document fragment for Ex.4
• 12.6. The query language: XQuery
  Slides: XQuery
  Exercise sheet 3: XQuery (PostScript | PDF)
• 18.6. XQuery (Cont'd),
• 19.6. XQuery (Cont'd), Updating XML Data (same slide set as XQuery)
• 25.6. Discussion of sample solutions for XQuery Exercises [postscript, pdf]
• 26.6. The transformation language: XSLT
  Slides: XSLT
  Exercise sheet 4: XSLT (PostScript | PDF)
• 1.7. XSLT (Cont'd).
• 2.7. XSLT (Cont'd),
  XML Schema
  Slides: XML Schema
• 9.7. Discussion of Exercise Sheet 4 (XSLT)
  Solution [postscript, pdf]
• 10.7. XML Schema (Cont'd),
  Overview: Global referencing in XML - the linking languages: XPointer and XLink
  Slides: XLink
  Overview: Programming XML with Java APIs
  Slides: DOM/SAX,
  Literature etc.
• Klausur: Mittwoch, 16.Juli, 10:00-12:00, MN 67, Dauer 90 min.
• Keine Vorlesung am 17.7.
• 18.7. [Freitag!] 10-12, MN67: Optional, gemeinsam mit Praktikum SQL: SQL&XML: Der SQLX Standard in Oracle
  Folien
• Additional material on XML Databases
  Slides: XML and Databases
  Further information on XML & DB can e.g. be found here:
  • Some articles about the SQL/XML Standard
  • XML und Datenbanken; H. Schöning; Hanser-Verlag, 2003
  • XML Data Management: Native XML and XML-Enabled Database Systems; Akmal Chaudhri, Awais Rashid, Roberto Zicari; Addison Wesley, 2003
• Ergebnis der Vorlesungsevaluierung

Klausur:

• Mittwoch, 16.Juli, 10:00-12:00, MN 67, Dauer 90 min.

Klausurergebnis

• Klausurergebnis
  Notenspiegel
  Bestanden ab 44 Punkten, danach in 4er-Schritten. 1.0 ab 80 Punkten.
• Klausur mit Musterlösung
• Klausur ohne Musterlösung
• Klausureinsicht: Dienstag, 22.7. 14-16 Uhr in meinem Büro. Ansonsten naechste Woche ggf einfach vorbeikommen und schauen ob ich da bin (so etwa 10-12 und 13:30-17) oder per Mail Termin ausmachen.
• Noten und Scheine: Die Noten wurden an die Prüfungsämter gemeldet.
  Teilnehmer, die die Prüfung bestanden haben, können sich ausserdem einen Schein in Papierform bei Frau Jachinke (bis Mitte September IFI, Raum 01.122 - ab Mitte September im Neubau im Nordcampus) vormittags abholen.