Workshop

Extensible markup language (XML) has been widely adopted as the format for information exchange. Businesses are using XML increasingly to integrate applications within the enterprise and to exchange information with trading partners and other institutions.

A database that supports XML natively provides many inherent benefits to XML developers. IBM’s DB2 9 marks the culmination of a five-year IBM development project that has transformed traditional, static database technology into an interactive, vibrant data server that merges the high performance and ease of use of DB2 with the flexible, self-describing benefits that XML offers. Learn how to unlock the latent potential of XML with performance and development time/cost savings from pureXML.

In this hands-on session, attendees will learn how to leverage DB2 XML capabilities to store, query, and index XML data.

Whether you are user of DB2 or not, use this session to keep abreast with the latest technology available to accelerate and improve your adoption of XML technologies.

To find out more about this pureXML, this unique feature for DB2 9, please go to
http://www.ibm.com/software/data/db2/xml/

Participants should have good knowledge of relational database technologies.
Participants are required to bring a laptop with the following minimum specifications if they wish to participate in the hands on workshop.

Computer is provided

Hardware – 1G RAM, 5-10 GB available free disk space, Windows OS (Home edition not supported).

Participants will be provided with a free copy of DB2 9 Express-C for the purposes of this workshop.

XML Benefits and Use Cases
XML Fundamentals
XML support in DB2 9
Hands-on Lab/ Example/Demo

XML Features Lab

1. Create a DB2 database (to support relational and XML data objects).

2. Create a DB2 table to store XML data.

3. Add data to the table using SQL INSERT statements.

4. Query a table using SQL and XQuery.

5. Issue various queries using XQuery.

6. Querying using XQuery on a XML column of an indexed table.