Skip to main content

XML for DB2 Information Integration

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 15 July 2004

  1. .PDF (7.2 MB)

Share this page:   

ISBN-10: 0738490032
ISBN-13: 9780738490038
IBM Form #: SG24-6994-00

Authors: Bart Steegmans, Ronald Bourret, Olivier Guyennet, Shrinivas Kulkarni, Stephen Priestley, Owen Cline, Valeriy Sylenko and Ueli Wahli

    menu icon


    In many organizations, relational databases are the backbone for data storage and retrieval. Over the last couple of years, XML has become the de facto standard to exchange information between organizations, as well as between departments or applications within the same organization. Since data tends to live in databases, it needs to be converted from a relational format into an XML format when involved in those data exchanges, as well as converted (back) from XML into a relational format for storage, or for handling by other applications.

    How can we achieve this? This IBM Redbooks publication describes how to design the mapping between XML and relational data, and vice versa, to enable a flexible exchange of information.

    IBM provides a number of products to help you bridge the gap between XML and its relational database, DB2. The DB2 engine itself provides support to generate XML fragments from relational data through the use of SQL/XML built-in functions. DB2 also provides the DB2 XML Extender. It allows you to perform XML composition, like SQL/XML, but also provides functionality to decompose XML documents and store XML documents intact inside the database. XML Extender also provides a set of transformation and validation functions. Another option to work with XML is to use the XML wrapper, a part of the set of non-relational wrappers of DB2 Information Integrator. This book also looks at the IBM tools available to assist you when dealing with XML, specifically WebSphere Application Developer and DB2 Control Center.

    To add a more practical angle, these functions and products are illustrated through the development of a simple application.

    Table of Contents

    Part 1. Overview

    Chapter 1. XML and databases

    Chapter 2. XML services in DB2 and DB2 Information Integrator

    Chapter 3. Designing XML and database schemas

    Part 2. Processing XML documents

    Chapter 4. Storing whole XML documents

    Chapter 5. Working with XML documents stored in XML columns

    Chapter 6. Shredding XML into relational tables

    Chapter 7. Bulk processing of XML documents

    Chapter 8. Publishing data as XML

    Chapter 9. Additional XML functionality

    Chapter 10. Web services in DB2

    Chapter 11. XML wrapper

    Part 3. XML tools for database systems

    Chapter 12. XML and database tools in Application Developer

    Part 4. Worked examples

    Chapter 13. Worked scenario

    Chapter 14. Scenario implementation using DB2 functionality

    Chapter 15. Scenario with Application Developer tools

    Chapter 16. DB2 Web services and XML with Application Developer

    Chapter 17. Deployment of DB2 Web services

    Appendix A. Installation

    Appendix B. Introduction to XML

    Appendix C. Table-based and object-relational mappings

    Appendix D. DAD DTD reference

    Appendix E. Sample XML Tools

    Appendix F. Additional material


    Others who read this also read