TPC-H (300 GB Database) Result

Published: May 20, 2003 | Updated: July 20, 2004

Details on this benchmark:

Operating system

Windows Server 2003, Enterprise Edition

Performance

6,552 QphH@300GB

Price-performance

$66 US per QphH@300GB

Hardware

IBM eServer xSeries 445 8P

Total system cost

$431,836 US

System availability

August 31, 2004

For more information, visit the TPC-H Top Ten Non-Clustered Performance list.

The Transaction Processing Performance Council (TPC), a not-for-profit organization, was founded to define transaction processing and database performance benchmarks, such as the TPC-C, TPC-H, and TPC-W benchmarks, and to disseminate objective performance data based on those benchmarks. TPC benchmarks have extremely stringent requirements, including both reliability and durability tests, and must undergo an independent audit. Council members include most major database vendors and suppliers of server hardware systems.

Companies participate in TPC benchmarking for an objective demonstration of performance in a regulated environment, and to apply technologies used in the testing process to produce more robust and scalable software and hardware products.

TPC-H simulates a decision-support system with large volumes of data, synchronized with online-production databases. It uses highly complex, ad hoc queries designed to answer real-world business questions, such as pricing and promotions, supply and demand, profit and revenue, and market share. The performance of standardized report generation is illustrated by a different benchmark, TPC-R. TPC-H and TPC-R evolved from the now-retired TPC-D benchmark.

The TPC-H benchmark has five categories: for 100 gigabyte (GB), 300 GB, 1 terabyte (TB), 3 TB, and 10 TB warehouses.


Top of pageTop of page