Links

Tags

Recent tweets

BLU Compression Changes the Game!

Last week we ran a twitter chat about compression in the new DB2 10.5 with BLU Acceleration. If you took part, you’ll agree with me that this is a very popular topic!

To lead up to a twitterchat, we gather articles and blog entries to build a reading list. We also ask our influencers to write about the topic. With a little help from our friends, we were able to achieve greatness.

One of our twitterchat contributors, Tom Rieger, was so inspired that he wrote a whole article about the topic. It has now been published ibmdatamag.com: “Rethinking Compression - IBM DB2 with BLU Acceleration streamlines storage and access of columnar data in an ecosystem of optimization”.

The second big idea behind BLU Acceleration pertains to how DB2 encodes and compresses data and the way that it ―packs‖ the CPU registers. This topic is thoroughly covered in the first chapter of this book that was released in electronic format. Here are a few quotes from this chapter:

The folks at IBM marketing refer to this as actionable compression, but it‘s also known as delayed or late materialization: the ability to operate on the data while it’s still compressed (yes, you read that right).

With BLU Acceleration, you can operate on the data while it’s still compressed

BLU Acceleration gives better I/O because the data is smaller, which leads to more density in the RAM, optimized storage, and more efficient CPU because we‘re operating on the data without decompressing it and packing that data in the CPU ―registered aligned.

Being able to compress data as much as possible, compress the most commonly occurring data, and then optimally pack it at register widths reveals the synergy that lies at the core of this big idea.

BLU Acceleration can scan and operate on compressed data without needing to decompress it.

Compression is a hallmark of BLU Acceleration technology, not just because of the storage savings delivered, but because its vector-processing engine operates on compressed values. Better compression results in better query performance.

Be sure to download your chapter from this flashbook: DB2 10.5 with BLU Acceleration and learn from the authors Paul Zikopoulos, Matthew Huras, Sam Lightstone, George Baklarz, and Aamer Sachedina.

Video: Actionable Compression in DB2 10.5 with BLU Acceleration

Paul Zikopoulos talks with Master Inventor Sam Lightstone in this video called “Actionable Compression in DB2 10.5 with BLU Acceleration”. BLU compression allows you to work on the data while the data is still compressed. This is changes the game! Find out more by watching video.