Channels ▼

Ken North

Dr. Dobb's Bloggers

Benchmarking Analytics Software

April 14, 2010

Recent blog postings about the extended set-theoretic data model and set-store architecture prompted an e-mail from Ralph Stout, the artist and one-time chief scientist at Information Builders.

Ralph found extended set theory provided a sizeable performance advantage after he ran benchmarks of IBM DB2, Oracle and David Childs' XSP software.The benchmarks that Ralph conducted were to compare database solutions for analytical processing, not transaction processing, CRM, social networking or other applications. During a seminar at Microsoft Research, David Childs discussed some of Ralph's findings about performance for TPC-H Query 9.

Video (duration 1:10:52) Using Extended Set Theory for High Performance Database Management

Ralph's e-mail said:

When I was at Information Builders, I ran a series of benchmarks designed to contrast the performance of Childs' XSP software with that of DB2 and Oracle -- the leading analytical DBMSs at that time. The results were stunning: XSP consistently outperformed these systems by a factor of 40 or more. While many of my colleagues dismissed these findings as simply too good to be true, others remained curious. The more we looked into the matter, the more puzzled we were about a demo that Childs had cobbled together to illustrate a point. We concluded that a fine-tuned implementation of the program might easily have achieved a two- or three-fold additional performance improvement. This led us to the further conclusion that the remarkable results that XSP had achieved had more to do with its rigorous mathematical underpinnings than anything else. It is this aspect of XSP that enables it, for example, to restructure data on the fly to suit the requirements of whatever query comes its way. No other DBMS, so far as I know, can do that.

Ralph Stout

Ralph's artwork is on display at the Carrie Haddad gallery in Hudson, New York.Ralph Stout found extended set theory provided a sizeable performance advantage after he ran benchmarks of IBM DB2, Oracle and Childs' XSP software.

Related Reading

More Insights

Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.