Using XML with DB2


The XML standard has acquired a great impact on the IT industry and on the way we are all working. It has become the de facto standard for structured data transport, but is also heavily used to store documents in a format-neutral way.

In this course we we will explain the features of XML in combination with DB2 and will present two practical implementation scenarios. As no XML knowledge or experience is required for this session, the course will start with a brief theoretical introduction to XML. Starting from this basic XML knowledge, attendees will gain a clear understanding of the XML features provided by DB2 and, guided by some practical demonstrations, will be able to complete the practical exercises.

This course is available for one-company, on-site presentations.

Objectives

On successful completion of this course you will be able to:

  • list the easy ways to handle XML documents and store the data in DB2
  • explain how to create an XML document using DB2 data
  • describe how a DB2 specialist handles complex XML in the database
  • search efficiently through these XML documents.

Who Should Attend

DB2 developers and DBAs.

Prerequisites

A good knowledge of DB2 is expected. No XML knowledge or experience is required.

Duration

1 day

Fee (per attendee)

£450 (ex VAT)

Course Code

XMLD

Contents

Practical Sessions

Each technique is illustrated in detail; Opportunity to try everything out through individual exercises.

Introduction to XML

Everything a DB2 developer or DBA should know about XML: elements, attributes, tree structure, DTDs, schemas, etc.

Pure XML

Storing XML documents in tables by using the new DB2 datatype "XML"; Creating XML documents: the functions XMLElement, XMLForest, XMLConcat, XMLAgg, XMLDocument; Validating XML documents: XML Schemas and the DB2 schema repositor; Efficient searching through and modifying of stored XML documents by using XPath:XMLExists, XMLQuery, and XMLModify.

Storing XML Documents: XColumn

Administration and maintenance of an XML tablespace; Defining indexes on an XML document.

XML Transport of DB2 Data

The most important differences between relational data representation and the XML data model; Sensibly combining of / converting between relational data and XML data; shredding.


© RSM Technology 2017