XML and Databases (MSc/6+)

Lecturer: Dr. Can Türker

Summary: Today, the W3C standard XML is widely used as document format for exchanging data over the Internet. While the generation of XML data is easy, the management of XML data requires systems that are able to efficiently store, query, and process XML data. With other words, database technology is required for handling XML data. The goal of this lecture is to teach the interplay between XML and databases. The following aspects are studied in detail: semi-structured data model of XML, query languages (XPath, XQuery) for declarative access to XML data, XML processor technologies, mapping between XML and databases including efficient storage and index structures for XML data. A further central concern of this lecture is to show the practical relevance of all presented concepts by demonstrating how they are realized in major database management systems such as Oracle, IBM DB2, Microsoft SQL Server, and PostgreSQL.

Goal: Achieve deep understanding of XML and its interplay with database technology

Prerequisite: Databases (Bachelor level), i.e., basic knowledge in databases

Recommended: MSc Studies

Examination: 14.06.2018, 08:00-09:30, AND-3-02/06, Andreasstrasse 15, 8050 Zürich (Hint: Room changed!)

Credit Points: 3

Date: Thursday 08:15-09:45 BIN 2.A.10 Universität Zürich Nord, Binzmühlestrasse 14

Starts: 22.02.2018

Schedule:

Week Date Topic Slides Demos
8 22.02.2018 Intro and Motivation 01-Intro (PDF, 1292 KB) 01-Intro-Demo (ZIP, 4 KB)
9 01.03.2018 XML & DTD 02-XML (PDF, 874 KB) 02-XML-Demo (ZIP, 5 KB)
10 08.03.2018 XML Schema & XML Processors 03-XML-Processors (PDF, 2252 KB) 03-XML-Processors-Demo (ZIP, 66 KB)
11 15.03.2018 XML Processors & XML Query Languages 04-XML-Query-Languages (PDF, 2126 KB) 04-XML-Query-Languages-Demo (ZIP, 17 KB)
12 22.03.2018 XML Query Languages    
13 29.03.2018 XML Query Languages    
14 05.04.2018 No lecture!    

15

12.04.2018

Mapping between XML and Databases

05-Mapping-XML-to-DBMS (PDF, 593 KB)

05-Mapping-XML-to-DBMS-Demo (ZIP, 7 KB)

16

19.04.2018

Mapping between XML and Databases

06-Mapping-DBMS-to-XML (PDF, 355 KB) 06-Mapping-DBMS-to-XML-Demo (ZIP, 1 KB)
17 26.04.2018 SQL/XML 07-SQL/XML (PDF, 567 KB) 07-SQL/XML-Demo (ZIP, 4 KB)
18 03.05.2018 No lecture!    
19 10.05.2018 No lecture!    
20 17.05.2018 No lecture!  

 

21 24.05.2018 XML Indexing & XML Updates 

08-XML-Indexing (PDF, 435 KB) 

09-XML-Updates (PDF, 199 KB)

09-XML-Updates-Demo (ZIP, 1 KB)
22 31.05.2018 XML Support in Database Systems

10-Systems (PDF, 1331 KB)

10-Systems-Demo (ZIP, 36 KB)
24 14.06.2018 Examination    

Tools:

  • BASEX (Open source XML tool supporting XPath/XQuery 3.0 and Query Update Facility 1.0): http://basex.org

 

​Student Assistant Positions Available! Students-Assistant-Job-Announcement (PDF, 382 KB)

  • Web Application Programming on the J2EE Platform
  • Become a member of the B-Fabric Development Team: http://fgcz-bfabric.uzh.ch/wiki
  • Work time flexible; fulltime possible during semester holidays

If interested, send your CV to tuerker@fgcz.ethz.ch.