Benchmark for 1TB Transactional XML System

November 3, 2008

IBM continues to openly benchmark its DB2 pureXML capabilities.  Last week at the Information On Demand Conference in Las Vegas, Intel and IBM released details of their latest joint benchmark.  The goal of the benchmark is to show the performance levels that you can expect for inserts, updates, deletes, and queries on transactional XML data.  This latest benchmark is with 1TB of XML data using the FIXML standard industry format.  The results are very interesting.  Thanks to the way that DB2 stores XML data, the XML data occupies less than 450GB of disk space when stored in DB2.  If you compare the results of this benchmark against previous benchmarks, you can see that the addition of 50% more processing cores provides 48% more throughput (at lower CPU utilization rates), indicating a nice scale-out story.  Intel actually measured a 4-CPU server, with 6 cores per CPU, processing more than 6700 XML-based TPoX transactions per second.  One of the key aspects of the benchmark is the minimal amount of database tuning needed to obtain these results. For more details, including hardware specifications and database configuration, see the presentation from the conference.


3 Responses to “Benchmark for 1TB Transactional XML System”

  1. […] 5, 2008 As you saw in my previous post, IBM DB2 has spectacular performance numbers when benchmarking with XML data. As a reminder, DB2 […]

  2. it is always nice to see IBM’s achievement’s, although i will never forgive them for what they did to OS/2 and bunch of other labs projects that never had a light.

    what i don’t understand is why IBM keeps being an ass and still produce ugly development tools. To do simple things with DB2, even under windows it’s a pain in the ass process that rarely ends in a good way.

    i love to see great xml handling, but if you wont provide normal tools for developers….

  3. Ah, the OS/2 saga. I wasn’t working for IBM at the time, but remember it well. The fact that OS/2 was originally a joint collaboration between two companies (IBM and Microsoft) with very different cultures and conflicting business drivers probably didn’t provide a solid foundation. But the bottom line is that unfortunately OS/2 failed to catch on in the market. It’s such a pity. We can add it to the list of better technologies that did not win in the market (like NeXT, Netscape, etc.).

    Regarding tools for DB2… IBM recognizes that database tools in general need attention. This is an industry-wide issue. One of the key issues is that database tools have evolved, with new capabilities being added on top of other new capabilities over time. This created a frankenstein-like environment in many tools. Another issue is that tools for managing data across its lifecycle are not integrated. (This is akin to the situation in development before development tools were integrated.)

    The good news is that IBM is currently making a big investment in its tools for data management. IBM is developing an integrated set of tools for data management (similar to the way that Rational integrated development tools). This means that you don’t have separate tools for separate tasks. It also means that the workflows across these separate tasks are streamlined. The user interfaces will be redesigned, with usability the key consideration. Not only that, but the tools will manage data across a number of databases including DB2, Oracle, and others.

    A lot of people here at IBM are very excited by these developments, because we believe they will make a real difference for people in a lot of roles that deal with data. (By the way, these integrated data management tools include a marriage of DB2 tools, Optim tools, Data Studio tools, and Rational Data Architect.)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: