Articles & Content

Archives

Lessons Learned while building a database using PureXML (H11)

Topic: 2009 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



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.