Jérôme Darmont

Department of Computer Science and Statistics, ICOM, Université Lumière Lyon 2, Year 2012-2013.

Prerequisites

• Knowledge of database design
• Knowledge of SQL language

Objective

Approach the issues in semi-structured data management, storage and querying.

Outline

1. Semi-structured data
2. XML language
   • Elements
   • Attributes
   • Well-formed and valid documents
   • DTD specification
   • XML Schema
3. XQuery language
   • Path expressions
   • FLWOR queries
   • Grouping XQueries
   • Join XQueries

Organization / Schedule

• Lecture (4 sessions – 7 hours): Tuesday, 2:00-3:45pm, from January 22 to February 19, except February 5, Room R001 (Jérôme Darmont)
• Labwork (8 sessions – 14 hours): Tuesday, March 5 (2:00-3:45pm), March 12 to April 2 (4:00-5:45pm), March 9 (2:00-3:45pm), March 16 (2:00-3:45pm and 4:00-5:45pm); please check room on the secretaryship’s schedule each week
  • Group #1: Jérôme Darmont
  • Group #2:
  • Group #3:

Assessment

Written exam. Tuesday May 2, 2013, 10:00am-12:00

On-line material

• Lecture’s slides (542 Ko)
• English-French lexicon (56 Ko)
• Exam 2011-2012 – text & solution (62 Ko)
• Labwork #1 (Well-formed XML documents) – text & solution (124 Ko)
• Labwork #2 (DTDs and validation) – text & solution (61 Ko)
• Labwork #3 (XML-Schemas and validation) – text & solution (65 Ko)
• Labwork #4 (XPath) – text & solution (61 Ko)
• Labwork #5 (XQuery) – text & solution (66 Ko)
• Labwork #6 (complex XQueries) – text & solution (71 Ko)
• Labwork #7 (XML management under Oracle) – text & solution (65 Ko)
• Labwork #8 (data warehouse application) – text & solution (72 Ko)
• Exam 2012-2013 – 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.0 specification, W3C
• XML Tutorial, W3Schools
• DTD Tutorial, W3Schools
• XML Schema Tutorial, W3Schools
• XQuery 1.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
• eXist online client at DIS
• SQL Developer (free Oracle client) – Connection information:
  • Connection name: your choice
  • User name: your login (the one you use in class)
  • Password: your password (still the one you use in class)
  • Host: disora.univ-lyon2.fr
  • Port: 1521
  • SID: bdetu