If you didn’t know, BLU acceleration technology offers dramatic reductions in query latency for databases through a variety of innovations. Chief among them are the storage of frequently accessed data in memory as opposed to disk, as well as the use of columnar tables to boost data reading efficiency. BLU also cuts storage requirements with actionable compression, which allows data to be processed in its compressed state. Furthermore, the POWER platform confers numerous additional benefits to DB2 BLU such as advanced multithreading capabilities (up to 8 threads per POWER8 processor core, 4 times what x86 processors offer), memory bandwidth (4 times what’s commonly available on x86) and processor cache (5 times more than x86), all of which enable DB2 BLU to move more data through the processor more quickly.
One of the nicer features of BLU is its ability to accelerate existing row based databases. You aren’t required to use DB2; to begin to realize its benefits, all you have to do is connect a BLU acceleration engine to your existing database (DB2, Oracle, MySQL, MariaDB … whatever) and point your applications to the BLU instance instead of your database. BLU will automatically begin caching and accelerating your relational DBMS.
BLU has been available on Power in AIX environments for some time now, but the availability of the technology in Linux on Power brings some new capabilities that customers have been asking for. This is because, unlike BLU for AIX, BLU for Linux on Power runs natively in little endian mode like many existing data warehouses running on commodity x86. This means that to realize the unique benefits of BLU on Power, you no longer have to migrate your legacy database to a big endian environment. In addition, little endian Linux support makes BLU on Power a great fit for heterogeneous cloud environments.
There are some serious benefits to running BLU on Power. Our internal testing has shown that when compared to traditional database queries running on x86, BLU on Power can deliver results 82 times faster across a variety of report complexities. In particular, complex analytics reports that take many hours to complete on commodity database technology execute in mere seconds with BLU on Power.
The utility of this should be obvious. Not only can you save significant time and resource when running the analytics reports that your business already depends on, but you can also ask deeper and more frequent questions of your business data, exploring possibilities in real time to find new opportunities to grow your business. If you have data trapped in commodity database technology, you really owe it to yourself to investigate what BLU for Linux on Power can deliver for your business.
For more information: