IBM today announced strong client and business partner support for the new version of its DB2 database software, now generally available. The new software — which represents the work of hundreds of IBM developers and researchers in labs around the world — adds game-changing technology called BLU Acceleration that makes it simpler, more economical and dramatically faster to analyze massive amounts of data.
As organizations face a flood of data generated by computers, mobile devices, sensors and social networks, they’re under unprecedented pressure to analyze much more data at faster speeds and lower costs. BLU Acceleration enables users to have much faster access to key information.
Among the companies worldwide that have experienced strong results from the new IBM software is the large northern Europe bank Handelsbanken. “We were very impressed with the performance and simplicity of BLU. We found that some queries achieved an almost 100 times speedup with literally no tuning. We were seeing average acceleration of 7.4 times, with some queries going from 28 seconds down to sub-second response time,” said Lennart Henang, IT Architect at Handelsbanken.
Yonyou Software Co. in Beijing is a leading enterprise management software and cloud service provider. According to Jianbo Liu, IT performance manager at Yonyou, “ERP and accounting software applications run a lot of reports. We used DB2 BLU Acceleration and saw our reports run faster by up to 40 times. This type of technology is an ideal fit for Yonyou’s Big Data Analytic Services.”
“The feedback we’re hearing from clients and partners illustrates that we’re providing an innovative and powerful yet simple solution that can ingest huge amounts of data and apply insights from all this data at the point of impact,” said Bob Picciano, General Manager, IBM Information Management. “IBM’s work with beta clients and internal tests show significant speed and simplicity. In one example, BLU Acceleration was shown to be 10 times faster than another well-known in-memory database system. Some queries that took 7 minutes were shown to have dropped to 8 milliseconds, thanks to the innovations in BLU Acceleration.”
The new IBM DB2 10.5 with BLU Acceleration aims for analytics at the speed of thought with a range of made-in-IBM-Labs advances to significantly speed analytic workloads for databases and data warehouses:
• Dynamic in-memory technology that loads terabytes of data in Random Access Memory, which streamlines query workloads even when data sets exceed the size of the memory.
• “Actionable Compression,” which allows analytics to be performed directly on compressed data without having to decompress it – some customers have reported as much as 10 times storage space savings.
• An innovative advance in database technology that allows DB2 to process both row-based and column-based tables simultaneously within the same system. This allows much faster analysis of vast amounts of data for faster decision-making.
• The simplicity to allow clients access to blazing-fast analytics transparently to their applications, without the need to develop a separate layer of data modeling or time consuming data warehouse tuning
• Integration with IBM Cognos Business Intelligence Dynamic Cubes to provide breakthrough speed and simplicity for reporting and analytics. Companies can analyze key facts and freely explore more information faster from multiple angles and perspectives to make more informed decisions.
• The ability to take advantage of both multi-core and single instruction multiple data (SIMD) features in IBM POWER and Intel x86 processors
“The whole concept behind DB2 with BLU Acceleration is really quite fascinating,” said Andrew Juarez, a lead database administrator at Coca Cola Bottling Co. Consolidated. “I really appreciate the approach of giving me all the benefits of a columnar database in harmony with a row-store within the same database. What IBM also has done that’s so special with BLU Acceleration is it enables us to deliver strong performance, even if the entire data set won’t fit into memory. That’s important because in a Big Data world, I might not be able to fit all of my data into memory, even with very high compression ratios. DB2 gives me a single solution for a vital business goal: deliver faster analytics to our users.”
“We moved from Oracle Database to DB2 in April 2008,” Juarez added. “Before moving to DB2, our database was 950 GB and sustained a 35 GB-per-month growth rate. Just by moving to DB2, the growth rate slowed to 15 GB/month. Today our database is smaller than it was in 2008. Just when I thought things couldn’t get any better, BLU Acceleration came along.”
Iqbal Goralwalla, head of DB2 Managed Services at Triton Consulting of Norwich, UK, said, “I was quite anxious when I installed DB2 10.5 with BLU Acceleration on my Linux Intel server, which really does not have a large amount of RAM, nor does it have the latest processors. The results surprised me. My analytic workload ran 45 times faster. This is because with BLU Acceleration, not only can the data be larger than the amount of available RAM, but DB2 is also very effective at keeping the data in memory and was performing the data analytics directly on compressed data.”
The breakthrough speed and simplicity of BLU Acceleration is a complement to the existing transactional performance leadership of DB2 on Power System. DB2 takes advantage of Power System’s industry leading multi-threading, cache size and memory bandwidth to deliver top speed and processing efficiency for both transactional and analytics workloads.