IBM DB2 Delivers World's First 10 Terabyte Business Intelligence Benchmark Result
December 13, 2002
IBM Announces The World's First 10 Terabyte Business Intelligence Benchmark Result
Based on the data warehouse industry standard TPC-H benchmark, IBM set the worldwide record, delivering a 10-terabyte business intelligence performance benchmark. Ten terabytes of data is equal to the size of the entire printed collection of the U.S. Library of Congress, or to three billion pages of single-spaced text, which laid end-to-end, would encircle the earth 20 times.
According to Winter Corporation, large data warehouses are projected to grow 169 percent by 2004. According to the firm, based on a recent survey of companies with large databases, data warehouses containing at least 10 terabytes of data is expected to grow rapidly within he next two years. Other analysts believe that by 2004, enterprises will need to process 30 times as much data as they handled three years ago. With these benchmark results, IBM demonstrates DB2 combined with the pSeries eServer has the ability to keep up with this growth, providing rapid response for complex query workloads on a very large scale.
Five eServer p690 servers, each with 32 POWER 4 microprocessors, and IBM's DB2 database version 8.1 delivered the TPC-H benchmark result, signaling a new milestone in enterprise data warehousing and demonstrating the extreme scalability of a p690 cluster running with DB2.
TPC-H measures the performance of decision support systems to examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions. The test is a standard benchmark defined by the Transaction Processing Performance Council (TPC), an industry group whose members include most of the largest computer system and database companies worldwide.
The IBM solution produced a TPC-H result at the 10TB database size of 62,214.7 QphH@10000GB with a price/performance, $266/QphH@10000GB on a cluster of five p690's running AIX 5L V5.2 with DB2 UDB 8.1. In the recent years, IBM's DB2 has demonstrated outstanding benchmark results in the areas 100GB, 300GB, 1TB, 3TB, and now 10GB. For more information about IBM's TPC-H benchmark results, as well as the full disclosure report, visit http://www.tpc.org/results/FDR/tpch/p690_10000GB_160proc_FDR.pdf.