New OLTP Benchmark Released

Transaction Processing processing software

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 for more information on the TPC-E benchmark.

Sponsored post

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.