 |
|
|
|
|
| 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.
|
|
|
|
 |
| The current version of TPC-H is Version 2.8.0 Click on the preferred format below to download: |
|
|
 |
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 |
|
|
| |
 |
| This Benchmark refers to the pricing specification. |
|
|
|
|
