Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 13, 2002

IBM DB2 Delivers World's First 10 Terabyte Business Intelligence Benchmark Result

By DatabaseJournal.com Staff

IBM Announces The World's First 10 Terabyte Business Intelligence Benchmark Result
IBM eServer p690 and DB2 Database Delivers Unmatched Performance, Lowest Total Cost of Ownership

IBM today announced the world's first 10-terabyte performance benchmark for business intelligence applications using IBM's DB2 database software running on a cluster of IBM eServer systems.

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.

Back to Database Journal Home

Database News Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM