05178nam 22006251 450 991045336570332120200520144314.01-58347-388-2(CKB)2550000001138716(EBL)1507337(OCoLC)868976998(SSID)ssj0001155690(PQKBManifestationID)11651535(PQKBTitleCode)TC0001155690(PQKBWorkID)11188616(PQKB)11557196(MiAaPQ)EBC1507337(Au-PeEL)EBL1507337(CaPaEBR)ebr10796499(CaONFJC)MIL538386(EXLCZ)99255000000113871620131205h20132013 uy 0engurcnu||||||||txtccrDB2 11 database for big data and analytics /Cristian Molaro [and three others]Boise :MC Press,[2013]©20131 online resource (129 p.)Description based upon print version of record.1-58347-385-8 1-306-07135-6 Includes bibliographical references.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 EnhancementsOther 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 GroupStadtwerke Bielefeld GmbHJN 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 SavingsDB2 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) OptimizationDB2 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<P style=""MARGIN: 0in 0in 0pt; tab-stops: 246.0pt"" class=MsoNormal>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, iDatabase managementRelational databasesElectronic books.Database management.Relational databases.650.02855369Molaro Cristian957643MiAaPQMiAaPQMiAaPQBOOK9910453365703321DB2 112169095UNINA