Today, IBM announced new releases of DB2 and InfoSphere Warehouse that support high-performance analytic workloads for native XML data. New features include:
– Support for native XML data with hash partitioning (database partitioning)
– Support for native XML data with range partitioning (table partitioning)
– Support for native XML data with multi-dimensional clustering
– Support for predicate pushdown with native XML data in database views
– Deep compression of native XML data
– And more

These features have been tested by more than 300 participants in the DB2 Early Access Program, which has been active since April of 2008. Here is a small selection of the feedback we have received from those participants:

“…XML in a data warehouse was a very important feature to implement, and it’s now a complete feature…”
    Jean-Marc Blaise, Venedim

“…The parallelization of queries and inserts of the XML data will allow our researchers to gain access to the data they require even faster…”
    Tom Holdener, BJC HealthCare

“…XML compression reduces disk space consumption by more than 60%, irrespective of the size of the XML documents…”
    Phil Nelson, ScotDB

“…The enhancements will allow ULCA to generate business intelligence using XML data to help meet patient care needs…”
    Charles Wang, UCLA Health System

“…The new XML scalability and analytic capabilities in DB2 are quite exciting…”
    Neal Keene VP of Industry Solutions, Thunderhead

Over the course of the next week or so, I will talk in more detail about these new features.


The XML Rap Superstar

April 22, 2009

Rahsheen Porter and his very clever XML Rap won one of the main prizes in the “Video Contest” part of the XML Challenge. Enjoy…

The International DB2 Users Group (IDUG) are an independent, not-for-profit, user-run organization. If you work with DB2, you should certainly be a member of IDUG. Basic membership is FREE, and they offer some of the best resources for DB2 users.

I see from an article on XML Journal that IDUG has announced seven winners of its global XML Challenge. The challenge had more than 70,000 entries from North America, Europe, China, Southeast Asia and India. Congratulations to the winners:

  • Renzo Nuccitelli from Sao Jose dos Campos, Brazil who captured first place in the “XML Programming” contest.
  • Anil Mahadev from Karnataka, India who won the “Ported Application” contest.
  • Yasuhiro Nonaka from Tokyo, Japan who won the “Query Challenge” contest.
  • Zaidan Alaoui from Ontario, Canada and Vibha Pandya from Maharashtra, India who won the “Gadget Challenge” contest.
  • Rahsheen Porter from Grayson, Geo. (USA) and Rendra Setiawan from Jakarta, Indonesia who won the “Video Mania” contest.

If you want a teaser for upcoming DB2 pureXML features, you can listen to a short developerWorks podcast. In the podcast, Scott Laningham talks to Cindy Saracco about DB2 pureXML. The 10-minute talk covers XML, DB2 pureXML, industry standards, and more. It includes coverage about the DB2 pureXML features that are currently in development. You can hear the podcast at:

DB2 pureXML Cookbook

April 10, 2009

I’m delighted to let you know about an upcoming book from two of IBM’s leading pureXML experts—Matthias Nicola and Pav Kumar-Chatterjee. In this book, they take the reader from simple introductions all the way through advanced scenarios. They do this with a hands-on approach that includes more than 700 practical examples. It includes samples for SQL/XML, XQuery, Java, .NET, COBOL, PL/1, C, PHP, and Perl. But best of all, the authors include best practices, tips & tricks, performance guidelines, and other gems that are not documented elsewhere. You can pre-order the DB2 pureXML Cookbook from Amazon.

DB2 pureXML Cookbook