List of Figures

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

1-2 Oracle XML DB Architecture: XMLType Storage

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(S) 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 the 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

4-5 INSERTCHILDXML Syntax

4-6 INSERTXMLBEFORE Syntax

4-7 APPENDCHILDXML Syntax

4-8 DELETEXML 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

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

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

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

7-4 complexType Self Referencing Within an XML Schema

7-5 Cyclical References Between XML Schemas

9-1 XMLtransform Syntax

9-2 Using XMLTRANSFORM

11-1 Using PL/SQL DOM API for XMLType

11-2 Using PL/SQL Parser API for XMLType

11-3 Using PL/SQL XSLT Processor for XMLType

13-1 Using Java DOM API for XMLType

16-1 XMLELEMENT Syntax

16-2 XMLAttributes Clause Syntax (XMLATTRIBUTES)

16-3 XMLFOREST Syntax

16-4 XMLSEQUENCE Syntax

16-5 XMLCONCAT Syntax

16-6 XMLAGG Syntax

16-7 XMLPI Syntax

16-8 XMLComment Syntax

16-9 XMLRoot Syntax

16-10 XMLSerialize Syntax

16-11 XMLParse Syntax

16-12 XMLCOLATTVAL Syntax

16-13 XMLCDATA Syntax

16-14 Using DBMS_XMLGEN

16-15 SYS_XMLGEN Syntax

16-16 SYS_XMLAGG Syntax

17-1 XMLQUERY Syntax

17-2 XMLTABLE Syntax

18-1 Creating XMLType Views Clause: Syntax

19-1 A DBUri Corresponds to an XML Vizualization of Relational Data

19-2 SYS_DBURIGEN Syntax

20-1 A Folder Tree, Showing Hierarchical Structures in the Repository

20-2 Repository Data Access Options

20-3 Oracle XML DB Folders in Windows Explorer

20-4 Accessing Repository Data Using HTTP(S)/WebDAV and Navigational Access From IE Browser: Viewing Web Folders

20-5 ASM Virtual Folder Hierarchy

22-1 Accessing Repository Resources Using RESOURCE_VIEW and PATH_VIEW

22-2 RESOURCE_VIEW and PATH_VIEW Structure

22-3 RESOURCE_VIEW and PATH_VIEW Explained

22-4 UNDER_PATH Syntax

22-5 EQUALS_PATH Syntax

22-6 PATH Syntax

25-1 Oracle XML DB Architecture: Protocol Server

25-2 Creating a WebFolder in Windows 2000

31-1 Oracle Streams Advanced Queuing and XML Message Payloads

31-2 iDAP Architecture for Performing AQ Operations Using HTTP(S)