DB2 11 : The Database for Big Data & Analytics.

The landscape of today's business is shaped by the mountains of data being produced, with rapid growth in the volume, variety, and velocity of data due to the explosion of smart devices, mobile applications, cloud computing, and social media. Much of this growth has been in unstructured data; h...

Full description

Saved in:
Bibliographic Details
Main Author: Molaro, Cristian
Other Authors: Parekh, Surekha, Purcell, Terry, Stuhler, Julian
Format: Electronic eBook
Published: Ketchum : MC Press, 2013.
Online Access:Click to View
Tags: Add Tag
No Tags, Be the first to tag this record!
Table of Contents:
  • Front Cover
  • Title Page
  • Copyright
  • Contents
  • About the Authors
  • Introduction by Surekha Parekh
  • DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics by Julian Stuhler, Triton Consulting
  • DB2 11 for z/OS: The Database for Big Data and Analytics
  • Efficiency
  • CPU Reductions
  • zEC12 Exploitation
  • Application Compatibility
  • Transparent Archiving
  • Temporal Data Enhancements
  • Global Variables
  • Variable Arrays
  • Java Stored Procedure Enhancements
  • pureXML Enhancements
  • Optimizer and Query Performance Improvements
  • Data Sharing Performance Enhancements
  • Utility Enhancements
  • Other Efficiency Enhancements
  • Resilience
  • Extended Log Record Addressing: Current Issues
  • Extended Log Record Addressing: DB2 11 Enhancements
  • Enhanced Dynamic Schema Change
  • BIND/REBIND Enhancements
  • Security Enhancements
  • Other Resilience Enhancements
  • Business Analytics
  • SQL Aggregation Improvements
  • IBM DB2 Analytics Accelerator Enhancements
  • Hadoop and Big Data Support
  • QMF 11
  • Other Enhancements for Analytics Workloads
  • Upgrading to DB2 11
  • DB2 Version Prerequisites
  • Other Prerequisites
  • Upgrade Timing
  • Upgrade Process and Impact
  • DB2 11 Customer Case Studies
  • BMW Group
  • Stadtwerke Bielefeld GmbH
  • JN Data
  • Improved Query Performance in DB2 11 for z/OS by Terry Purcell
  • Predicate Indexability
  • Duplicate Removal
  • Hash Join and Sparse Index
  • Page Range Screening and Indexing for Partitioned Table Spaces
  • RUNSTATS Enhancements
  • Additional Performance Improvements
  • Summary
  • IBM DB2 Utilities and Tools with DB2 11 for z/OS by Haakon Roberts
  • How DB2 for z/OS Can Help Reduce Total Cost of Ownership by Cristian Molaro
  • Business Needs and DB2 TCO
  • DB2 and TCO
  • Reducing TCO Through Synergy with System z
  • DB2 Synergy with System z
  • Reducing TCO Through CPU Savings.
  • DB2 10 CPU Savings and Performance Improvements
  • DB2 10 Performance Expectations
  • DB2 11 CPU Savings and Performance Improvements
  • DB2 11 Performance Expectations
  • Specialty Engines
  • DB2 10 and Specialty Engines
  • DB2 11 and Specialty Engines
  • Estimating zIIP Savings
  • Special Considerations for High zIIP Utilization
  • DB2 and zAAP on zIIP
  • Reducing TCO with Better Performance
  • Identifying Better Performance Opportunities
  • Getting Better Performance with REBIND
  • DB2 Plan Management
  • DB2 11 APREUSE(WARN) Enhancement
  • DB2 11 RELEASE(DEALLOCATE) Optimization
  • DB2 11 Application Compatibility and APPLCOMPAT
  • Case Study: Performance Benefits of REBIND
  • DB2 EXPLAIN At a Glance
  • DB2 10 High-Performance DBATs
  • Reducing TCO Through Storage Savings
  • DB2 Data Compression
  • DB2 Managed Disk Space Allocation
  • Case Study: Combined Effects of Data Compression and DB2 Managed Disk Space Allocation
  • Index Compression
  • Reducing TCO with Faster Analytics
  • IBM DB2 Analytics Accelerators
  • Leverage Legacy QMF Objects
  • Reducing TCO with Improved Scalability
  • DB2 10 Throughput Enhancements
  • DB2 Storage and Scalability
  • Data Sharing Member Consolidations
  • Conclusion.