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.
In May 2011, Dell and Ingres published three (3) TPC-H results. Two were on the PowerEdge R910 that smashed the 300 GB and 1 TB single-node world record performance, and a third was on the PowerEdge R610 that topped the HP ProLiant DL380 G7 in performance, at half the price/performance! These were obtained with VectorWise 1.6, a breakthrough analytic database product from Ingres.Here are how these results stack up against their nearest competitors:
***Table of top-performing TPC-H non-clustered performance results as of June 3 2011. For a list of full results, please visit www.tpc.org/tpch.
In April 2011, Dell and EXASOL published seven (7) TPC-H results with unparalleled performance and price/performance in a variety of database sizes: 100 GB, 300 GB, 1 TB, 3 TB, and 10 TB. These results were obtained using the Dell PowerEdge R710 running the EXASolution 4.0 database. These results are summarized in this Dell PowerNote (1-page PDF for easy distribution).To show how truly groundbreaking these results are, see how these results compare in performance and price/performance versus the closest competitor:
***Table of Top Dell EXASOL TPC-H performance results versus previous top-performing results as of April 12 2011. For a list of full results, please visit www.tpc.org/tpch.For more information about these results, see the Dell press release. There is also a YouTube video talking about these results: