Native XML Databases in Information Systems

Chris Wallace April 2006

Facilities

The Student servers

(with links to the XQuery Sandbox, The Java Client and Documentation)

 

New server http://studentexistdb.cems.uwe.ac.uk:8080/exist/index.xml

 

Last years server

stocks http://stocks.cems.uwe.ac.uk:8081/exist/index.xml

 

Learning

XPath

Trees  ppt

XSLT

Intro to XML and XSLT ppt

XQuery

Introduction to XQuery  ppt

Worksheet 1 doc  - lessons learnt

Native XML Databases and eXist

Intro to XML and NDX ppt

Introduction to FOLD  ppt

Some notes

 

Worked Examples

 

Spreadsheet of all in-progress case studies xls

 

My externally visible examples:   http://www.cems.uwe.ac.uk/chriswallace/index.xql

 

Internal Teaching Examples

 

Projects

The FOLD (Faculty OnLine Data) project

 

Presentations and Papers

Information Systems Research seminar (22 February  2006)

Presentation ppt

SMRG Research seminar (23 February 2006)

Presentation ppt

SPA2006 (27-29 March 2006)

Workshop overview in Word and HTML

Background Paper for the workshop session in Word  and HTML

XML Prague (17-18 June 2006)

Presentation  PPT

Teaching, learning and Assessment of Databases workshop TLAD06 (17th July 2006)

Teaching XML database with eXist doc

References

R. Bourret(2006). XML and Databases http://www.rpbourret.com/xml/XMLDatabaseProds.htm [accessed 23 April 2006].

Akmal B. Chaudri, Awais Rashid, Roberto Zicari (Eds.): XML Data Management: Native XML and XML-Enabled Database Systems. ISBN: 0-201-84452-4. Published by Addison Wesley Professional, March, 2003.

D. Hunter et al (2004) Beginning XML(3rd edition) Wrox, Wiley

 

M. Kay (2004) XPath for Programmers, Wrox, Wiley

 

M. Kay (2006) Building XML Workflow Applications http://www.stylusstudio.com/xml/workflow.html  (Accessed 23 April 2006)

 

J. King (2005) The case for XQuery, XML-Journal. Nov 2005 (http://xml.sys-con.com/read/155663.htm Accessed 23 April 2006)

Wolfgang Meier. eXist: An Open Source Native XML Database. In: Akmal B. Chaudri, Mario Jeckle, Erhard Rahm, Rainer Unland (Eds.): Web, Web-Services, and Database Systems. NODe 2002 Web- and Database-Related Workshops, Erfurt, Germany, October 2002. Springer LNCS Series, 2593. Available at http://exist-db.org/webdb.pdf  [accessed 15/2/2006]

Matthew Reed (2005) XML Information Services in archaeological Excavation  University of Kent Undergraduate Report

http://www.cs.kent.ac.uk/pubs/ug/2005/co620/xmldig/report.pdf  [accessed 15/2/2006].

 

Links
eXist

   Home: http://exist-db.org

   Documentation:   http://exist.sourceforge.net/documentation.html

   Discussion Board:  http://news.gmane.org/gmane.text.xml.exist

   IRC : http://demo.exist-db.org/irclog/irclog.xql

 

 

XSLT

  w3schools Tutorial: http://www.w3schools.com/xsl/default.asp

  EXSLT  http://www.exslt.org/

 

 

XQuery

   w3schools Tutorial:  http://www.w3schools.com/xquery/default.asp

   XQuery Primer http://www.softwareag.com/xml/tools/xquery_primer.pdf

 

   XQuery  http://www.w3.org/TR/xquery/

   XQuery Use cases http://www.w3.org/TR/xquery-use-cases/

   XPath 2.0 and XQuery 1.0 Functions and Operators http://www.w3.org/TR/xquery-operators/

 

   XPath 2.0 and XQuery 1.0 Data model  http://www.w3.org/TR/xpath-datamodel/

  

 

XSD

  XSD schema validation

              This one is simple to use by pasting in the XSD and XML.  Diagnostics however are limited.

 http://www.xmlme.com/Validator.aspx 

 

              This is a good validator for XSD and XML separately but I'm having trouble validating XML against a specific XSD.

                                    http://apps.gotdotnet.com/xmltools/xsdvalidator/ 

 

  XSD scheme inference:  http://apps.gotdotnet.com/xmltools/xsdinference/default.aspx

 

 

Case Tools

  QSEE MultiCase tool:  http://www.qsee-technologies.com/

 

Company Sites

 

Software AG http://www.softwareag.com/xml/

Saxonica  http://www.saxonica.com/

O'reilly XML http://www.xml.com/

 

Conferences

Extreme Markup – papers  http://www.mulberrytech.com/Extreme/Proceedings/

XTech05  http://www.idealliance.org/proceedings/xtech05/

XML Summer School http://www.xmlsummerschool.com/index.htm

XML Prague http://www.xmlprague.cz/index.html

 

People

Ronald Bourret http://www.rpbourret.com/

Michael Kay   blog