Dynamic in-memory technology loads terabytes of data in Random Access Memory instead of hard disks. This streamlines query workloads even when data sets exceed the size of the memory.
Columnar store scans and locates the most relevant data based on columns instead of rows, resulting in faster processing.
Actionable compression enables data to be analyzed in compressed format.
Parallel vector processing provides multi-core and multiple data parallelism, allowing you to analyze data in parallel over different processors.
Data skipping skips unnecessary processing of irrelevant or duplicate data, loading only the information that needs to be analyzed.
DB2 with BLU Acceleration
IBM DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and volume.
Analytics at the speed of thought
DB2 with BLU Acceleration combines advanced, innovative capabilities to accelerate analytic workloads for databases and data warehouses.
DB2 with BLU Acceleration also integrates with IBM Cognos® Business Intelligence to provide reporting and deeper analysis. You can analyze key facts and freely explore information from multiple angles and perspectives to make more informed decisions—all from within DB2.
Less data storage required
DB2 with BLU Acceleration dynamically moves data from storage. Database tuning, indexes and aggregates are not needed, which improves storage efficiency and helps lower your storage space requirement. In fact, clients have reported compression rates of 10 times that of un-compressed tables.i
The system uses available hardware such as memory, I/O and CPU to help reduce memory latency and processing. Hardware optimization streamlines administration and maintenance, putting less load on resources.
BLU Acceleration is fully integrated with DB2. It does not require SQL or schema changes to implement. Just load and go. Enhancements such as automation, optimization and self-tuning help to further simplify overall use.
“ When we compared the performance of column-organized tables in DB2 to our traditional row-organized tables, we found that, on average, our analytic queries were running 74x faster when using BLU Acceleration. ”
- Kent Collins, Database Solutions Architect, BNSF Railway
Try DB2 for Linux, UNIX and Windows for free for up to 90 days.
Experience the world-class functionality that DB2 has to offer.
DB2 with BLU Acceleration Resources
Find solutions, industry reports, white papers, videos and more
i Client-reported testing results in DB2 10.5 early release program. Individual results will vary depending on individual workloads, configurations and conditions, including table size and content.