© 2014 ibm corporation db2 with blu acceleration next generation in-memory

© 2014 IBM Corporation

DB2 with BLU Acceleration Next Generation In-Memory

www.ibmBLUhub.com

© 2014 IBM Corporation2 www.ibmBLUhub.com

Disclaimer© Copyright IBM Corporation 2014. All rights reserved.U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON IBM'S CURRENT PRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUT NOTICE. IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR REPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR SOFTWARE.

IBM's statements regarding its plans, directions, and intent are subject to change or withdrawal without notice at IBM's sole discretion. Information regarding potential future products is intended to outline our general product direction and it should not be relied on in making a purchasing decision. The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information about potential future products may not be incorporated into any contract. The development, release, and timing of any future features or functionality described for our products remains at our sole discretion.

IBM, the IBM logo, ibm.com, Information Management, DB2, DB2 Connect, DB2 OLAP Server, pureScale, System Z, Cognos, solidDB, Informix, Optim, InfoSphere, and z/OS are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml

Other company, product, or service names may be trademarks or service marks of others.

http://www.ibm.com/legal/copytrade.shtml


DB2 with BLU AccelerationRich capability integrated with IBM DB2 10.5

What is DB2 with BLU Acceleration? In-memory analytic database Multiple IBM innovations

- In-memory processing of columnar data without the limitations of memory size

- Analyze compressed data with actionable compression

- CPU Acceleration- …and more

Ready for Analytics: Cloud, On premise, SAP, Cognos, and more

Agile warehousing via BLU for Cloud

Analyze more data faster and more efficiently

Fast Answers. Simply Delivered.


Introducing DB2 “Cancun Release”

Get real-time answers to ALL questions with instant insight into historical and “as it happens” data

Change the economics of continuous availability with broad infrastructure choices at every price point

Improve performance of transactions and analytics while reducing complexity and overhead

Get fast time-to-value using skills you already have for Oracle database

Superior performance at lower cost for SAP environments

Get the answers you need in the moment

IBM DB2


Instant insight from real-time operational data for growing revenue, reducing cost and lowering risk

35x to 73x faster analytics, with some queries running more than 1400x faster1,2

Next generation in-memory with IBM Research innovations

Simplified IT landscape with reporting and transactions in the same system

No need for indexes, aggregates or tuning Operational simplicity with “load and go” performance

Available for on-premises or via the cloud “In one of our largest customer databases, we saw compression ranging from 7x to 20x

as compared to the uncompressed tables ” - Mike Petkau, Director of Database Architecture & Administration, TMW Systems

Simple, low-risk upgrade from Oracle Database1 Based on internal IBM testing of sample client analytic workloads comparing queries accessing row-based tables on DB2 10.1 vs. columnar tables on DB2 10.5 with BLU Acceleration. Performance improvement figures are cumulative of all queries in the

workload. Individual results will vary depending on individual workloads, configurations and conditions.2 Based on internal IBM tests of analytic workloads comparing queries accessing row-based tables on DB2 10.1 vs. columnar tables on DB2 10.5 with BLU Acceleration. Results not typical. Individual results will vary depending on individual workloads,

configurations and conditions, including size and content of the table, and number of elements being queried from a given table..


The Benefits of DB2 with BLU Acceleration for Analytics

Fast

Simple Agile

DB2 with BLU Acceleration


BLU Shadow Tables

Instant insight into operational data without compromising transaction performance

DB2 creates column-based ‘Shadow Table’ versions of row-based operational data

Analytic queries are seamlessly routed to Shadow Tables to take advantage of BLU Acceleration analytics performance in the transaction processing environment

With BLU Shadow Tables, the performance of analytical queries can improve by 10x or more, with equal or greater transactional performance*. In one instance, the removal of secondary analytic indexes improved transactional performance by 2x**


Reporting and Transactions in the same continuously available system

FastTransactions

FastAnalytics

Query OptimizationOne

Database

Row

Oriented

Tables

Column

Oriented

Shadows

Automatic Incremental

Sync

* - Based on internal IBM testing of sample transactional and analytic workloads by replacing 4 secondary analytical indexes in the transactional environment with BLU Shadow Tables. Performance improvement figures are cumulative of all queries in the workload. Individual results will vary depending on individual workloads, configurations and conditions.** - Based on internal IBM testing of sample transactional and analytic workloads by replacing 20 secondary analytical indexes in the transactional environment with BLU Shadow Tables. Performance improvement figures are cumulative of all queries in the workload. Individual results will vary depending on individual workloads, configurations and conditions.


Early client quotes for DB2 “Cancun Release”

“We tested BLU Acceleration on DB2 and found our typical analytics workload performed significantly faster. In fact, one query was 1551x faster. That’s a jaw-dropping improvement. We actually triple-checked the results to make sure it was for real, and it was . . . WOW!” - Mike Petkau - Director of Database Architecture & Administration

