DB2 10.5 with BLU Acceleration New Dynamic In-Memory Analytics for the Era of Big Data

UPGRADE TO THE NEW GENERATION OF DATABASE SOFTWARE FOR THE ERA OF BIG DATA!

If big data is an untapped natural resource, how do you find the gold hidden within? Leaders realize that big data means all data, and are moving quickly to extract more value from both structured and unstructured application data. However, analyzing this data can prove costly and complex, especially while protecting the availability, performance and reliability of essential business applications.

In the new era of big data, businesses require data systems that can blend always-available transactions with speed-of-thought analytics. DB2 10.5 with BLU Acceleration provides this speed, simplicity, and affordability while making it easier to build next-generation applications with NoSQL features, such as a mongo-styled JSON document store, a graph store, and more. Dynamic in-memory columnar processing and other innovations deliver faster insights from more data, and enhanced pureScale clustering technology delivers high-availability transactions with application-transparent scalability for business continuity.

With this book, you'll learn about the power and flexibility of multiworkload, multi-platform database software. Use the comprehensive knowledge from a team of DB2 developers and experts to get started with the latest DB2 trial version you can download at ibm.com/developerworks/downloads/im/db2/.

Stay up to date on DB2 by visiting ibm.com/db2/.

Introduction
Chapter 1: All Aboard! 15-Minute DB2 10.5 Tour Starts Here
What Was Delivered: A Recap of DB2 10.1
DB2 10.1 Delivered Performance Improvements
DB2 10.1 Delivered Even Lower Storage Costs
DB2 10.1 Delivered Improved Availability and Scalability
DB2 10.1 Delivered More Security for Multitenancy
DB2 10.1 Delivered the Dawn of DB2 NoSQL Support
DB2 10.1 Delivered Even More Oracle Compatibility
DB2 10.1 Delivered Temporal Data Management
Introducing DB2 10.5: The Short Tour
DB2 with BLU Acceleration
A Final Thought Before You Delve into the Wild BLU Yonder
DB2 pureScale Goes Ultra HA, DR, and More…
DB2 as a JavaScript Object Notation Document Store
Oracle Compatibility
Tools, Tools, Tools
Wrapping It Up…
Chapter 2: DB2 pureScale Reaches Even Higher
In Case It’s Your First Time… Recapping DB2 pureScale
You Can Put DB2 pureScale in More Places
DB2 pureScale Gets Even More Available
DB2 pureScale Gets High Availability Disaster Recovery
Keep on Rolling, Rolling, Rolling: DB2 Fix Pack Updates Go Online
Adding Members Online
Cross-Topology Backup and Restore
Workload Consolidation in a DB2 pureScale Environment
Explicit Hierarchical Locking
Wrapping It Up…
Chapter 3: BLU Acceleration: Next-Generation Analytics Technology Will Leave Others “BLU” with Envy
What Is BLU Acceleration?
Next-Generation Database for Analytics
Seamlessly Integrated
Hardware Optimized
Convince Me to Take BLU Acceleration for a Test Drive
Pedal to the Floor: How Fast Is BLU Acceleration?
From Minimized to Minuscule: BLU Acceleration Compression Ratios
Where Will I Use BLU Acceleration?
How BLU Acceleration Came to Be: The Seven Big Ideas
Big Idea Number 1: KISS It
Big Idea Number 2: Actionable Compression and Computer-Friendly Encoding
Big Idea Number 3: Multiplying the Power of the CPU
Big Idea Number 4: Parallel Vector Processing
Big Idea Number 5: Get Organized…by Column
Big Idea Number 6: Dynamic In-Memory Processing
Big Idea Number 7: Data Skipping
Seven Big Ideas Optimize the Hardware Stack
When Seven Big Ideas Deliver One Incredible Opportunity
Under the Hood: A Quick Peek Behind the Scenes of BLU Acceleration
BLU Acceleration Is a New Format for the Bytes in a Table, NOT a New Database Engine
The Day In and Day Out of BLU Acceleration
Informational Constraints, Uniqueness, and BLU Acceleration
Getting the Data to BLU: Ingestion in a BLU Acceleration Environment
Automated Workload Management That Is BLU-Aware
Querying Column-Organized and Row-Organized Tables
The Maintenance-Free Life of a BLU Acceleration Table
Getting to BLU-Accelerated Tables
Ready, Set, Go! Hints and Tips We Learned Along the Way
First Things First: Do This!
Automated Memory Tuning
For Optimal Compression Results…
Data Statistics? Don’t Bother, We’ve Got It Covered
INSERT Performance
How to Skip More: Get the Most Out of Data Skipping
A NextGen Database Does Best with the Latest Hardware
Memory, Memory, and More Memory
Converting Your Row-Organized Tables into Column-Organized Tables
Wrapping It Up…
Chapter 4: Miscellaneous Performance and SQL Compatibility Enhancements
Expression-Based Indexes
Get Faster: Query Processing Before and After DB2 10.5 with Support for Index Expressions
Expression-Based Indexes Make Application Development Easier
Excluding NULL Keys from Indexes
Index NULL Exclusion Simplifies Application Development
When 2 + 2 = 4: Getting Even Richer Semantics by Combining Features
Random Ordering for Index Columns
To Random Order an Index Column or Not to Random Order an Index Column…That Is the Question
More Data on a Row: Extended Row Size
Chapter 5: Miscellaneous Availability Enhancements
Better Online Space Reclamation for Insert Time Clustering Tables
Understanding Insert Time Clustering Tables—A Primer
What’s New for Insert Time Clustered Tables in DB2 10.5
Other DB2 10.5 Reorganization Enhancements
Fastpath! Collapsing Overflow and Pointer Records
Support for Adaptive Compression with Online, In-place Reorganization
Support for ADMIN_MOVE_TABLE Routine with Referential Constraints
Wrapping It Up…
Chapter 6: DB2 10.5: New Era Applications
What’s in the NoSQL Name?
DB2 pureXML: Where DB2 First Dipped Its “Toe” in the NoSQL Pool
DB2 as a Graph Database: RDF, SPARQL, and Other Shiny Things
DB2 as a JSON Document Store
What Does JSON Look Like? JSON Document Structure
Frequent Application Changes
Flexible Data Interchange
Document Store Databases
Manipulating JSON Documents with DB2
Wrapping It Up…