TPC-H (100 GB Database) Result

Published: January 31, 2003 | Updated: July 20, 2004

Details on this benchmark:

Operating system

Windows Server 2003, Enterprise Edition

Performance

5,618 QphH@100GB

Price-performance

897.00 China Yuan (CNY) per QphH@100GB

Hardware

Langchao SP3000

Total system cost

5,041,227 China Yuan (CNY)

System availability

April 14, 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 data warehouses.


Top of pageTop of page