Programming Books C Java PHP Python Learn more Browse Programming Books
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid... and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $6.81 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading DB2 pureXML Cookbook on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

by Matthias Nicola, Pav Kumar-Chatterjee
5.0 out of 5 stars  See all reviews (4 customer reviews)

List Price: $54.99
Price: $45.93 & FREE Shipping. Details
You Save: $9.06 (16%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it tomorrow, April 25? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $25.49  
Hardcover $45.93  
Unknown Binding --  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

August 20, 2009 0138150478 978-0138150471 1

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


Frequently Bought Together

DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server + DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition) (IBM Press)
Price for both: $111.33

Buy the selected items together

Customers Who Bought This Item Also Bought

Editorial Reviews

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


Product Details

  • Hardcover: 792 pages
  • Publisher: IBM Press; 1 edition (August 20, 2009)
  • Language: English
  • ISBN-10: 0138150478
  • ISBN-13: 978-0138150471
  • Product Dimensions: 9.2 x 7.1 x 1.7 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #1,616,632 in Books (See Top 100 in Books)

More About the Author

Matthias Nicola studied computer science in Germany and received his Diploma degree (M.Sc.) in 1996. Alongside his studies Matthias also supported several Hospitals in Tanzania during their introduction of computer systems to improve hospital administration. Over the years he spent 21 months in Tanzania. From 1995 to 1999 Matthias worked full-time at the Technical University of Aachen in Germany on research and industry projects related to distributed & replicated databases. In the winter of 1999 Matthias received his doctorate (Ph.D.) in computer science. Committed to work on commercial database engines, Matthias joined Informix Software in California in early 2000, focusing on data warehouse performance. In June 2002 Matthias joined the DB2 team at IBM's Silicon Valley Lab in San Jose, CA. His work at IBM quickly focused on all aspects of XML in DB2, including XQuery, SQL/XML, XML storage, indexing, application development, and performance. Since the release of DB2 9.1 and pureXML in 2006, Matthias has worked with numerous partners and customers on the design, implementation, and optimization of their XML-based applications. All of Matthias' publications are listed at .

Customer Reviews

5.0 out of 5 stars
5.0 out of 5 stars
4 star
3 star
2 star
1 star
Share your thoughts with other customers
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars A must-read for All XML database developers December 31, 2009
The DB2 pureXML Cookbook is one of the most comprehensive technical books I've ever read on any topic.

It not only covers DB2's pureXML implementation of the SQL/XML, XPath and XQuery in great depth but it also provides a wealth of detail on the underlying standards as well. Therefore I would recommend this not only to DB2 people using XML, but to anyone using XML in a database environment.

The examples, of which there are hundreds, are probably the best feature of this book. I find myself dipping into it for help over and over again and finding something that I can easily modify for my own particular use case. It is obvious that the authors have extensive experience not only of XML and DB2 pureXML but of how these technologies are used in the "real world".

My advice to you ... buy it and save yourselves hours of effort in your XML development effort.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars A "must have" for anyone working with pureXML November 9, 2011
I'v had the opportunity to hear Dr. Matthias Nicola speak about DB2 PureXML on several occasions and there's no doubt that he is an expert on the subject. This book confirms that.

The DB2 pureXML Cookbook is the most comprehensive and authorative technical book that I have found on the subject. It is a "must have" for anyone wishing to take advantage of all that pureXML has to offer in a DB2 environment. In addition to describing the benefits of using pureXML, it covers everything from designing and managing XML storage objects to querying XML data with SQL and XQuery. I highly recommend it!
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Very detailed and understandable with great examples January 13, 2011
This is one of the best technical books I've read. All the examples are fantastic. Too often a detailed technical manual will not provide adequate examples or will assume prior information. This book will take you from novice to expert.
Comment | 
Was this review helpful to you?
DB2 PureXML Cookbook is a 'must' for any advanced-level library strong in database surveys in general and DB2 in particular. It focuses on using XML data in the process of implementing DB2, and provides fine technical coverage on a range of issues, from identifying inefficient XML queries and updating XML documents to importing and replicating XML data and optimizing its performance. Very highly recommended!
Comment | 
Was this review helpful to you?
Search Customer Reviews
Only search this product's reviews


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category