home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
XML in DB2

Intended for

DB2 developers and DBAs.

Background

Good knowledge of DB2 is required (see courses DB2 for z/OS fundamentals course or DB2 for LUW fundamentals course). A thorough XML knowledge or experience is not necessary; some notions of XML (see XML concepts) will be an advantage, of course.

Training method

As no thorough XML knowledge or experience is required for this session, we'll start with a (very) brief theoretical introduction to XML. Starting from this basic XML knowledge, it will be easy to understand the XML features provided by DB2. The theoretical explanation will be guided by demo's and exercises.

Course leader

Peter Vanroose, Kris Van Thillo.

Duration

1 day.

Schedule

datelanguageplacepriceremarks
27/03/2012NWoerden470 EUR
01/06/2012 Leuven470 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

The XML standard has acquired a great impact on the IT industry and on the way we are working. It has become the standard for structured data transport, and is also more and more used to store documents in a format-neutral way. Questions that arise in a DB2 context are:

  • Are there easy ways to handle XML documents and store the data in DB2, and how can this be done without losing (structure) information?
  • Is it possible to create an XML document based on relational DB2 data, and can this be done by using SQL?
  • How does a DB2 specialist handle complex XML in the database? Can XML documents be efficiently searched through? And being indexed? How to write an SQL query that collects data from both an XML document and from a relational structure?

In this course we will explain the features of XML in combination with DB2 and we will present two practical implementation scenarios. We will treat both "PureXML", the new "hybrid" database solution of DB2 since version 9, and the XML extender (for older versions of DB2).

Main topics

  • Introduction to XML:
  • Everything a DB2 developer or DBA should know about XML: elements, attributes, tree structure, DTDs, Schemas, ...
  • PureXML:
  • Storing XML documents in tables by using the new DB2 datatype "XML"
  • Create XML documents: the functions XMLElement, XMLForest, XMLConcat, XMLAgg, XMLDocument
  • Validating XML documents: XML Schemas and the DB2 schema repository
  • Efficient search through stored XML documents by using XPath: XMLExists and XMLQuery
  • Storing XML documents:
  • Administration and maintenance of an XML tablespace
  • Defining indexes on an XML document
  • XML transport of DB2 data:
  • Focusing on the most important differences between relational data representation and the XML data model
  • Suggestions for sensibly combining of / converting between relational data and XML data; shredding.
  • The DB2 XML extender:
  • What is an extender?
  • Enabling the XML extender
  • Use of the XML extender; XMLColumn; XMLCollection
  • Practice:
  • Each technique is illustrated in detail
  • Opportunity to try it out through individual exercises