Filter
Top Products
Chapter 6. RDB and XML integration 135
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.
collection of tables enabled
for XML data
XML Collection Method Overview
XML Collection Method
Document compose, decompose, insertion,
update, delete, search & retrieval
XML_USAGE
DTD_REF
DAD
(Data Access
Definition)
DTD
XML
Documents
Application
DB2 XML Extender
elements/attributes
from xml document
decomposed into
table/columns
xml document
elements/attributes composed
from tables/columns
User tables