Chapter 26 xml and Internet Databases Outline

FIGURE 26.5 (continued) An XML schema file called company

XML Documents and Databases

• Approaches to Storing XML Documents
• Extracting XML Documents from Relational Databases
• Breaking Cycles to Convert Graphs into Trees
• Other Steps for Extracting XML Documents from Databases

FIGURE 26.6 An ER schema diagram for a simplified UNIVERSITY database.

FIGURE 26.7 Subset of the UNIVERSITY database schema needed for XML document extraction.

FIGURE 26.8 Hierarchical (tree) view with COURSE as the root.

FIGURE 26.9 XML schema document with COURSE as the root.

FIGURE 26.10 Hierarchical (tree) view with STUDENT as the root.

FIGURE 26.11 XML schema document with STUDENT as the root.

FIGURE 26.12 Hierarchical (tree) view with SECTION as the root.

FIGURE 26.13 Converting a graph with cycles into a hierarchical (tree) structure.

XML Query

• XPath: Specifying Path Expressions in XML
• XQuery: Specifying Queries in XML

FIGURE 26.14 Some examples of XPath expressions on XML documents that follow the XML schema file COMPANY in Figure 26.5

FIGURE 26.15 Some examples of XQuery queries on XML documents that follow the XML schema file COMPANY in Figure 26.5.

Summary

• XML documents
• XML & databases