Essential reading for DB2 pureXML
The lists below consist of articles and books that help with getting started with pureXML.
Introduction to pureXML
Saracco, C. M. "What's new in DB2 Viper: XML to the Core",
IBM developerWorks, February 2006.
Saracco, C. M. "Get off to a fast start with DB2 Viper", IBM developerWorks, March 2006.
Saracco, C. M. and Don Chamberlin, Rav Ahuja. DB2 9 pureXML Overview and Fast Start, IBM Redbook, 2006.
Saracco, C. M. and Matthias Nicola. "Enhance business insight and scalability of XML data with new DB2 9.7 pureXML features," IBM developerWorks, April 2009.
Patterson, Bryan and Dexiong Terry Zhang. "XML and the Database: A Perspective for the DBA" , IBM Database Magazine, 2009.
Nicola, Matthias and Pav Kumar-Chatterjee. DB2 pureXML Cookbook, IBM Press, 2009.
More books can be found here. DB2 Documentation can be found here
Best Practices
Englert, Susanne and Nicola, Matthias. "Best Practices -- Managing XML Data," IBM White Paper, 2008.
Querying and updating pureXML
Saracco, C. M. "Query DB2 XML Data with SQL",IBM developerWorks, March 2006.
Chamberlin, Don and C. M. Saracco. "Query DB2 XML Data with XQuery",IBM developerWorks, April 2006.
Nicola, Matthias and Fatma Ozcan. "pureXML in DB2 9: Which way to query XML data?", IBM developerWorks, June 2006.
Saracco, C. M. "Query XML data that contains namespaces," IBM developerWorks, November 2006.
Rodrigues, Vitor and Matthias Nicola. "XMLTABLE by example, Part 1: Retrieving XML data in relational format" IBM developerWorks, August 2007.
Rodrigues, Vitor and Matthias Nicola. "XMLTABLE by example, Part 2: Common scenarios for using XMLTABLE with DB2" IBM developerWorks, September 2007.
Nicola, Matthias and Uttam Jain. "Update XML in DB2 9.5", IBM developerWorks, October 2007.
Ozcan, Fatma and Don Chamberlin, Krishna Kulkarni, Jan-Eike Michels. "Integration of SQL and XQuery in IBM DB2", IBM Systems Journal, Vol. 45, Number 2, 2006.
Developing pureXML applications
Oliva, Rex. "XML in SQL Stored Procedures for DB2 9 (Linux, Unix, and Windows)", IBM developerWorks, January 2007.
Rodrigues, Vitor. "Handle pureXML data in Java applications with pureQuery," IBM developerWorks, January 2009.
Saracco, C. M. "Develop Java applications for DB2 XML Data", IBM developerWorks, May 2006. developerWorks, October 2006.
Understanding pureXML Performance
Nicola, Matthias. "15 best practices for pureXML performance in DB2 9", IBM developerWorks, October 2006.
Nicola, Matthias and Vitor Rodrigues. "A performance comparison of DB2 9 pureXML with CLOB and shredded XML storage", IBM developerWorks, December 2006.
Gonzalez, Agustin and Matthias Nicola, "Taming a Terabyte of XML Data", IBM Database Magazine, Issue 1, 2009.
XML Database Benchmark: Transaction Processing over XML Overview , Description , Latest Results
Xie, Kevin and Jasmi Thekveli, Peter Shum, and Robert Taraba. Using DB2 pureXML and BladeCenter JS43 Server for high-performance transaction processing, September 2009.
Nicola, Matthias. "Exploit XML indexes for XML query performance in DB2 9 ", IBM developerWorks, October 2006.
Additional reading
Many more papers and articles about DB2 pureXML are available. Please visit the Additional Reading section of this Wiki. There is also a section dedicated to DB2 z/OS.
If you have any comments or questions, please post them to the DB2 pureXML forum.
