home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » 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 » 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; of course, some notions of XML (see XML concepts) will be an advantage.

Training method

As no 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 and consequently guided by some demo's, make some exercises.

Course leader

Peter Vanroose, Kris Van Thillo.

Duration

1 day.

Schedule

datelanguageplacepriceremarks
30/11/2010NWoerden450 EUR
17/12/2010 Leuven450 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, but is also heavily 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, with or without losing (structure) information?
  • Is it possible to create an XML document inside DB2, thereby using relational DB2 data?
  • How does a DB2 specialist handle complex XML in the database? Can we search efficiently through XML documents?

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 9, and the XML extender (for DB2 v8 and V7).

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