Articles & Content

Archives

Unleash SQL Power to your XML Data (E14)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2008



DATE: 2008-10-16 (09:00 - 10:00)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

SQL is no longer the purely relational language that it used to be. The latest SQL standard defines an XML data type and new functions for querying hierarchical XML data. This is supported by DB2's pureXML functionality on zOS and Linux, Unix, and Windows. Apart from efficient storage and indexing, pureXML allows you to search and extract XML values through new the SQL functions. This also enables you to join XML and relational data in a single query, and to convert one to the other as needed. Additionally, you can apply the full power of all the good old relational SQL features to your XML data. This session introduces you to querying XML data in the DB2 9 family and presents tips & tricks for getting the best of both worlds when querying XML and relational data.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Learn the basics of XPATH and how to use XPATH in SQL statements to extract XML values or to express predicates on XML data.

Learn how to query XML data in DB2, using the new SQL functions XMLEXISTS, XMLQUERY, and XMLTABLE.

Learn how to retrieve XML data in relational format, and vice versa, and how to apply any existing SQL functions and features to XML data.

Learn how to define relational views over XML to make your XML data available to your existing SQL applications.

Learn some fundamental guidelines for write efficient queries, and for integrating XML and relational data.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.