Articles & Content
Archives
Lessons Learned while building a database using PureXML (H11)
Topic: Cross Platform DB2 for z/OS & LUW
Subtopic: 2009
DATE: 2009-5-14 (02:45 PM - 03:45 PM)
SPEAKERS: Kurt Bruhn (BJC HealthCare), Tom Holdener (BJC HealthCare)
XML in DB2 - Lessons Learned While Creating an XML database for medical research : Creating XML tables in DB2, when and how to use inline and compression, indexes on the XML data, using SQL, SQL/XML, XQuery to insert data and using SQL/XML and XQuery to read data from these tables.
EXP. LEVEL: Advanced
OBJECTIVES:
Creating XML tables: Considerations for inline size selection
Indexes: How are the indexes used in XQueries and what must be considered before defining them
Populating the table: Considerations for load, How best to write inserts using SQL/XML
XQuery: How to write SQL/XML and XQueries that perform well. How to join XML tables - caveats and pitfalls
XML Tables: When to use compression
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.