Articles & Content


Real-World XML Application Development Patterns for DB2 (E08)

Topic: 2011 NA

Subtopic: DB2 for LUW

DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Fred Sobotka (FRS Consulting )

The latest versions of DB2 for LUW and z/OS both offer a rich set of XML features, each with different advantages and tradeoffs. Even if your business applications are already consuming and/or publishing XML through other means, you may be able to reduce the DB2 overhead and overall complexity of your XML processing by exploiting DB2's built-in XML functions. XML enablement with DB2 does not need to be a disruptive endeavor if you take the right approach, which is illustrated in this presentation through a series of case studies distilled from a broad variety real-world pureXML implementations for e-commerce, law enforcement/criminal justice, and Fortune 500 environments. Challenges encountered at different phases of each project will be discussed at a technical level suitable for application developers and DBAs.

EXP. LEVEL: Beginner,Intermediate


Understand how XML document formats and data quality affect your options. Learn about the common data problems that are showstoppers in an XML-enabled application.

Enhance existing DB2 applications to shred incoming XML with minimal impact to application code and the data model.

Efficiently publish entire hierarchies of business data into comprehensive XML documents. Determine whether a single monolithic query or a series of simpler statements will perform better when casting relational data into XML.

Contrast the strengths and weaknesses of publishing via XQuery vs. SQL/XML vs. XSLT. For complex document formats, a hybrid approach of a query and an XSL transformation may be the most approachable way to produce the desired output.

Use sneaky tricks to accelerate the creation of document validation schemas, test suites, and other project deliverables. An assortment of high-quality, free software tools and online resources can automate many types of tasks that are either tedious or error-prone.

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.