
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
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