Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.