Rent Your Textbooks
Save up to 70% when you rent your textbooks on Amazon. Keep your textbook rentals for a semester and rental return shipping is free.
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
{"itemData":[{"priceBreaksMAP":null,"buyingPrice":44.99,"ASIN":"0138150478","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":65.71,"ASIN":"0132836424","isPreorder":0}],"shippingId":"0138150478::Icuzjw%2Bkh03Z6%2Fswyv6qT6LVwyVR%2FDHkA7tjGz3NCA2YaJUNZQ%2BAVrghMBxAOv0pScUyXxw66JQ8Yvbxjj12eavJOi8RSBcU10cR2zesOHdvn53NxNk9DA%3D%3D,0132836424::2aYiPfZKv9ulevMn3TRFj7p2OF95SY22VPUo7eflmh0pl%2Fmli9W3zuwoii4ORZs2ZOifX9IcXLcFfstfrMUI%2FtNh6ACiB6Di8ZGxI3lg5ZPiu2E7i8l%2BwA%3D%3D","sprites":{"addToWishlist":["wl_one","wl_two","wl_three"],"addToCart":["s_addToCart","s_addBothToCart","s_add3ToCart"],"preorder":["s_preorderThis","s_preorderBoth","s_preorderAll3"]},"currenyCode":"USD","shippingDetails":{"xy":"same"},"tags":["x","y","z"],"strings":{"addToWishlist":["add to wishlist","Add both to Wish List","Add all three to Wish List"],"addToCart":["Add to Cart","Add both to Cart","Add all three to Cart"],"showDetailsDefault":"Show availability and shipping details","shippingError":"An error occurred, please try again","hideDetailsDefault":"Hide availability and shipping details","priceLabel":["Price:","Price for both:","Price for all three:"],"preorder":["Pre-order this item","Pre-order both items","Pre-order all three items"]}}
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.
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 http://www.matthiasnicola.de .
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.
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!
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.
