TPC
  
Submit Search
Advanced Search
photo
TPC Mission Statement
Home
Results
Benchmarks
Technical Articles
Related Links
What's New
About the TPC
Who We Are
Member Login
Contact Us
Quick Links
 

 

 

 

 

TPC-H
TPC-H is an ad-hoc, decision support benchmark.

View Results

Summary
The TPC Benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.

The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size), and reflects multiple aspects of the capability of the system to process queries. These aspects include the selected database size against which the queries are executed, the query processing power when queries are submitted by a single stream, and the query throughput when queries are submitted by multiple concurrent users. The TPC-H Price/Performance metric is expressed as $/QphH@Size.
TPC-H Current Version
The current version of TPC-H is Version 2.8.0 Click on the preferred format below to download:
TPC-H Tools
The TPC-H (Ad-hoc, decision support) benchmark represents decision support environments where users don't know which queries will be executed against a database system; hence, the "ad-hoc" label. Pre-knowledge of the queries may not be used to optimize the DBMS system. Consequently, query execution times can be very long.

DBGEN and QGEN and Reference Data Set
 
Related Spec
This Benchmark refers to the pricing specification.

 

to top of page
Home   Results   Benchmarks   Technical Articles   Related Links   What's New   About the TPC   Who We Are   Privacy Policy   About Pricing   Contact Us