“In the telecom business, reporting on data as it is happening is critical to our clients success. We need to be able to run complex reports directly on our transactional data to provide a competitive advantage for our business. Shadow Tables, in the DB2 Cancun Release, gives us that ability. They are simple to create and very easy to manage and our end users are now reporting directly on our OLTP data without having to add in a separate BI system.” – Paul Peters, Lead Database Administrator, VSN Systemen BV


Extraordinary Speed

“With BLU Acceleration, we’ve been able to reduce the time spent on pre-aggregation by 30x - from one hour to two minutes! BLU Acceleration is truly amazing.

- Yong Zhou, Sr. Manager of Data Warehouse & Business Intelligence Department

“With my analytic query workload running 45x times faster with BLU Acceleration in DB2 10.5, I no longer have an excuse for my usual coffee run!”

- Iqbal Goralwalla, Head of DB2 Managed Services, Triton

"Teaming with our SAS actuaries, we gave them a different way to run their analysis which included the BLU Acceleration technology. The result? They experienced incredible speedup in their analysis, one report ran 640x times faster and another ran 1200x faster."

- Randy Wilson, Lead DB2 for LUW DBA, BCBS of Tennessee

Fast

Simple Agile



Extraordinary Simplicity

- Ruel Gonzalez, Information Services, DataProxy LLC

- Kent Collins, Database Solutions Architect, BNSF Railway

“On top of the great storage savings and huge performance gains, one of the things that impressed us the most about BLU Acceleration is its simplicity. No need to define indexes or aggregates. We just load the data and run queries.”

“DB2 BLU Acceleration is all it says it is. Simplicity at its best, the “Load and Go!” tagline is all true. We didn’t have to change any of our SQL, it was very simple to setup, and extremely easy to use. Not only did we get amazing performance gains and storage savings, but this was achieved without extra effort on our part.”

- Brenda Boshoff, Senior DBA, University of Toronto

“The simplicity that BLU Acceleration provides is remarkable. … From the time we started to install DB2 10.5 with BLU, until we were running queries faster than in production, it took us less than 3 hours!”

Fast

Simple Agile



Extraordinary Agility

"The economics of BLU Acceleration are really going to help our bottom line. We were able to migrate off of Sybase IQ and onto DB2 Advanced Workgroup Server Edition running on just 4 cores in a virtualized Linux environment. The simplicity of BLU Acceleration will save us time and money…”

- Hervé Huberiant, Logistic and IT Director, Cora Belux

"What makes DB2 BLU technology so special is that the in memory analytics and column organization of tables is all done right inside DB2. No new skills are required, and I can have column organized and row organized tables side by side in the same database.”- Joachim Klassen, Consultant, LIS.TEC

"We were seeing average acceleration of 7.4X with some queries going from 28 seconds down to sub second response time. This was clear evidence of the advantage of combining the column store organization of tables and performing in-memory analytics directly on compressed data in BLU without having to decompress the data to perform the analytics.”

- Philip Kallander, Chief Technical Architect, Handelsbanken

Fast

Simple Agile



What makes BLU Acceleration different?Unmatched innovations from IBM Research & Development labs

Instructions Data

Results

C1 C2 C3 C4 C5 C6 C7 C8C1 C2 C3 C4 C5 C6 C7 C8

Next Generation In-Memory In-memory columnar processing with dynamic movement of data from storage

Analyze Compressed DataPatented compression technique that preserves order so data can be used without decompressing

CPU AccelerationMulti-core and SIMD parallelism

(Single Instruction Multiple Data)

Data SkippingSkips unnecessary processing of irrelevant data

Encoded

http://www-03.ibm.com/systems/power/





BLU Acceleration illustration10TB query in seconds or less

The System: 32 cores, 1TB memory, 10TB table with 100 columns and 10 years of data The Query: How many “sales” did we have in 2010?

- SELECT COUNT(*) from MYTABLE where YEAR = ‘2010’ The Result: In seconds or less as each CPU core examines the equivalent of just 8MB of data

The System: 32 cores, 1TB memory, 10TB table with 100 columns and 10 years of data The Query: How many “sales” did we have in 2010?

- SELECT COUNT(*) from MYTABLE where YEAR = ‘2010’ The Result: In seconds or less as each CPU core examines the equivalent of just 8MB of data

10TB data

Analyze Compressed Datareduces to 1TB

In-memory

Parallel Processing32MB linear scan on each core via

CPU Acceleration Scans as fast as

8MB through SIMD

Result in seconds or less

Column Processingreduces to 10GB

Data Skippingreduces to 1GB

DATA

DATA

DATA

DATA

DATA

DATA

DATA

DATA

DATA

DATA DATA DATA

DATADATA DATA

© 2014 ibm corporation db2 with blu acceleration next generation in-memory

Documents

ibm db2

ibm corporation db2

ibm logo

current list of ibm

ibm trademarked terms

trademark information

information management

potential future products