Lessons Learned from DB2 pureXML Applications: A Practitioner’s Perspective

  • Matthias Nicola
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6309)


Beyond using XML as a message format, more and more companies are storing XML data permanently in a database. Database researchers and vendors alike have spent a lot of effort on designing, studying, and implementing XML database technology. In this paper we report our experiences from working with a broad variety of companies that have developed and deployed XML applications on top of DB2. We discuss three real-world XML database scenarios and their design considerations, and describe recurring patterns in XML applications. We highlight common concepts and observations, and document challenges that point to future work for the database community.


XML database systems experiences XQuery SQL/XML 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Abdel Kader, R., van Keulen, M.: Overview of query optimization in XML database systems, Technical Report TR-CTIT-07-39, University of Twente, EnschedeGoogle Scholar
  2. 2.
    Afanasiev, L., Marx, M.: An analysis of XQuery benchmarks. Inf. Syst. 33(2) (2008)Google Scholar
  3. 3.
    Barbosa, D., et al.: XML Benchmarks. In: Encyclopedia of Database Systems (2009)Google Scholar
  4. 4.
    Beckmann, J., et al.: Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format. In: ICDE 2006 (2006)Google Scholar
  5. 5.
    Beyer, K., et al.: System RX: One Part Relational, One Part XML. In: SIGMOD 2005 (2005)Google Scholar
  6. 6.
    Eisenberg, A., Melton, J.: Advancements in SQL/XML. SIGMOD Record 33(2) (2004)Google Scholar
  7. 7.
    FpML (Financial Products Markup Language),
  8. 8.
    Holstege, M.: Big, Fast, XQuery: Enabling Content Applications. IEEE Data Engineering Bulletin 31(4) (2008),
  9. 9.
  10. 10.
  11. 11.
    Moro, M., et al.: Schema advisor for hybrid relational-XML DBMS. In: SIGMOD 2007 (2007)Google Scholar
  12. 12.
    Murthy, R., et al.: Towards an enterprise XML architecture. In: SIGMOD 2005 (2005) Google Scholar
  13. 13.
    Nicola, M., Gonzalez, A.: Taming a Terabyte of XML Data. IBM Data Management Magazine 14(1) (2009)Google Scholar
  14. 14.
    Nicola, M., Kiefer, T.: Generating SQL/XML Query and Update Statements. In: 18th Intl. Conference on Information and Knowledge Management, CIKM 2009 (2009)Google Scholar
  15. 15.
    Nicola, M., Kumar-Chatterjee, P.: DB2 pureXML Cookbook. IBM Press Books (2009) ISBN 0138150478Google Scholar
  16. 16.
    Open Applications Group Integration Specification (OAGIS),
  17. 17.
  18. 18.
    Rowell, M.: The Open Applications Group Integration Specification. Developer Works (2003),
  19. 19.
    Rys, M.: XML and Relational Database Management Systems: Inside Microsoft SQL Server. In: SIGMOD 2005 (2005)Google Scholar
  20. 20.
    Wiwatwattana, N., et al.: X^3: A Cube Operator for XML OLAP. In: ICDE 2007 (2007) Google Scholar
  21. 21.
    XFDL (eXtensible Forms Description Language),
  22. 22.
  23. 23.
  24. 24.
    XQuery 1.0 and XPath 2.0 Data Model (XDM),

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Matthias Nicola
    • 1
  1. 1.IBM Silicon Valley Lab.San JoseUSA

Personalised recommendations