Department of Computer Science and Statistics, ICOM, Université Lumière Lyon 2
Year 2015-2016
Prerequisites
- Knowledge of database design
- Knowledge of SQL language
Objective
Approach the issues in semi-structured data management, storage and querying.
Outline
- Semi-structured data
- XML language
- Elements
- Attributes
- Well-formed and valid documents
- DTD specification
- XML Schema
- XQuery language
- XPath expressions
- FLWOR queries
- Grouping XQueries
- Join XQueries
Organization / Schedule
- Introduction to the flipped classroom (1 session – 1.5 hour): Thursday, January 28, 12:00am-1:30pm, Room T.B.A. (Jérôme Darmont)
- Labwork (8 sessions – 14 hours):
- Group #1: Monday, February 1, 12:00am-1:45pm; and then Thursday, 10:00-11:45am, from February 11 to April 7; Room i211 (Jérôme Darmont)
Session of March 17 rescheduled on March 25, 2pm - Group #2: Monday, February 1 and March 7, 12:00am-1:45pm; then Wednesday, 8:00-9:45am, from February 10 to April 6 except March 9; Room i212 ()
- Group #1: Monday, February 1, 12:00am-1:45pm; and then Thursday, 10:00-11:45am, from February 11 to April 7; Room i211 (Jérôme Darmont)
Exam: Tuesday, April 26, 11:00am-1:00pm, Amphi E
Assessment
Labwork reports (33%) + written exam (67%).
On-line material
- Introduction to the flipped classroom (413 Ko)
- Lecture’s slides (537 Ko)
- English-French lexicon (111 Ko)
- Labwork #1: Well-formed XML documents (65 Ko)
- Labwork #2: DTDs and validation (48 Ko)
- Labwork #3: XML-Schemas and validation (46 Ko)
- Labwork #4: XPath (49 Ko)
- Labwork #5: FLWOR XQueries (49 Ko)
- Labwork #6: Complex XQueries (48 Ko)
- Labwork #7: XML management under Oracle (51 Ko)
- Labwork #8: data warehouse application (56 Ko)
- Exam 2015-2016 – text & solution (53 Ko)
Bibliography / Webography
- Serge Abiteboul, Peter Buneman, Dan Suciu, Data on the Web: From Relations to Semistructured Data and XML, Morgan Kaufmann, 1999
- Semi-Structured Data, Peter Wood, Birkbeck University of London
- Semi-structured Data: Happy 10th Birthday!, Mike Bergman, Structured Dynamics LLC
- Introduction to Semistructured Data and XML, Raghu Ramakrishnan, University of Wisconsin Madison
- XML 1.1 specification, W3C
- XML Tutorial, W3Schools
- DTD Tutorial, W3Schools
- XML Schema Tutorial, W3Schools
- XQuery 3.0 specification, W3C
- XQuery Tutorial, W3Schools
Other on-line resources
- DTD and Schema Validator, Validome
- XML Validator, Validome
- XML Schema Validator, CoreFiling
- XML well-formedness checker and validator, Richard Tobin, University of Edimburgh
- BaseX, a free XML-native database system