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

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