TPC photo
The TPC defines transaction processing and database benchmarks and delivers trusted results to the industry
 TPC Benchmarks
 TPC Documentation
 Technical Articles
 Related Links
 What's New
 About the TPC
 Who We Are
 Contact Us
 Join the TPC
 Document Search

 Member Login


TPC Benchmark‚ĄĘDS (TPC-DS): The New Decision Support Benchmark Standard

The current TPC-DS specification can be found on the TPC Documentation Webpage.

TPC-DS is the new decision support benchmark that models several generally applicable aspects of a decision support system, including queries and data maintenance. Although the underlying business model of TPC-DS is a retail product supplier, the database schema, data population, queries, data maintenance model and implementation rules have been designed to be broadly representative of modern decision support systems.

This benchmark illustrates decision support systems that:
  • Examine large volumes of data
  • Give answers to real-world business questions
  • Execute queries of various operational requirements and complexities (e.g., ad-hoc, reporting, iterative OLAP, data mining)
  • Are characterized by high CPU and IO load
  • Are periodically synchronized with source OLTP databases through database maintenance functions

TPC-DS Version 2 is the next major release of TPC's decision support benchmark. It includes changes that enables Hadoop based systems to execute the benchmark. The major changes in Version 2 are in the area of ACID (Atomicity, Consistency, Isolation and Durability), data maintenance and metric calculation.

Instead of requiring ACID TPC-DS Version 2 requires a much relaxed version of Durability, which is referred to as Data Accessibility. Data maintenance has been reduced to the fact tables, i.e. sales, returns and inventory tables. TPC-DS Version 2 does not require updates, only inserts and deletes. Also, the execution rules of data maintenance has been modified to separate the execution of queries from that of data maintenance. The metric in Version 2 has been changed from being an arithmetic mean of load, single user, multi user and data maintenance to a geometric mean of the same components.

The most recent draft of Version 2 of TPC-DS is now available for review. To leave comments, please do so here and use TPC-DS-2.0 in the project pulldown menu.

Additional Information

to top of page

   Home     Benchmark Results     Current Benchmarks     Documentation     Join The TPC     What's New     Sign Up For Information     Current Status Report     Contact Us     Privacy Policy     About Pricing   

Valid XHTML 1.0 Transitional Valid CSS!