| | h2. Essential reading for DB2 pureXML |
| | |
| | _The lists below consist of articles and books that help with getting started with pureXML._ |
| | |
| | {color:crimson}{*}Introduction to pureXML{*}{color} |
| | (*) Saracco, C. M. [*"What's new in DB2 Viper: XML to the Core"*,|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602saracco/] IBM developerWorks, February 2006. |
| | (*) Saracco, C. M. [*"Get off to a fast start with DB2 Viper", *|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603saracco/] IBM developerWorks, March 2006. |
| | (*) Saracco, C. M. and Don Chamberlin, Rav Ahuja. [*DB2 9 pureXML Overview and Fast Start*|http://www.redbooks.ibm.com/abstracts/sg247298.html?Open], IBM Redbook, 2006. |
| | (*) Saracco, C. M. and Matthias Nicola. ["Enhance business insight and scalability of XML data with new DB2 9.7 pureXML features," |http://www.ibm.com/developerworks/data/library/techarticle/dm-0904db297purexml/index.html] IBM developerWorks, April 2009. |
| | (*) Patterson, Bryan and Dexiong Terry Zhang. ["XML and the Database: A Perspective for the DBA" |http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216402743], IBM Database Magazine, 2009. |
| | (*) Nicola, Matthias and Pav Kumar-Chatterjee. [DB2 pureXML Cookbook|https://www.ibm.com/developerworks/wikis/display/db2xml/DB2+pureXML+Cookbook], IBM Press, 2009. |
| | (*) More books can be found [here|http://www.ibm.com/developerworks/wikis/display/db2xml/Books]. DB2 Documentation can be found [here|http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp] |
| | |
| | {color:crimson}{*}Best Practices{*}{color} |
| | (*) Englert, Susanne and Nicola, Matthias. [*"Best Practices \-\- Managing XML Data*,"|http://download.boulder.ibm.com/ibmdl/pub/software/dw/dm/db2/bestpractices/DB2BP_XML_0508I.pdf] IBM White Paper, 2008. |
| | |
| | {color:crimson}{*}Querying and updating pureXML{*}{color} |
| | (*) Saracco, C. M. [*"Query DB2 XML Data with SQL",*|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603saracco2/]IBM developerWorks, March 2006. |
| | (*) Chamberlin, Don and C. M. Saracco. [*"Query DB2 XML Data with XQuery"*,|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0604saracco/]IBM developerWorks, April 2006. |
| | (*) Nicola, Matthias and Fatma Ozcan. [*"pureXML in DB2 9: Which way to query XML data?",*|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606nicola/] IBM developerWorks, June 2006. |
| | (*) Saracco, C. M. [*"Query XML data that contains namespaces,"*|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0611saracco/] IBM developerWorks, November 2006. |
| | (*) Rodrigues, Vitor and Matthias Nicola. "[*XMLTABLE by example, Part 1: Retrieving XML data in relational format*|http://www.ibm.com/developerworks/db2/library/techarticle/dm-0708nicola/]" IBM developerWorks, August 2007. |
| | (*) Rodrigues, Vitor and Matthias Nicola. [*"XMLTABLE by example, Part 2: Common scenarios for using XMLTABLE with DB2"*|http://www.ibm.com/developerworks/db2/library/techarticle/dm-0709nicola/] IBM developerWorks, September 2007. |
| | (*) Nicola, Matthias and Uttam Jain. [*"Update XML in DB2 9.5"*|http://www.ibm.com/developerworks/db2/library/techarticle/dm-0710nicola/], IBM developerWorks, October 2007. |
| | (*) Ozcan, Fatma and Don Chamberlin, Krishna Kulkarni, Jan-Eike Michels. [*"Integration of SQL and XQuery in IBM DB2",*|http://www.research.ibm.com/journal/sj/452/ozcan.html] IBM Systems Journal, Vol. 45, Number 2, 2006. |
| | |
| | {color:crimson}{*}Developing pureXML applications *{color} |
| | (*) Oliva, Rex. ["XML in SQL Stored Procedures for DB2 9 (Linux, Unix, and Windows)", |http://www.ibm.com/developerworks/data/library/techarticle/dm-0701oliva/]{color:#000000}IBM developerWorks, January 2007.{color} |
| | (*) {color:#000000}Rodrigues, Vitor.{color} ["Handle pureXML data in Java applications with pureQuery,"|http://www.ibm.com/developerworks/data/library/techarticle/dm-0901rodrigues/index.html] {color:#000000}IBM developerWorks, January 2009.{color} |
| | (*) {color:#000000}Saracco, C. M.{color} ["Develop Java applications for DB2 XML Data",|http://www.ibm.com/developerworks/data/library/techarticle/dm-0605saracco/] {color:#000000}IBM developerWorks, May 2006. developerWorks, October 2006.{color} |
| | |
| | {color:crimson}{*}Understanding pureXML Performance{*}{color} |
| | (*) Nicola, Matthias. [*"15 best practices for pureXML performance in DB2 9"*| http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0610nicola/], IBM developerWorks, October 2006. |
| | (*) Nicola, Matthias and Vitor Rodrigues. [*"A performance comparison of DB2 9 pureXML with CLOB and shredded XML storage"*|http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612nicola/], IBM developerWorks, December 2006. |
| | (*) Gonzalez, Agustin and Matthias Nicola, [*"Taming a Terabyte of XML Data"*|http://www.ibm.com/developerworks/data/library/dmmag/DBMag_2009_Issue1/DBMag_Issue109_TamingTerabyte/index.html], IBM Database Magazine, Issue 1, 2009. |
| | (*) XML Database Benchmark: Transaction Processing over XML [Overview|http://tpox.sourceforge.net/] , [Description|http://tpox.sourceforge.net/Sigmod2007_TPoX.pdf] , [Latest Results|http://tpox.sourceforge.net/tpoxresults.htm] |
| | | (*) Kogan, Irina and Matthias Nicola, Berni Schiefer. [*"DB2 9 XML performance characteristics",*|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606schiefer/index.html] IBM developerWorks, June 2006. |
| | | (*) Xie, Kevin and Jasmi Thekveli, Peter Shum, and Robert Taraba. [*Using DB2 pureXML and BladeCenter JS43 Server for high-performance transaction processing*|http://www.ibm.com/partnerworld/wps/whitepaper/bladecenter/js43_server/performance], September 2009. |
| | (*) Nicola, Matthias. [*"Exploit XML indexes for XML query performance in DB2 9 "*|http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0611nicola/], IBM developerWorks, October 2006. |
| | |
| | h2. Additional reading |
| | |
| | Many more papers and articles about DB2 pureXML are available. Please visit the [Additional Reading|http://www.ibm.com/developerworks/wikis/display/db2xml/Additional+reading] section of this Wiki. There is also a section dedicated to [DB2 z/OS.|http://www.ibm.com/developerworks/wikis/display/db2xml/DB2+for+zOS+pureXML] |
| | |
| | If you have any comments or questions, please post them to the [DB2 pureXML forum.|http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1423] |