DB2 with BLU acceleration: So much more than just a column store

DB2 with BLU Acceleration deeply integrates innovative new techniques for defining and processing column-organized tables that speed read-mostly Business Intelligence queries by 10 to 50 times and improve compression by 3 to 10 times, compared to traditional row-organized tables, with-out the complexity of defining indexes or materialized views on those tables. But DB2 BLU is much more than just a col-umn store. Exploiting frequency-based dictionary compres-sion and main-memory query processing technology from the Blink project at IBM Research- Almaden, DB2 BLU per-forms most SQL operations – predicate application (even range predicates and IN-lists), joins, and grouping – on the compressed values, which can be packed bit-aligned so densely that multiple values fit in a register and can be pro