Thanks for your replies. The information provided was great to get me
starting on the research. Our data vendors have adopted this standard
and we don't have a choice. I do not foresee the need to update the XML
documents, as the primary intent is to archive the data for reporting
and statistics. I guess using XML collections or in-home built parsing
tool is the obvious choice. I'll do my homework and get back with any
questions.

Thanks

-----Original Message-----
From: ken farmer [mailto:[Email address protected]
Sent: Thursday, January 27, 2005 1:09 PM
To: Oruganti, Shaila
Subject: Re: Loading XML data to UDB tables on AIX/UNIX


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret **from
this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Oruganti Shaila wrote:

> Hello!
> One of my requirements needs XML data to be loaded to UDB tables on
> AIX UNIX. I was wondering if there is any easier way to load XML data

> to UDB tables. Any help or references on this would be greatly
> appreciated.

XML is best as an 'over the wire' protocol. If you don't have to keep
the data in this format, then there are a lot of advantages to using an
XML parsing tool to remap the XML into another format - then load the
data into a traditional data model.

pros:
- no additional database extenders required
- complete database functionality for all data
- no database performance issues
- opportunitity for additional data quality and business rule
validations beyond what might be provided within XML
- opportunity to manage temporal consistency of data

cons:
- you need to parse the data (via whichever tool/language you
prefer)
- you need to create a data model
- changes to XML schema will require more effort than if
you just passed it directly to db2: data conversions, schema
changes, and parsing program changes.


ken
**** Important Notice to Recipients ****
It is important that you do not use e-mail to request, authorize or effect the purchase or sale of any security or commodity, to send fund transfer instructions, or to effect any other transactions. Any such request, orders, or instructions that you send will not be accepted and will not be processed by Morgan Stanley.
****************************************

DB2 & UDB email list listserv db2-l LazyDBA home page