DB2 pureXML Cookbook Master the Power of the IBM Hybrid Data Server Hands-On Solutions and Best Practices for Developing and Managing XML Database Applications with DB2 More and more database developers and DBAs are being asked to develop applications and manage databases that involve XML data. Many are utilizing the highly praised DB2 pureXML technology from IBM. In the DB2 pureXML Cookbook, two leading experts from IBM offer the practical solutions and proven code samples that database professionals need to build better XML solutions faster. Organized by task, this book is packed with more than 700 easy-to-adapt recipe-style examples covering the entire application lifecycle-from planning and design through coding, optimization, and troubleshooting. This extraordinary library of recipes includes more than 250 XQuery and SQL/XML queries. With the authors' hands-on guidance, you'll learn how to combine pureXML ingredients to efficiently perform virtually any XML data management task, from the simplest to the most advanced. Coverage includes

• pureXML in DB2 9 for z/OS and DB2 9.1, 9.5, and 9.7 for Linux, UNIX, and Windows
• Best practices for designing XML data, applications, and storage objects Importing, exporting, loading, replicating, and federating XML data
• Querying XML data, from start to finish: XPath and XQuery data model and languages, SQL/XML, stored procedures, UDFs, and much more
• Avoiding common errors and inefficient XML queries
• Converting relational data to XML and vice versa
• Updating and transforming XML documents
• Defining and working with XML indexes
• Monitoring and optimizing the performance of XML queries and other operations
• Using XML Schemas to constrain and validate XML documents
• XML application development-including code samples for Java, .NET, C, COBOL, PL/1, PHP, and Perl

This guide for database administrators, application developers, and IT architects offers hands-on solutions and best practices for developing and managing XML database applications with DB2, and provides about 700 "recipe-style" practical examples (including 250 XQuery and SQL/XML queries) covering the entire application lifecycle, from planning and design through coding, optimization, and troubleshooting. Coverage of each task for managing XML data starts with simple examples and works towards advanced concepts and solutions to complex problems, making the book useful for both beginners and experts. Coverage encompasses DB2's pureXML functionality in DB2 for Linux, UNIX, and Windows, as well as DB2 for z/OS. The book includes introductions to XML, XPath, XQuery, XML Schema, and namespaces, so extensive knowledge of XML is not required, but some experience with relational databases and SQL is assumed. A final chapter offers multiple-choice quizzes with unexplained answers. Appendices cover getting started with DB2 pureXML, and the XML sample database. An appendix of further reading lists electronic resources for each section of each chapter. Nicola is senior software engineer for DB2 pureXML at IBM's Silicon Valley Lab. Kumar-Chatterjee has been involved in DB2 support on mainframes since 1991. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com)

In DB2 pureXML Cookbook, two of IBM's leading experts provide the single most comprehensive coverage of DB2's pureXML capabilities. This book explains DB2 pureXML in over 700 practical examples, including 250+ XQuery and SQL/XML queries, taking the reader from simple introductions all the way to advanced scenarios. The authors have distilled their hands-on experience with many pureXML applications so that you can benefit from best practices, tips & tricks, performance guidelines, and other gems that are not documented elsewhere. This book is invaluable for database administrators and application developers, beginners and DB2 experts. The topics are organized by typical user tasks throughout the life cycle of XML database projects, from planning, designing, and implementing databases all the way to tuning, problem determination, and application development. It includes code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers. The DB2 pureXML Cookbook provides proven recipes rather than a mere reference of ingredients.

Unique and comprehensive coverage of pureXML on all supported platforms: DB2 9.x for Linux, UNIX, and Windows and DB2 9 for z/OS.Written for database administrators and application developers, beginners and advanced DB2 users.More than 700 recipe-style examples of XML queries, updates, schemas, indexes, storage objects, application code, and database maintenance tasks.DB2 pureXML best practices, tips, and tricks based on the author's extensive hands-on experience in pureXML deployments.Coverage of brand-new XML features that IBM intends to make available in the next release of DB2