Select a topic or year
ARMONK, NY - 29 Nov 2007: IBM (NYSE: IBM) today announced that its recently introduced E7100 Balanced Warehouse(TM), consisting of the IBM POWER6(TM) processor-based System p(TM) 570 server, the IBM System Storage(TM) DS4800 and DB2(R) Warehouse 9.5, is already lapping the field in performance. The new data warehousing solution is now ranked number one in both performance and in price/performance in the TPC-H business
"These latest benchmark results further prove IBM's strength and leadership in the business intelligence arena," said Scott Handy, vice president of marketing and strategy, IBM Power Systems. "The E7100 Balanced Warehouse is a complete data warehousing solution comprised of pre-tested, scalable and fully integrated system and storage components, designed to get customers up and running quickly to get to the real benefit of unprecedented business insight and intellect."
With expanded solutions optimized to meet the entire spectrum of warehousing requirements, IBM recently added the E7100 Balanced Warehouse to its E-Class portfolio, which is optimized for large scale enterprise data warehouses. The E7100 Balanced Warehouse exploits POWER6 technology in System p on AIX®, IBM's UNIX® operating system, along with IBM System Storage DS4800 and DB2 Warehouse. This offering can accommodate higher levels of concurrency as well as significant fluctuations in workload, providing ultimate scalability and performance for the most demanding enterprise data warehouses.
IBM has done the hard work for customers by creating a base data warehouse module that has balanced price/performance with the appropriate amount of CPU cores and memory for 2 terabytes (TB) of storage -- nothing more or less than is needed for each. Then IBM created higher performing 2TB data server modules and other optional modules that can easily be added to snap together larger data warehouses that are also balanced in performance with the appropriate CPU, memory and storage. One base module with 24 2TB add-on data server modules can easily be configured, ordered and installed to create a 50TB balanced warehouse. Customers working with IBM have built balanced data warehouses of over 300TB or more using these pre-tested, pre-configured building blocks.
DB2 Warehouse 9.5 breaks new ground in business intelligence, delivering an industry-first combination of advanced, embedded analytics and high performance that enables organizations to gain greater value from their information that was previously unavailable from conventional data warehouse products.
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 these 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.
The TPC benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.
The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size), and reflects multiple aspects of the capability of the system to process queries. These aspects include the selected database size against which the queries are executed, the query processing power when queries are submitted by a single stream, and the query throughput when queries are submitted by multiple concurrent users. The TPC-H Price/Performance metric is expressed as $/QphH@Size.
About IBM System p servers
Renowned for their computing power, IBM System p servers support user needs across a broad range of applications, including transaction processing, web publishing, data mining, systems management and others. This family of 1-to 64-core IBM Power processor-based systems is designed to provide customers with features for high performance, scalability and dynamic resource allocation, together with leadership features designed for high availability. Unique IBM virtualization features allow users to process more information on a single server, creating the potential to save on total cost of system ownership, as well as space and energy costs.
System p products are designed for smaller and mid-sized business and large enterprises that are using UNIX platforms. The servers support both the AIX and Linux® operating systems. Migration services enable customers to quickly and easily convert from competing platforms -- such as Sun Microsystems and Hewlett-Packard -- to IBM hardware.
System p servers are powered by IBM's leadership technology, including for certain systems the POWER6 microprocessor, the world's fastest chip, built using IBM's state-of-the-art 65 nanometer process technology. At 4.7GHz, the dual-core POWER6 processor doubles the speed of the previous generation POWER5 while using nearly the same amount of electricity to run and cool it, meaning customers can use the new processor to either increase their performance by 100 percent or cut their power consumption virtually in half.
For more information on IBM System p servers and offerings, please visit http://www.ibm.com/systems/p/
About DB2 Warehouse
IBM DB2 Warehouse 9.5 -- based on the DB2 9 "Viper" data server -- is the foundation of IBM's dynamic warehousing initiative, and includes a unique set of features and capabilities that support growing customer demand for analytics and Information on Demand. DB2 Warehouse provides data movement and transformation capabilities to reduce the complexity and lower the costs typically associated with loading data into the warehouse and preparing that data so that it can be leveraged more effectively. It also offers performance optimization capabilities that enable the warehouse to address broad enterprise warehousing requirements, such as advanced data partitioning and workload management to ensure that the most critical applications are serviced accordingly. Additionally, DB2 Warehouse takes advantage of Viper's deep compression technology to increase performance and efficiency, while reducing storage costs.
For more information, please visit www.ibm.com.
System i, System p, System x, System z, BladeCenter, and Supercomputers
Information Management, Lotus, Tivoli, Rational, WebSphere, Open standards, open source
1 IBM TPC-H 10000GB result on the IBM System p 570 of 343,551.2 QphH@10000GB ($32.89/QphH, avail. 4/15/2008) on a 32 node cluster of p570 (64 POWER6 4.7 GHz processor chips, 128 cores, 256 threads) with 24 MB L3 cache per processor chip and 32 GB of memory per node running DB2 Warehouse 9.5 on AIX 5L V5.3. Total disk capacity was 110,489.27 GB in a IBM Totalstorage DS4800 storage subsystem and the cluster was networked via one Integrated 10Gigabit Ethernet.
2 HP TPC-H 10TB result on the 128-core HP Integrity Superdome (64 processor chips, 128 threads) with Oracle 10g (171,380 Queries per hour QphH@10000GB, 32.91$/QphH, configuration available 04/01/07).
3 Sun TPC-H 10TB result on the 144-core Sun Fire E25K (72 processor chips, 144 threads) with Oracle 10g (108,099 Queries per hour QphH@10000GB, 53.80$/QphH, configuration available 01/23/06).
4 http://www.tpc.org/tpch/results/tpch_result_detail.asp?id=107101501 Source: http://www.tpc.org; Results current as of 11/29/07.
IBM is a trademark of IBM Corporation in the United States and/or other countries. All other company/product names and service marks may be trademarks or registered trademarks of their respective companies.
TPC-H is a trademark of the Transaction Processing Performance Council.
UNIX is a registered trademark in the United States and other countries licensed exclusively through The Open Group.
Linux is a trademark on Linus Torvalds.