The University of Arizona

Events & News


DateMonday, May 12, 2014
Time3:00 pm
Concludes4:00 pm
LocationGould-Simpson 942
DetailsPlease join us for coffee and light refreshments at 2:45pm in the 9th Floor Atrium.

Faculty Host: Rick Snodgrass
SpeakerGuy Lohman
AffiliationDisruptive Information Management Architectures,IBM Almaden Research Center

DB2 with BLU Acceleration: So Much More than Just a Column Store

As enterprises amass large data “warehouses” of transactional data, they have increasingly sought to analyze that data for trends and exceptions that will provide insights leading to profitable and actionable business decisions. Concomitantly, Moore’s Law has continued to reduce the cost of DRAM and CPU cores, shifting the focus of research on these so-called “Business Intelligence” (BI) queries from largely disk-based to predominantly main-memory and highly parallelized algorithms that exploit these characteristics of modern commodity hardware, and from row-organized to column-organized tables. This talk will describe the “secret sauce” by which IBM’s new BLU Acceleration, which was released last June within DB2 Version 10.5 for Linux, UNIX, and Windows, exploits these trends in hardware to speed BI queries by 10 to 50 times and improve compression by 3 to 10 times, compared to traditional row-organized tables, without requiring the user to define auxiliary access structures on those tables, such as indexes or materialized views. Full integration with DB2 ensures that DB2 with BLU Acceleration also benefits from the full functionality and robust utilities of a mature product and permits enterprises to migrate to this revolutionary technology without having to modify applications by permitting queries to reference both column-organized and row-organized tables.


Dr. Guy M. Lohman is Manager of Disruptive Information Management
Architectures in the Advanced Information Management Department at IBM
Research Division's Almaden Research Center in San Jose, California,
where he has worked for 32 years. He currently manages the Blink
research project, which contributed BLU Acceleration to DB2 for Linux,
UNIX, and Windows (LUW) 10.5 (GA'd 2013) and the query engine of the IBM
Smart Analytics Optimizer for DB2 for z/OS V1.1 and the Informix
Warehouse Accelerator products (2007-2010). Dr. Lohman was the architect
of the Query Optimizer of DB2 LUW and was responsible for its
development from 1992 to 1997 (versions 2 - 5), as well as the invention
and prototyping of Visual Explain, efficient sampling, the DB2 Index
Advisor, and optimization of XQuery queries in DB2. Dr. Lohman was
elected to the IBM Academy of Technology in 2002 and made an IBM Master
Inventor in 2011. He was the General Chair for ACM's 2013 Symposium on
Cloud Computing and is the General Co-Chair of the 2015 IEEE
International Conference on Data Engineering (ICDE). Previously, he was
on the editorial boards of the "Very Large Data Bases Journal" and
"Distributed and Parallel Databases". He is the author of over 75 papers
in the refereed academic literature, and has been awarded 39 U.S.
patents. His current research interests involve disruptive machine
architectures for Business Intelligence, advanced data analytics, query
optimization, self-managing database systems, information management
appliances, database compression, and autonomic problem determination.