TPC-H

The TPC Benchmark H (TPC-H) is a decision support benchmark designed and maintained by the Transaction Processing Performance Council (TPC). 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.

For more information, a full spec and a data generation utility, see the TPC-H pages at the TPC website.

WRITEME: What's interesting about; link to the "lessons learned" paper (or have some pages about that); what do the different queries "check" in a DBMS, perhaps have a page for each of the queries? describe the table layout, the FK-PK relations, etc. etc.