{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,1]],"date-time":"2026-06-01T20:34:44Z","timestamp":1780346084668,"version":"3.54.1"},"reference-count":23,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2013,8,27]]},"abstract":"<jats:p>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, without the complexity of defining indexes or materialized views on those tables. But DB2 BLU is much more than just a column store. Exploiting frequency-based dictionary compression and main-memory query processing technology from the Blink project at IBM Research - Almaden, DB2 BLU performs 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 processed simultaneously via SIMD (single-instruction, multipledata) instructions. Designed and built from the ground up to exploit modern multi-core processors, DB2 BLU's hardware-conscious algorithms are carefully engineered to maximize parallelism by using novel data structures that need little latching, and to minimize data-cache and instruction-cache misses. Though DB2 BLU is optimized for in-memory processing, database size is not limited by the size of main memory. Fine-grained synopses, late materialization, and a new probabilistic buffer pool protocol for scans minimize disk I\/Os, while aggressive prefetching reduces I\/O stalls. Full integration with DB2 ensures that DB2 with BLU Acceleration benefits from the full functionality and robust utilities of a mature product, while still enjoying order-of-magnitude performance gains from revolutionary technology without even having to change the SQL, and can mix column-organized and row-organized tables in the same tablespace and even within the same query.<\/jats:p>","DOI":"10.14778\/2536222.2536233","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1080-1091","source":"Crossref","is-referenced-by-count":197,"title":["DB2 with BLU acceleration"],"prefix":"10.14778","volume":"6","author":[{"given":"Vijayshankar","family":"Raman","sequence":"first","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Gopi","family":"Attaluri","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ronald","family":"Barber","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Naresh","family":"Chainani","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"David","family":"Kalmuk","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Vincent","family":"KulandaiSamy","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jens","family":"Leenstra","sequence":"additional","affiliation":[{"name":"IBM Systems &amp; Technology Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Sam","family":"Lightstone","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Shaorong","family":"Liu","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Guy M.","family":"Lohman","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tim","family":"Malkemus","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rene","family":"Mueller","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ippokratis","family":"Pandis","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Berni","family":"Schiefer","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"David","family":"Sharpe","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Richard","family":"Sidle","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Adam","family":"Storm","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Liping","family":"Zhang","sequence":"additional","affiliation":[{"name":"IBM Software Group"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2013,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367892"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.5555\/645927.672367"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/2336664.2336678"},{"key":"e_1_2_1_4_1","volume-title":"Blink: Not your father's database! In BIRTE","author":"Barber R.","year":"2011","unstructured":"R. Barber, P. Bendel, M. Czech, O. Draese, F. Ho, N. Hrle, S. Idreos, M.-S. Kim, O. Koeth, J.-G. Lee, T. T. Li, G. M. Lohman, K. Morfonios, R. Mueller, K. Murthy, I. Pandis, L. Qiao, V. Raman, R. Sidle, K. Stolze, and S. Szabo. Blink: Not your father's database! In BIRTE, 2011."},{"key":"e_1_2_1_5_1","volume-title":"Business analytics in (a) blink","author":"Barber R.","year":"2012","unstructured":"R. Barber, P. Bendel, M. Czech, O. Draese, F. Ho, N. Hrle, S. Idreos, M.-S. Kim, O. Koeth, J.-G. Lee, T. T. Li, G. M. Lohman, K. Morfonios, R. Mueller, K. Murthy, I. Pandis, L. Qiao, V. Raman, R. Sidle, K. Stolze, and S. Szabo. Business analytics in (a) blink. IEEE Data Eng. Bull., 2012."},{"key":"e_1_2_1_6_1","volume-title":"IBM Systems Magazine","author":"Bestgen R.","year":"2007","unstructured":"R. Bestgen and T. McKinley. Taming the business-intelligence monster. IBM Systems Magazine, 2007."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1409360.1409380"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/318898.318923"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/602259.602261"},{"key":"e_1_2_1_10_1","volume-title":"The SAP HANA database - an architecture overview","author":"F\u00e4rber F.","year":"2012","unstructured":"F. F\u00e4rber, N. May, W. Lehner, P. Gro\u00dfe, I. M\u00fcller, H. Rauhe, and J. Dees. The SAP HANA database - an architecture overview. IEEE Data Eng. Bull., 35(1), 2012."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.50910"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247525"},{"key":"e_1_2_1_13_1","unstructured":"IBM. DB2 with BLU acceleration. Available at http:\/\/www- 01.ibm.com\/software\/data\/db2\/linux-unix-windows\/db2- blu-acceleration\/."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453925"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2463708"},{"key":"e_1_2_1_16_1","volume-title":"CIDR","author":"Li Y.","year":"2013","unstructured":"Y. Li, I. Pandis, R. Mueller, V. Raman, and G. Lohman. NUMA-aware algorithms: the case of data shuffling. In CIDR, 2013."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/128765.128770"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2008.4497414"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/582095.582099"},{"key":"e_1_2_1_20_1","volume-title":"BTW","author":"Stolze K.","year":"2009","unstructured":"K. Stolze, V. Raman, R. Sidle, and O. Draese. Bringing BLINK closer to the full power of SQL. In BTW, 2009."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.5555\/1083592.1083658"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687671"},{"key":"e_1_2_1_23_1","volume-title":"Vectorwise: Beyond column stores","author":"Zukowski M.","year":"2012","unstructured":"M. Zukowski and P. A. Boncz. Vectorwise: Beyond column stores. IEEE Data Eng. Bull., 35(1), 2012."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2536222.2536233","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,23]],"date-time":"2024-10-23T22:35:34Z","timestamp":1729722934000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2536222.2536233"}},"subtitle":["so much more than just a column store"],"short-title":[],"issued":{"date-parts":[[2013,8]]},"references-count":23,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2013,8,27]]}},"alternative-id":["10.14778\/2536222.2536233"],"URL":"https:\/\/doi.org\/10.14778\/2536222.2536233","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2013,8]]}}}