DB2 11 : The Database for Big Data & Analytics.
Title:
DB2 11 : The Database for Big Data & Analytics.
Author:
Molaro, Cristian.
ISBN:
9781583473887
Personal Author:
Physical Description:
1 online resource (129 pages)
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.
Abstract:
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; however, by 2020, internet business transactions-business-to-business and business-to-consumer-are predicted to reach 450 billion per day. Smart organizations are seeking innovative ways to turn this explosion of data, called big data, into actionable insights. This book explores the attributes that make IBM's DB2 11 for z/OS the ideal database for big data and business-critical analytics in the new era of computing. It is packed with rich information about features and business benefits of the relational database management system's newest software release, including even more out-of-the-box CPU savings, enhanced resiliency, capabilities to excel at business-critical analytics, and simpler, faster upgrades for quicker return on investment (ROI). Find out why DB2 is the database of choice for big data and analytics by top businesses around the world.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View