XML Extender Overview

XML Documents

DTD

Application

DB2 XML Extender

Document insert, update, delete,

Document compose,

search & retrieve

decompose, update & delete

(UDFs and Stored Procedures)

(UDFs and Stored

Procedures)

 

(Document

Type

Definition)

DAD (Data Access Definition)

DTD_REF

XML Column

User Tables XML Side Tables

XML_USAGE

XML Collection

Traditional

Relational Tables

Administrative Support Tables

User Defined Tables

Figure 6-13 XML Extender overview

Administrative support tables, UDTs, and UDFs

The XML Extender creates the following set of administrative support tables (Table 6-1), UDTs (Table 6-2), UDFs (Table 6-3) and stored procedures (Table 6-4) when a database is enabled for XML.

Table 6-1 .Administrative support tables created

Table Name

Description

 

 

XMLUsage

Stores the Document Access Definition (DAD) files

 

 

DTD_Ref

Stores the DTDs used to vaildate XML documents

 

 

The schema qualifier for all the tables, UDFs and stored procedures created is

DB2XML.

Table 6-2 UDTs created

UDT

Description

 

 

XMLVarchar

Stores small XML documents with base type VARCHAR

 

(3000 bytes)

 

 

128 The XML Files: Development of XML/XSL Applications Using WebSphere Studio

Page 144
Image 144
IBM Version 5 manual Administrative support tables, UDTs, and UDFs, Administrative support tables created, UDTs created