List of Figures

1-1 Oracle XML DB Architecture: XMLType Storage and Repository

1-2 Oracle XML DB: XMLType Storage and Retrieval Architecture

1-3 Oracle XML DB Repository Architecture

1-4 Microsoft Web Folder View of Oracle XML DB Repository

1-5 Listener Status with FTP and HTTP Protocol Support Enabled

1-6 Oracle XML DB Benefits

1-7 Unifying Data and Content: Some Common XML Architectures

2-1 Oracle XML DB Design Options

2-2 Data Storage Models: How Structured Is Your Data?

2-3 Data Access Models: How Will Users or Applications Access the Data?

2-4 Structured Storage Options

2-5 Oracle XML DB Application Program Interface (API) Stack

3-1 Using Windows Explorer to Load Content Into Oracle XML DB Repository

3-2 XMLSpy Graphical Representation of the PurchaseOrder XML Schema

3-3 XMLSpy Showing Support for Oracle XML DB Schema Annotations

3-4 Copying Files into Oracle XML DB Repository

3-5 Path-Based Access Using HTTP and a URL

3-6 Using Microsoft Word to Update and Edit Content Stored in Oracle XML DB

3-7 Using DBUri Servlet to Access XML Content

3-8 Database XSL Transformation of a PurchaseOrder Using DBUri Servlet

3-9 Database XSL Transformation of Departments Table Using DBUri Servlet

4-1 existsNode() Syntax

4-2 extract() Syntax

4-3 extractValue() Syntax

4-4 updateXML() Syntax

5-1 Creating an XMLType Table

5-2 How Oracle XML DB Maps XML Schema-Based XMLType Tables

5-3 Mapping simpleType: XML Strings to SQL VARCHAR2 or CLOBs

6-1 Mapping complexType to SQL for Out-of-Line Storage

6-2 Mapping complexType XML Fragments to Character Large Objects (CLOBs)

6-3 Cross Referencing Between Different complexTypes in the Same XML Schema

6-4 complexType Self Referencing Within an XML Schema

6-5 Cyclical References Between XML Schemas

8-1 XMLTransform() Syntax

8-2 Using XMLTransform()

10-1 PL/SQL DOM API for XMLType: Calling Sequence

10-2 PL/SQL Parser API for XMLType: Calling Sequence

10-3 PL/SQL XSLT Processor for XMLType: Calling Sequence

12-1 Java DOM API for XMLType: Calling Sequence

15-1 XMLElement() Syntax

15-2 XMLAttributes Clause Syntax

15-3 XMLForest() Syntax

15-4 XMLSequence() Syntax

15-5 XMLConcat() Syntax

15-6 XMLAgg() Syntax

15-7 XMLColAttVal() Syntax

15-8 DBMS_XMLGEN Calling Sequence

15-9 SYS_XMLGEN Syntax

15-10 SYS_XMLAGG() Syntax

16-1 Creating XMLType Views Clause: Syntax

17-1 DBUri: Visual or SQL View, XML View, and Associated XPath

17-2 SYS_DBURIGEN Syntax

18-1 A Typical Folder Tree Showing Hierarchical Structures in Oracle XML Repository

18-2 Oracle XML DB Repository Data Access Options

18-3 Oracle XML DB Folders in Windows Explorer

18-4 Accessing Repository Data Using HTTP/WebDAV and Navigational Access From IE Browser: Viewing Web Folders

20-1 Accessing Repository Resources Using RESOURCE_VIEW and PATH_VIEW

20-2 RESOURCE_VIEW and PATH_VIEW Structure

20-3 RESOURCE_VIEW and PATH_VIEW Explained

20-4 UNDER_PATH Syntax

20-5 EQUALS_PATH Syntax

20-6 PATH Syntax

21-1 Using DBMS_XDB to Manage Resources: Calling Sequence

21-2 Using DBMS_XDB to Manage Security: Calling Sequence

21-3 Using DBMS_XDB for Configuration Management: Calling Sequence

24-1 Oracle XML DB Architecture: Protocol Server

24-2 Creating a WebFolder in Windows 2000

26-1 Managing Oracle XML DB with Enterprise Manager: Main Tasks

26-2 Enterprise Manager Console: XML Database Management Window

26-3 Enterprise Manager Console: Configuring Oracle XML DB

26-4 Enterprise Manager Console: Edit XML Database Parameters Dialog

26-5 Enterprise Manager: Oracle XML DB Resources Tree Showing Resources Folder Selected

26-6 Enterprise Manager: Top Level Resources Under Root

26-7 Enterprise Manager: Individual Oracle XML DB Resources - General Page

26-8 Enterprise Manager: Individual Oracle XML DB Resource - Security Page

26-9 Enterprise Manager: When You Right-Click an Individual Resource...

26-10 Enterprise Manager: Create Oracle XML DB Resource Dialog Box

26-11 Enterprise Manager: Granting Privileges to Oracle XML DB Resources

26-12 Enterprise Manager: Show Contents Menus of Individual Oracle XML DB Resource

26-13 Enterprise Manager: Show Grantee of Oracle XML DB Resources

26-14 Adding or Revoking Privileges with Users > user> XML

26-15 Granting Privileges on a Resource

26-16 Enterprise Manager Console: Navigating XML Schema

26-17 Enterprise Manager: Creating XML Schema-Based Objects

26-18 Enterprise Manager: Registering an XML Schema - General Page

26-19 Enterprise Manager: Creating XML Schema - Options Page

26-20 Enterprise Manager: Creating XMLType Tables-General Page

26-21 Enterprise Manager: Creating XMLType Tables - Specifying LOB Storage

26-22 Enterprise Manager: Creating Tables With XMLType Column - General Page

26-23 Enterprise Manager: Creating Tables With XMLType Column - XMLType Options

26-24 Enterprise Manager: Creating an XMLType View - General Page

26-25 Enterprise Manager: Creating XMLType Views - Advanced Page

26-26 Enterprise Manager: Creating a Function-Based Index Based on XPath Expressions

29-1 Oracle Streams Advanced Queuing and XML Message Payloads

29-2 iDAP Architecture for Performing AQ Operations Using HTTP