Reconsidering TPC Database Performance Benchmarks - InformationWeek
IoT
IoT
Software // Information Management
Commentary
9/3/2010
12:42 PM
Doug Henschen
Doug Henschen
Commentary
Connect Directly
LinkedIn
Twitter
Google+
RSS
E-Mail
50%
50%

Reconsidering TPC Database Performance Benchmarks

Some say they are abstract if not downright misleading. But TPC benchmarks remain the only available standardized test of total-system performance and cost. Use them with caution.

Benchmarks can be incredibly useful. But the trust and value placed in such measures tends to increase with their independence from the products measured.

Take, for example, Energy Star efficiency specifications. Developed by the Environmental Protection Agency in 1992, Energy Star measures have since been heartily embraced by electronic equipment manufacturers and consumers alike.

Ditto Insurance Institute for Highway Safety (IIHS) vehicle tests. Some manufacturers initially complained about IIHS ratings, but now these ratings routinely show up in advertising.

Back in the mid 1980s, computer hardware manufacturers and database vendors recognized the need for standardized performance benchmarks for systems rather than individual components, such as disk drives and CPUs. Thus the Transaction Processing Performance Council was born.

Created and funded by vendors, the TPC formed committees to agree on standardized benchmark tests and procedures. And to ensure validity and consistency, the TPC established bylaws, policies, auditing procedures, test documentation requirements and more.

Today there are three core TPC benchmarks. TPC-C, the original and still most widely used benchmark, measures online transaction processing performance. TPC-H measures ad-hoc decision-support (analytic data mart/data warehouse) systems. The relatively new TPC-E benchmark simulates the OLTP workloads of a brokerage firm.

TPC also publishes standardized pricing and energy-consumption specifications that cut across all three benchmarks. The pricing specification details three-year total cost of ownership including hardware, software and maintenance. The energy-consumption specification was created in 2009 and shows up in the most recently published tests.

All recent benchmark test results are available online without restriction and at no cost. What's more, you can download executive summary reports with complete cost and energy-consumption detail as well as full reports with audited documentation on the complete test procedure.

This all sounds like a pretty good deal for would-be database buyers seeking unbiased insight on products. But the TPC benchmarks aren't without critics. Database expert and Intelligent Enterprise contributor Curt Monash wrote last year that most TPC benchmarks are "run on absurdly unrealistic hardware configurations."

Monash questioned one highly publicized TCP-H test result that was based on 32-to-1 disk-to-data ratio. He pointed out that production systems with good compression would likely run at closer to a 1-to-1 ratio.

Indeed, one of the weaknesses of the TPC program is that database and computer hardware vendors -- the members of the organization -- are free to test and publish results (or not) when and how they please.

"This is a voluntary organization, so we can't force people to publish benchmarks," explains Michael Majdalany, the TPC Administrator (equivalent to Executive Director). "The majority of vendors in the market do participate and publish benchmarks... [but] some established vendors don't feel the need to publish benchmarks because their attitude is that their customers known them already."

Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
Annual IT Salary Report 
Base pay for IT professionals has remained flat this year with a median annual salary of $88,000 for staff and $112,000 for management. However, 58% of staff and 62% of managers who responded to our survey say they're satisfied with their compensation. Download this report to find out which positions earn the highest compensation.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll