By Leon Katsnelson
By Susan Visser
By Bernie Spang
By the DB2 Guys
By Fred Ho
By Louis T. Cherian
By Shweta Shandilya
By Lawrence Weber
By Serge Rielau
By Dwaine Snow
With rapid data growth straining data warehouses and analytics engines, executing business intelligence queries can be very time-consuming. But most businesses can’t wait—they need answers in real time.
IBM® Informix® Warehouse Accelerator (IWA) improves response times dramatically through proprietary compression, scalable processor cache–conscious algorithms, and highly accessible in-memory data. IWA loads warehouse data completely into system memory in a compressed form. IWA exploits 128-bit registers and Streaming SIMD Extension (SSE) technology in Intel® Xeon® processors to accelerate operations on the in-memory compressed data and scan billions of rows in seconds.
But what happens as data continues to grow? Is it necessary to increase memory capacity by purchasing increasingly high-end servers with more memory or scale out to a large cluster? Not if the organization uses IBM System x® MAX5 memory expansion technology.
MAX5 technology is designed to enhance the memory capacity of the IBM System x eX5 platform. This scalable 1U memory expansion system delivers an additional 32 DIMM slots to IBM System x3850 X5 and x3690 X5 servers powered by Intel Xeon processors. With MAX5, an organization can add 50 to 100 percent more memory to a System x eX5 server—up to a total of 6 TB per server.
Factor in IWA compression rates of as much as 5:1, and an organization can put terabytes of warehouse data completely in memory on one very cost-effective server. No additional server CPUs are needed as the warehouse scales because each MAX5 system contains a memory controller to expand memory beyond the industry standard. And Informix pricing is based on processor-value unit rather than database size, so there are no additional Informix licensing fees. The bottom line: increased business agility at low cost.
To read about IWA performance testing, visit:
DB2 TechTalk: Deep Dive on BLU Acceleration in DB2 10.5, Super Analytics Super Easy
Thursday, May 30: 12:30 – 2:00 PM ET
Big Data Seminar 2013, Featuring Krish Krishnan
June 14 in New York City
marcus evans Pharma Data Analytics Conference
July 10-11 in Philadelphia
IBM Smarter Content Summit 2013
Big Data at the Speed of Business
Broadcast event replay now available
Information on Demand 2013: Early Bird Registration Now Open
November 3-7 in Las Vegas