Beginning XML Databases (Wrox Beginning Guides)

Chapter 1: What is XML?

Figure 1-1: A simple sample HTML page

Figure 1-2: XSL can be used to apply templates to XML documents.

Figure 1-3: A simple sample XML page

Figure 1-4: Creating a simple XML document

Figure 1-5: Using the XML tag to embed XML data islands into an HTML page

Figure 1-6: Creating a simple HTML page containing an XML data island

Figure 1-7: Using XML element attributes to change the display of an XML document

Figure 1-8: HTML embeds the code and is less flexible than XML.

Figure 1-9: Adding attributes to elements in an XML document

Chapter 2: The XML Document Object Model

Figure 2-1: The XML DOM object hierarchical structure

Figure 2-2: The XML DOM class hierarchical structure

Figure 2-3: The most significant XML DOM classes

Figure 2-4: The XML DOM Node class attributes and methods that are inherited by child classes within the XML DOM

Figure 2-5: The XML DOM NodeList class is an array or collection of nodes within an XML document.

Figure 2-6: Working with the XML DOM Node class

Figure 2-7: The XML DOM Document class

Figure 2-8: Viewing an XML document in a browser shows a clear picture of hierarchical structure

Figure 2-9: Using JavaScript and the XML DOM to view an XML document

Figure 2-10: The XML DOM Element class contains all the tags in an XML document.

Figure 2-11: Using JavaScript and the XML DOM to view XML document elements

Figure 2-12: The XML DOM Attr (attribute) class has no inherited attributes or methods.

Figure 2-13: Using JavaScript and the XML DOM to view an XML documents element attributes

Figure 2-14: The XML DOM Text class contains values between tag elements.

Figure 2-15: Using JavaScript and the XML DOM to view an XML documents element text values

Figure 2-16: The XML DOM parseError class can contain error details.

Figure 2-17: Using the parseError class

Figure 2-18: The XML DOM HTTPRequest class passes data between XML documents and the server.

Figure 2-19: Using the HTTPRequest class

Figure 2-20: The results of a processed ASP script

Chapter 3: Extending the Power of XML with XSL

Figure 3-1: The XSL elements

Figure 3-2: An XML document containing commentary , within cities, within states, within countries

Figure 3-3: A single xsl:template finds all text values within the first matched node

Figure 3-4: A single xsl:template finds all element text values within the entire XML document

Figure 3-5: Applying multiple xsl:template elements using the xsl:apply-templates elements

Figure 3-6: xsl:template and xsl:apply-template elements apply varying formats

Figure 3-7: An XML document containing continental and country populations

Figure 3-8: An XML document containing an HTML form input field

Figure 3-9: An XML document using the xls:if element

Figure 3-10: An XML document using the xls:choose, xls:when, and xls: otherwise elements 73

Figure 3-11: Countries and their populations

Figure 3-12: Parsing using the current() function is the same as .

Figure 3-13: Parsing pattern matching options for XSL

Figure 3-14: Applying XSL to the XML DOM, using ASP on a web server

Chapter 4: Relational Database Tables and XML

Figure 4-1: Generating a single-layer XML document using SQL

Figure 4-2: Generating a multiple-layer XML document using SQL

Chapter 6: SQL Server and XML

Figure 6-1: Creating a SQL Server table including an XML data type field

Figure 6-2: Untyped versus typed XML data type fields

Figure 6-3: A table containing an XML data type

Figure 6-4: A single table query

Figure 6-5: OPENXML converts from XML to relational tuples

Chapter 7: XML in Heterogeneous Environments

Figure 7-1: Including SOAP namespace commands in an XML document

Figure 7-2: The W3C website soap-envelope namespace definition

Figure 7-3: Calling a function in a SOAP script

Figure 7-4: Calling a function from a namespace

Figure 7-5: Create a simple message in an HTML page.

Figure 7-6: Create a simple SOAP message in an HTML page.

Figure 7-7: Send a simple SOAP message to ASP and back.

Figure 7-8: Transferring data using XSL transformations

Chapter 8: Understanding XML Documents as Objects

Figure 8-1: The different hierarchical layers in an XML document

Figure 8-2: Enhancing the relational model shown in Figure B-1

Figure 8-3: Converting the enhanced relational model of Figure 8-2 to an object model

Figure 8-4: A properly structured multiple-layered hierarchical XML document

Figure 8-5: A poorly structured, single-layered XML document, sharing starting and editing records only

Figure 8-6: Another poorly structured, single-layered XML document

Figure 8-7: Another properly structured, multiple-layered XML document

Chapter 9: What Is a Native XML Database?

Figure 9-1: A single-layered XML document

Figure 9-2: Converting a single-layered XML document to a single relational table

Figure 9-3: A properly structured, multiple-layered, hierarchical XML document

Figure 9-4: Using indexing reduces I/O activity

Figure 9-5: Indexing allows fast scanning using specialized index structures and scanning algorithms.

Chapter 10: Navigating XML Documents Using XPath

Figure 10-1: XPath syntax defines various different node types.

Figure 10-2: Isolating a dataset in the demographics XML document

Figure 10-3: Basic XPath expressions

Figure 10-4: Using XPath basic expressions

Figure 10-5: Using XPath basic expressions

