IoT
Software // Enterprise Applications
News
3/23/2007
06:50 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

New Database Benchmark Closes Loopholes That Made Tests Unrealistic

The new benchmark uses real data and mimics the more complicated transactions that are typical today.

Build a benchmark to compare product performance, and someone's going to find a loophole. But recent work to update the 15-year-old standard for comparing performance of databases should make the results a much more meaningful reflection of today's complex transactions.

The benchmark--TPC-E, from the vendor-sponsored Transaction Processing Performance Council--uses real publicly available data, such as names from the U.S. Census and trading data from the New York Stock Exchange, to arrive at a transactions-per-minute measure. It requires handling several different types of data in a multistep transaction.

TPC-E sought to close loopholes in its predecessor, TPC-C, which specified steps of a transaction to be executed by a system but left implementation to each vendor. That led to shortcuts, such as tests that searched for masses of user names that all began with the same two letters, or tests that retrieved highly similar data from just one section of the database. Those shortcuts yielded results better than any real user could expect.

The old benchmark mimicked a straightforward retail order from a warehouse. TPC-E replicates a stock trade through a brokerage house, with several complex steps along the way.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
Building A Mobile Business Mindset
Building A Mobile Business Mindset
Among 688 respondents, 46% have deployed mobile apps, with an additional 24% planning to in the next year. Soon all apps will look like mobile apps – and it's past time for those with no plans to get cracking.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
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 July 17, 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.