home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral Introduction to HW & SW Soft skills TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases and middleware Relational databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data and analyticsApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
XML in DB2

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? Do we have to create indexes for that purpose? Is it possible to modify XML documents efficiently? 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 some practical implementation scenarios. To this end we will learn to work with "PureXML", the "hybrid" database solution of DB2 (since version 9, both on z/OS and on LUW).

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 searching through and modifying of stored XML documents by using XPath:XMLExists, XMLQuery, and XMLModify
  • using XQuery and its FLWOR syntax
  • 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.
  • Practice:
  • Each technique is illustrated in detail
  • Opportunity to try everything out through individual exercises
 

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 e.g. XML concepts) will of course be an advantage.

Training method

As no thorough XML knowledge or experience is required for this session, we'll start with a 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

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Global score

   
3.9/5 (based on 28 evaluations)

Reviews

     
Good, brief introduction into XML (, )
     
tempo = hoog (, )
     
Very good course (, )
     
Too much time spent on first chapter and not enough focus on XML for DB2 and also need to bring out advantages + use cases (, )
     
Maybe 2 days to do more exercises and to go deeper into some parts (, )