Reconsidering TPC Database Performance Benchmarks - InformationWeek
Software // Information Management
12:42 PM
Doug Henschen
Doug Henschen
Connect Directly
Building Security for the IoT
Nov 09, 2017
In this webcast, experts discuss the most effective approaches to securing Internet-enabled system ...Read More>>

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."

1 of 2
Comment  | 
Print  | 
More Insights
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
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Twitter Feed
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