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