Informix Software, the database company, has announced the setting of a world record in the 1000GB TPC-H benchmark on a single-node system, setting industry-leading marks for speed and accuracy.
The benchmark was run using Informix Extended Parallel Server (XPS) version 8.31.FD1, the company`s high-end data warehouse offering. It was running on Hewlett-Packard`s HP 9000 Superdome Enterprise Server equipped with 64 552MHz PA-RISC 8600 CPUs using the 64-bit HP-UX 11i operating environment and the HP Surestore Disk Array XP512. This combination delivered a composite query per hour rating of 9754.5 QphH@1000GB at a price/performance mark of $985 QphH@1000GB.
"Informix does not run these benchmarks to score points against opposition," says Simon Jeggo, country manager for Informix South Africa. "Rather, they are run as practical indications of what can be achieved in real-world situations, which is what customers are looking for.
"This particular test is important for customers looking to deploy large-scale data warehousing," Jeggo continues. "As TPC-H measures performance in responding to unpredictable and demanding ad hoc queries, it represents one of the most reliable benchmarks in evaluating a database`s strengths in meeting the demands of decision support environments. XPS`s ability to handle complex mixed load queries demonstrates its fundamental advantages in delivering customers a robust data warehouse or operational data store."
XPS is designed to meet the increasingly challenging requirements of business-critical, enterprise-wide data warehousing, as it enables fast data loading and comprehensive data management. Based on "shared nothing architecture", XPS offers near-linear scalability while supporting virtually any query or schema design. In addition, XPS supports large data warehouses on both SMP and parallel architectures, such as clusters, NUMA and MPP.
The benchmark configurations used in this TPC-H evaluation included: Single-node HP 9000 Superdome Enterprise Server; 64 CPUs; 96GB memory; Disk 10,182TB; HP-UX 11i 64-bit operating environment; Database server: Informix XPS 8.31.FD1; QphH@1000: 9754,5; $/QphH@1000: $985
All of the software and hardware deployed in the benchmark test are commercially available today.
Share