XML and DB2

Allgemein:

• XML lernen

Free e-books:

• DB2 9: pureXML Fast Start and Overview (provides an overview of new DB2 support for XQuery, SQL/XML, XML Schemas, XML application development, and more)
• DB2 9 pureXML Guide (IBM Redbook, discusses a wide range of technical topics on DB2 XML)
• DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java and .Net  (provides many code samples and development guidelines)
• XML basics for Java Developers
• Oracle to DB2 Conversion Guide – Converting to DB2 for Linux, UNIX, and Windows (helps to migrate from Oracle to DB2.  It includes a chapter dedicated to XML conversion topics.)

Articles:

• Get off to a fast start with DB2 Viper (IBM developerWorks, 03/2006)
• DB2 9 pureXML Overview and Fast Start (IBM Redbook, 2006)
• Enhance business insight and scalability of XML data with new DB2 9.7 pureXML features  IBM developerWorks, April 2009.
• XML and the Database: A Perspective for the DBA (Dr. Dobb’s, 2009)
• Best Practices — Managing XML Data (IBM White Paper, 2008)
• Query DB2 XML Data with SQL (IBM developerWorks, 03/2006, updated 03/2010)
• Query DB2 XML Data with XQuery  (IBM developerWorks, 04/2006, updated 03/2010)
• pureXML in DB2 9: Which way to query XML data? (IBM developerWorks, 08/2007).
• Query XML data that contains namespaces (IBM developerWorks, 11/2006)
• XMLTABLE by example, Part 1: Retrieving XML data in relational format (IBM developerWorks, 08/2007)
  XMLTABLE by example, Part 2: Common scenarios for using XMLTABLE with DB2 (IBM developerWorks, 09/2007)
• Update XML in DB2 9.5 (IBM developerWorks, 10/2007)
• Integration of SQL and XQuery in IBM DB2 (IBM Systems Journal, 2006)
• XML in SQL Stored Procedures for DB2 9 (Linux, Unix, and Windows) (IBM developerWorks, 01/2007)
• Handle pureXML data in Java applications with pureQuery (IBM developerWorks, 01/2009)
• Develop Java applications for DB2 XML Data (IBM developerWorks, May 2006. developerWorks, 10/2006)
• Customizing XML Storage in DB2 (IBM Data Management Magazine, 10/2009)
• 15 best practices for pureXML performance in DB2 9 (IBM developerWorks, 10/2006)
• A performance comparison of DB2 9 pureXML with CLOB and shredded XML storage (IBM developerWorks, 12/2006)
• Taming a Terabyte of XML Data (IBM Database Magazine, #1 2009)
• Exploit XML indexes for XML query performance in DB2 9 (IBM developerWorks, 10/2006)
• Querying XML data with IBM DB2 through the semantic layer (SDN 2008 Business Objects)
• Guogen Zhang’s presentation on new XML features in DB2 10 for z/OS (IBM 2010, PDF)