 |
|
||||||||||
XML and Databases
News
[2.2.2007] Exam results available (n.ethz username+password required)
- [18.12.2006] Survey on the topics for remaining lecture open
- [14.12.2006] Please download the latest version of the mxquery engine from the project bundle in the project page.
- [08.12.2006] Information on the Project is available here. The project is compulsory.
OLD:
- Registration in exercise groups is closed. The distribution in exercise groups is available here.
- The location of the lecture has changed: HG D 16.2 instead of CAB G 61
Content
XML is becoming increasingly important in the IT industry. It is conceived as the silver bullet for archiving of data, meta-data management, and data integration. The expectations are high; at the same time, XML is also the source for a great deal of confusion. XML is more than just a syntax with angle brackets. There are a number of standards that are based on XML and a growing number of products that support various versions of these standrads.
This lecture gives an overview of the most important XML technologies. A strong emphasis is on architecture and optimization techniques that show how XML can be implemented efficiently in database products and applications. The goal of this lecture is to learn about the basics to implement XML technology reliably and efficiently in various different application contexts. Specifically, this lecture will cover the following topics:
1. XML Revisited: XML, XML Schema, XQuery Data Model, XQuery, SQL/X
2. XQuery Implementation Techniques: Optimization + Transaction Management
3. XML Storage Techniques
4. Web Services
5. XL and XUpdate
6. XML Information Retrieval (keyword search, ranking); integration into query processing; XQuery Text
7. Yfilter; information filtering, publish & subscribe; RSS
8. Semantic Web (RDF, OWL)
Goal
State-of-the XML processing techniques.
Lecture Notes
Lecture Notes will be made available on each Tuesday preceding a lecture
| 0. Overview | (1/1) | (6/1) |
| 1. Motivation | (1/1) | (6/1) |
| 2. XML Basics | (1/1) | (6/6) |
| 3. XML Processing - Part 1: Overview | (1/1) | (6/1) |
| XML Processing - Part 2: XQuery (updated) | (1/1) | (6/1) |
| XML Processing - Part 3: XUpdate - corrected version | (1/1) | (6/1) |
| 4. XQuery Implementation - Part 1: Overview/Compiler Optimizations | (1/1) | (6/1) |
| XQuery Implementation - Part 2: Data Storage | (1/1) | (6/1) |
| 5. SQL/XML | (1/1) | (6/1) |
| 6. Programming XML | (1/1) | (6/1) |
| 7. XQueryP | (1/1) | (6/1) |
Lecture Podcast
A preliminary version of the lecture podcast is available at the ETH podcast portal
Exercise Sheets
Exercise sheets will be made available in the week before they are discussed in the exercise groups. Exercises are not mandatory, but highly recommended to prepare for the exam
The first exercise groups will take in the third week (6.11.-10.11.)
| 1. XML Data Modelling |
Exercise Sheet 1 Supporting Files (.zip) |
Solution 1 Supporting Files (.zip) |
| 2. DTD, Infoset, XML Validation | Exercise Sheet 2 | Solution 2 |
| 3. XQuery (1) |
Exercise Sheet 3 Supporting Files (.zip) |
Solution 3 |
| 4.XQuery (2) | Exercise Sheet 4 | Solution 4 |
| 5. XQuery Update | Exercise Sheet 5 | Solution 5 |
| 6. Implementation and Optimization | Exercise Sheet 6 |
Solution 6 Query Plan Query 2 |
| 7. XML Storage. XML in Relational Databases |
Exercise Sheet 7 Supporting Files(.zip) |
Solution 7 |
| 8.XML/SQL | Exercise Sheet 8 | Solution 8 |
| 9. Programming XML | Exercise Sheet 9 | Solution 9 |
| 10. Exercise Sheet 10 | Exercise Sheet 10 |
Project
There is a mandatory semester project. It is due in the third week of January (15.1-19.1) 2007. Information and project requirements can be found here.
Project information will be made available later in the semester
Exam
There will be an exam at the end of the semester.
Date & Time: 31.1.2007, 13:15
Location: ML D 28
Lecturer
Teaching Assistant
Class Schedule
Language
English
Requirements
ISG (Grundlagen von Datenbanken und SQL), ISK is helpful, but it can be taken in parallel.
Literature
Will be announced in class.
URL
Wichtiger Hinweis:
Diese Website wird in älteren Versionen von Netscape ohne
graphische Elemente dargestellt. Die Funktionalität der
Website ist aber trotzdem gewährleistet. Wenn Sie diese
Website regelmässig benutzen, empfehlen wir Ihnen, auf
Ihrem Computer einen aktuellen Browser zu installieren. Weitere
Informationen finden Sie auf
folgender
Seite.
Important Note:
The content in this site is accessible to any browser or
Internet device, however, some graphics will display correctly
only in the newer versions of Netscape. To get the most out of
our site we suggest you upgrade to a newer browser.
More
information
