Articles & Content


Lessons Learned While Building a Database Using PureXML (C07)

Topic: 2009 EU

Subtopic: DB2 for LUW

DATE: 2009-10-6 (14:15 - 15:15)
SPEAKERS: 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


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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.