Real-World XML Application Development Patterns for DB2

Session Number: 2015
Track: General II (F)
Session Type: Podium Presentation
Primary Presenter: Fred Sobotka [Data Management Consultant - FRS Consulting]
Time: Nov 15, 2011 (03:45 PM - 04:45 PM)
Room: Stella

Speaker Bio: Fred R. Sobotka is an award-winning IDUG speaker and the principal consultant at FRS Consulting, a firm he founded in 2005 to help companies and organizations get the most out of DB2. For the past decade of his twenty years in software and IT, Fred has worked with DB2 LUW as a DBA and consultant, specializing in database design, tuning, development, migration, and monitoring. He writes about DB2 in blogs, journals, and magazines, and was the technical editor for the first DB2 book published by Apress. Fred is a longtime IDUG volunteer and a member of IBM's Gold Consultant and Information Champion Programs.
Audience experience level: Beginner, Intermediate
Presentation Category: Application Design
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators
Technical areas this presentation will apply to: SQL and XML Features, SQL and XML Performance, Triggers, Stored Procedures, UDFs
Objective 1: 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.
Objective 2: Enhance existing DB2 applications to shred incoming XML with minimal impact to application code and the data model.
Objective 3: 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.
Objective 4: 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.
Objective 5: 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 e

Abstract:  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.