DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server - Hardcover

Nicola, Matthias; Kumar-Chatterjee, Pav

Hardcover

ISBN 10: 0138150478 ISBN 13: 9780138150471

Publisher: IBM Press, 2009

Synopsis

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

 

About this title

About the Author:

Matthias Nicola is a Senior Software Engineer for DB2 pureXML at IBM’s Silicon Valley Lab. His work focuses on all aspects of XML in DB2, including XQuery, SQL/XML, XML storage, indexing, and performance. Matthias also works closely with customers and business partners, assisting them in the design, implementation, and optimization of XML solutions. Matthias has published more than a dozen articles on various XML topics (see www.matthiasnicola.de) and is a frequent speaker at DB2 conferences. Prior to joining IBM, Matthias worked on data warehousing performance for Informix Software. He received his doctorate in computer science from the Technical University of Aachen, Germany.

 

Pav Kumar-Chatterjee has worked with DB2 since 1991 on DB2 for z/OS and since 2000 on DB2 for Linux, UNIX, and Windows. He is currently employed by IBM as a technical sales specialist for Information Management in the United Kingdom. He has helped customers implement the XML Extender product with DB2 V8 and has presented on DB2 and XML in the United Kingdom and around Europe.

 

About this edition

• Publisher: IBM Press
• Publication date: 2009
• ISBN 10: 0138150478
• ISBN 13: 9780138150471
• Binding: Hardcover
• Edition number: 1
• Number of pages: 792