Figure 10-6: Available XPath operators

Figure 10-7: Using XPath predicates

Figure 10-8: Using wildcards in XPath

Figure 10-9: Using wildcards in XPath

Figure 10-10: Concatenating two expression results in XPath

Figure 10-11: XPath axes on the current node

Figure 10-12: Applying XPath axes

Figure 10-13: XPath accessor functions

Figure 10-14: XPath error and trace functions

Figure 10-15: XPath constructor functions (data type definitions)

Figure 10-16: XPath numeric functions

Figure 10-17: XPath numeric operators

Figure 10-18: XPath string functions

Figure 10-19: XPath Boolean functions

Figure 10-20: XPath Boolean operators

Figure 10-21: XPath duration, date, and time functions

Figure 10-22: XPath duration, date, and time operators

Figure 10-23: XPath duration arithmetic functions

Figure 10-24: XPath duration, date, and time arithmetic functions

Figure 10-25: XPath qualified name (QName) functions

Figure 10-26: XPath node functions

Figure 10-27: XPath sequence functions

Figure 10-28: XPath sequence functions by example

Figure 10-29: XPath context functions

Figure 10-30: Using some simple XPath context functions

Figure 10-31: Try It Out simple XPath expression syntax

Chapter 11: Reading XML Documents Using XQuery

Figure 11-1: Executing the Saxon XQuery command processor

Figure 11-2: Executing the Saxon .NET post-installation samples

Figure 11-3: Executing an HTML page in a browser

Figure 11-4: Adding a list iterator to a for loop

Figure 11-5: XQuery terminology

Figure 11-6: Using only the for and return clauses in a FLWOR XQuery statement

Figure 11-7: An FLWOR XQuery statement without using HTML

Figure 11-8: An FLWOR XQuery statement without using HTML

Figure 11-9: Adding XML tags using the return clause

Figure 11-10: Substituting a where clause for a for clause predicate

Figure 11-11: Using an FLWOR order by clause

Figure 11-12: Sorting with multiple values in an FLWOR for loop

Figure 11-13: The let clause sets variables for subsequent use in a query.

Figure 11-14: For loops can be embedded and values can be passed between the loops

Figure 11-15: Cross-joins with multiple for loops

Figure 11-16: Using the SQL*Plus XQUERY command

Chapter 12: Some Advanced XML Standards

Figure 12-1: Simple XLinks in a browser

Figure 12-2: The basics of XLink attributes

Figure 12-3: Adding more XLink attributes

Figure 12-4: Adding links with XLink

Figure 12-5: Getting XLink links to function in Internet Explorer 6

Figure 12-6: More advanced XLink attribute details

Figure 12-7: More advanced XLink attribute details

Figure 12-8: Splitting a database by metadata structure is logically visible.

Figure 12-9: Splitting a database by data is physically visible.

Figure 12-10: Demographics data shows multiple links for both data and metadata.

Figure 12-11: Demographics data is split into separate XML documents for each region.

Figure 12-12: Basic XML interpretation of XLink

Figure 12-13: Adding labels within labels using XLink

Figure 12-14: Connect data elements in XLink using arcs.

Figure 12-15: XLink can refine links between multiple XML documents.

Figure 12-16: Further refinement of XLinks between multiple XML documents

Figure 12-17: And yet further refinement of XLinks between multiple XML documents

Figure 12-18: Demographics is split into separate regional XML documents for each region.

Figure 12-19: A snapshot of different parts of the Africa.xml document

Figure 12-20: Using XPointer in Internet Explorer

Figure 12-21: Executing XForms in Internet Explorer

Chapter 13: Data Modeling and XML

Figure 13-1: Validating an XML document with a DTD

Figure 13-2: Mixed content can contain both text values (PCDATA) and subset elements.

Figure 13-3: Zero or more elements on a single parent element

Figure 13-4: Zero or more elements on a collection of elements

Figure 13-5: DTD attributes can be defined as various different types.

Figure 13-6: DTD attributes can be defaulted to various different settings.

Figure 13-7: Elements and attributes can be verified using DTD definitions.

Figure 13-8: Adding and referencing custom entity values

Figure 13-9: Using entity parameters to remove DTD scripting duplication

Figure 13-10: simpleType declaration restriction facets (constraints)

Chapter 14: Applying XML Databases in Industry

Figure 14-1: XML vocabularies for applications and specific industries

Figure 14-2: The elements of MathML (Mathematics XML)

Figure 14-3: The basic elements of MathML

Figure 14-4: A news feed XML website

Figure 14-5: A news feed using an industry-specific XML vocabulary

Figure 14-6: A NASA-based web page for AIML (Astronomical Instrument Markup Language)

Figure 14-7: An example AIML vocabulary document

Appendix B: The Sample Database

Figure B-1: The logical Entity Relationship Diagram (ERD) for the demographics schema

Figure B-2: The physical Entity Relationship Diagram (ERD) for the demographics schema

Figure B-3: The XML object model for the demographics schema

Appendix E: XML Relational Database Technology

Figure E-1: The various stages of development of XML capabilities, in various databases. All timing aspects are directly related to when this book was written. This appendix was added in mid-May, 2006.

Figure E-2: Loading large XML documents into DB2 is a little problematic .