IBM Version 5 manual When to use XML Collection method, XML Collection Method overview

XML Collection Method Overview

XML Documents

Application

DB2 XML Extender

XML Collection Method

Document compose, decompose, insertion,

update, delete, search & retrieval

DTD

DAD

(Data Access

Definition)

DTD_REF

XML_USAGE

elements/attributes	xml document
from xml document	elements/attributes composed
decomposed into	from tables/columns
table/columns

User tables

collection of tables enabled for XML data

Figure 6-15 XML Collection Method overview

When to use XML Collection method

We recommend using the XML Collection method under the following conditions:

￿You have data in your existing DB2 database and you want to compose XML documents based on a specified DTD. This is very helpful in exchanging data between applications within an organization or across organizations so long as the XML data conforms to the DTD.

￿You have XML documents that need to be stored with collections of data that map well to relational tables.

￿You want to create different views of your relational data using different mapping schemes. Basically, you can use the data in your database to compose different XML documents based on your DTDs.

￿You have XML documents that from other data sources. You are interested in the data but not the tags, and want to store pure data in your database. You want the flexibility to store the XML data in existing tables or in new tables.

Chapter 6. RDB and XML integration 135