Articles & Content

Archives

Lessons Learned While Building a Database Using PureXML (C07)

Topic: DB2 for LUW

Subtopic: 2009



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

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.