Semistructured Data and XML
Summer 2019
Prof. Dr. Wolfgang May
Lars Runge, M.Sc.,
Sebastian Schrage, M.Sc.
Date and Time:
- Monday 14-16 ct, IFI SR 2.101
- Wednesday 10-12 ct, IFI SR 2.101
Lecture and Exercises mixed (see announcements on this page). There will be non-mandatory
exercise sheets whose solutions will be discussed as parts of the lecture.
Module M.Inf.1141, 4 SWS, 6 ECTS.
The module's home is the MSc studies in
Applied CS. It can also be credited in the BSc studies in Applied CS
(as "Vertiefung Softwaresysteme und Daten"),
and in several other studies:
BSc/MSc Wirtschaftsinformatik, Mathematik (BSc/MSc), Teaching/2-Fach-Bachelor, PhD GAUSS, ...
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 XPath/XQuery/XSLT Web interface is available
here.
The sample code fragments can be found in the CIP pool under
/afs/informatik.uni-goettingen.de/course/xml-lecture/
.
Dates & Topics
- 15.4.2019 NO LECTURE - note: 16:00h MSc introductory meeting with the Dean of Studies (room IFI 0.101).
- 17.4.:
Administrativa, Overview, ...
Introductory Presentation "XML"
[Slides]
- 24.4.:
General concepts and notions of the database area.
Slides: Relational Model
- 29.4.:
General concepts and notions of the database area.
Slides: Relational Model
Earlier database models, concepts and extensions:
Basic Concepts and Notions; example and recall: relational model.
Slides: data models
- 1.5.: Holiday. No lecture.
- 6.5.: Earlier database models, concepts and extensions:
Network data model, ...
Smartboard notes
- Some references to read about database history (optional):
- 8.5.: "History" continued: ... ODMG and ... academic prototypes: SchemaSQL
Smartboard notes
- 13.5.: "History" continued - academic prototypes: early semistructured data models (Tsimmis/OEM/F-Logic)
Slides: early semistructured data models
No Smartboard notes today - the Smartboard is broken.
- 15.5.: XML: data model, language, DTDs etc.
Slides: XML basics
No Smartboard notes today - the Smartboard is broken.
- from now on, the Monday lecture takes place in SR -1.101 because the Smartboard in
2.101 is dead. Wednesday lectures will still take place in 2.101 (-1.101 is not available)
- 20.5. (in -1.101)
XML: data model, language, DTDs etc. (cont'd)
Smartboard notes
- 22.5. (in 2.101): XML: data model, language, DTDs etc. (cont'd)
Exercise Sheet 1
(XML basics, parsing, grammar aspects) -
solutions will be discussed during the subsequent lectures.
No Smartboard notes today.
- 27.5. (in -1.101) XML, XPath: navigation and addressing language for XML
Slides: XPath
Smartboard notes
- 29.5.: Discussion of Exercise Sheet 1; XPath (cont'd)
Solutions to Exercise Sheet 1
- 3.6.: XPath (cont'd)
Exercise Sheet 2
Smartboard notes
- 5.6.: XPath (cont'd)
- 10.6. NO LECTURE (Holiday)
- 12.6.: Lecture
XML Query Languages: History/Evolution - XQL, XML-QL; then XQuery
Slides: XQuery
Smartboard notes
- 17.6.: (The lecture takes place again in 2.101)
XML Query Languages (cont'd)
Solutions to Exercise Sheet 2
- 19.6.: XQuery (cont'd)
Exercise Sheet 3 (XQuery)
Smartboard notes
- 24.6.: XQuery (cont'd)
- 26.6.: XQuery (cont'd)
- The slots for oral exams have been fixed, see below
(will appear in FlexNow in the next days)
- 1.7.: XML Query Languages (cont'd), XSLT
Slides: XSLT
- 3.7.: XSLT
Exercise Sheet 4 (XSLT)
- Announcement:
Praktikum/Lab course XML WS2019/20
- Announcement:
Semantic Web WS2019/20
- 8.7.: XSLT
Smartboard notes
- 10.7.: XSLT, Overview of XML Schema
Slides: XML Schema
(note: the XML Schema atomic datatypes are also used in the RDF data model)
Smartboard notes
- 10.7. 14-16h, SR 2.101 (optional, belonging to the SQL lab course): XML in SQL/SQLX
Slides: XML and Databases
SQL Web interface (in addition to the
Mondial tables, the tables mondial, countryXML, cityXML used on the slides exist)
- 15.7. Discussion of Exercise Sheet 3 (XQuery)
Solutions to Exercise Sheet 3 (corrected 15.7. evening),
Smartboard notes
- 17.7. Discussion of Exercise Sheet 4 (XQuery/XSLT);
Solutions to Exercise Sheet 4
XMLSchema (cont'd),
Smartboard notes
Note: the rest of the slide set belongs to the XML lab course
which takes place in the winter term 2019/2020.
- 19.7.2019 End of lecture period.
Exams
- Oral exams (in german or in english), between July and October 2019, to choose between several slots.
- Exam period in July: 18.-31.7.
- Exam period in Aug/Sept: 22.8.-17.9.
- Exam period in October: 14.10.-1.11. (Winter term lectures start on Oct. 21)
- Note: FlexNow lists only the first day(!) of each of the slots. The system is not well-prepared
for the existence of oral exams.
- Please contact may at informatik.uni-goettingen.de for the individual
appointments/slots. You should express your preference what day + morning/afternoon and/or
what dates are not possible for you.
- The exams take place in my office, Room 2.107, Inst.f.Informatik.
- The written exams from previous years are also a good preparation (hmm... they are only
available in German, but still give some overview what they looked like):
|
