Blending Big Data analytics-enabling technology into the company’s database offering, IBM revealed the availability of IBM DB2 10.5 with a set of acceleration technologies called BLU Acceleration.
BLU has significant benefits for the analytic and reporting workloads and can make database management system better suited for running large in-memory data analysis jobs. BLU Acceleration is capable of up to 25 times speed up report generation and analysis than traditional approach.
The technology, established by research and development divisions of IBM, is implementing an innovative feature of the dynamic analysis of a resident in the DB2 database, running with IBM SmartCloud. This technology is designed to help businesses and government agencies to operate with the big data.
With DB2 10.5, you have the option to insert data into the database as columnar-ordered data sets that compress the data as it is being loaded. Because of the high compression rate, DB2 can work with more data in memory than before.
IBM said some queries achieved an almost 100 times speedup with literally no tuning. The queries registered average acceleration of 7.4 times, with some queries going from 28 seconds down to sub-second response time. ERP and accounting software applications reports run on DB2 BLU Acceleration reported up to 40 times faster turnaround time.
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, IBM says. With DB2 10.5, you have the option to insert data into the database as columnar-ordered data sets that compress the data as it is being loaded. Because of the high compression rate, DB2 can work with more data in memory than before.
As reported by the developers in the technology BLU Acceleration implemented dynamic memory-resident processing columns, providing improved performance analysis (as we are assured by representatives of the company – to 25-fold), and scalability for the benefit of working with big data, without the constraints imposed by traditional resident systems. The implementation of technology on the principle of “Load and go” allows clients to analyze the mechanisms of fast-acting transparently for their applications, without having to create a separate layer of data modeling.
IBM also implemented a parallel vector processing (data analysis performed simultaneously on different processors) and compression, eliminating the need to decompress the data to be analyzed.
This database provides a wide range of supported servers, storage and virtualization technologies, and products used to deploy ERP solutions. IBM DB2 reduces the response time of ERP application (in particular SAP) by up to 40%, reduces the need of SAP resource storage by up to 70%, and reduces energy costs, administration and hardware state of the company.
IBM recently announced its solutions and services dedicated to big data analysis of employee data with the key to improved organizational performance. The big data analytics offering analyze real-time data about their employees: demographic information, salary, and years of service, etc.
Interesting stuff in terms of the change in the speed of the response, quite severe.