Book description
IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies. Different from other vendor solutions, BLU Acceleration allows the unified computing of online transaction processing (OLTP) and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple, fast, and easy-to-use solution for the needs of today's organizations; quick access to business answers can be used to gain a competitive edge, lower costs, and more.
This IBM Redbooks® publication introduces the concepts of DB2 with BLU Acceleration. It discusses the steps to move from a relational database to using BLU Acceleration, optimizing BLU usage, and deploying BLU into existing analytic solutions today, with an example of IBM Cognos®. This book also describes integration of DB2 with BLU Acceleration into SAP Business Warehouse (SAP BW) and SAP's near-line storage solution on DB2. This publication is intended to be helpful to a wide-ranging audience, including those readers who want to understand the technologies and readers who have planning, deployment, and support responsibilities.
Table of contents
- Front cover
- Notices
- Preface
-
Chapter 1. Introducing DB2 BLU Acceleration
- 1.1 DB2 with BLU Acceleration
-
1.2 BLU Acceleration: Seven Big Ideas
- 1.2.1 Big Idea 1: Simplicity and ease of use
- 1.2.2 Big Idea 2: Column store
- 1.2.3 Big Idea 3: Adaptive compression
- 1.2.4 Big Idea 4: Parallel vector processing
- 1.2.5 Big Idea 5: Core-friendly parallelism
- 1.2.6 Big Idea 6: Scan-friendly memory caching
- 1.2.7 Big Idea 7: Data skipping
- 1.2.8 The seven big ideas in action
- 1.3 Next generation analytics: Cognos BI and DB2 with BLU Acceleration
- 1.4 IBM DB2 with BLU Acceleration Offerings
- 1.5 Obtaining DB2 with BLU Acceleration
- Chapter 2. Planning and deployment of BLU Acceleration
-
Chapter 3. Optim Query Workload Tuner and BLU Acceleration
- 3.1 Common use cases for IBM InfoSphere Optim Query Workload Tuner
- 3.2 Prerequisites
- 3.3 Prepare an empty DB2 10.5 database with current objects and statistics using db2look
- 3.4 Step 1: Capture existing workloads for analysis
- 3.5 Step 2: Manage a list of captured workloads
- 3.6 Step 3: Run Workload Table Organization Advisor
- 3.7 Step 4: Review the table organization summary
- 3.8 Running the conversion recommendations from the Advisor
- 3.9 Optional: Selecting your own candidate tables for conversion analysis
- Chapter 4. Performance test with a Cognos BI example
- Chapter 5. Post-deployment of DB2 with BLU Acceleration
-
Chapter 6. DB2 with BLU Acceleration and SAP integration
- 6.1 Introduction to SAP Business Warehouse (BW)
- 6.2 Prerequisites and restrictions for using BLU Acceleration in SAP BW
- 6.3 BLU Acceleration support in the ABAP Dictionary
-
6.4 BLU Acceleration support in the DBA Cockpit
- 6.4.1 Checking whether individual tables in SAP database are column-organized
- 6.4.2 Checking if SAP database contains column-organized tables
- 6.4.3 Monitoring columnar data processing time in the SAP database
- 6.4.4 Monitoring columnar processing-related prefetcher and buffer pool activity in the SAP database
- 6.5 BLU Acceleration support in SAP BW
- 6.6 Deployment
- 6.7 Preferred practices: SAP BW on BLU Acceleration
- 6.8 BLU Acceleration for SAP near-line storage solution on DB2 (NLS)
- Appendix A. New BLU Acceleration monitor elements
- Related publications
- Back cover
-
IBM System x Reference Architecture for Hadoop: IBM InfoSphere BigInsights Reference Architecture
- Introduction
- Business problem and business value
- Reference architecture use
- Requirements
- InfoSphere BigInsights predefined configuration
- InfoSphere BigInsights HBase predefined configuration
- Deployment considerations
- Customizing the predefined configurations
- Predefined configuration bill of materials
- References
- The team who wrote this paper
- Now you can become a published author, too!
- Stay connected to IBM Redbooks
- Notices
Product information
- Title: Architecting and Deploying IBM DB2 with BLU Acceleration in Your Analytical Environment
- Author(s):
- Release date: June 2014
- Publisher(s): IBM Redbooks
- ISBN: None
You might also like
book
IBM DB2 Web Query for i Version 2.1 Implementation Guide
Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes …
book
Architecting and Deploying DB2 with BLU Acceleration
IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, …
book
Db2 for z/OS Utilities in Practice
As IBM® continues to enhance the functionality, performance, and availability of IBM Db2®, the utilities have …
book
Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature
The IBM® DB2® pureScale® feature offers clustering technology that helps deliver high availability and exceptional scalability …