Email this article   Print article 

New OLTP Benchmark Released

By Marc Spiwak, CRN
March 19, 2007    3:53 PM ET

The Transaction Processing Performance Council (TPC) on Monday released TPC Benchmark E (TPC-E), the successor to the industry-standard TPC-C benchmark for comparing online transaction processing (OLTP) performance in hardware and software configurations.

VARs and businesses refer to the TPC benchmarks to assess the performance level of products such as high-end servers. The TPC-C benchmark has been in use for 14 years, during which time computer applications and hardware performance have changed dramatically. TPC-E was designed to reflect such changes and be better-aligned for future use by employing a more modern workload. The new benchmark also is less expensive to run and performs an audit faster, according to the TPC.

One of the main goals of TPC-E was to use a fresher database that would more accurately represent today's real-world applications and OLTP systems. The TPC-E database is populated with data distributions based on 2000 U.S. and Canada census data and actual listings on the New York Stock Exchange and Nasdaq. It follows a financial business model with a server-centric workload, a strong database focus and rich transaction set.

Whereas TPC-C represented a business model of a wholesale supplier organized by warehouses, districts and customers, TPC-E's model represents a brokerage house organized by customers, accounts and securities. The benchmark can be scaled to represent the workloads of different sizes of businesses by varying the number of customers defined for the brokerage firm.

TPC-E joins other active benchmarks such as TPC-H, used in decision support for ad hoc queries, and TPC-App, which measures transactional workloads for business-to-business Web services. Because of its popularity, TPC-C probably won't be retired for years to come. Go to www.tpc.org/tpce/tpc-e.asp for more information on the TPC-E benchmark.

The TPC is a nonprofit corporation that provides transaction processing and database benchmarks for objective, verifiable performance data. Its members include Advanced Micro Devices, Bull, Dell, Fujitsu, Fujitsu Siemens, Hewlett-Packard, Hitachi, IBM, Ingres, Intel, Microsoft, NEC, Netezza, Oracle, Sun Microsystems, Sybase, Teradata and Unisys.

MARC SPIWAK is a technical editor for the CRN Test Center.


Email this article   Print article 

More Components & Peripherals

Recent Articles

10 Hot Items From CES 2012 Opening Night

CRN provides a look at 10 items that caught our eye on opening night of CES 2012.

10 Weird, Wacky And Wonderful Things To See At CES 2012

CRN takes a look at the weirdest, wackiest, and intriguing products and events happening at this year's CES.

25 Must-See Products At CES 2012

It's that time of year again. Here are 25 hot items on tap for the 2012 Consumer Electronics Show.

  More Slide Shows




Related Videos
Loading...