DB 2 10 Info Sphere Warehouse 10

Зарегистрируйтесь, чтобы просмотреть полный документ!

DB 2 10 & Info. Sphere Warehouse 10 New Features IBM Confidential until 03

IBM Confidential until 03 April 2012 Disclaimer The information contained in this presentation is provided for informational purposes only. While efforts were made to verify the completeness and accuracy of the information contained in this presentation, it is provided“as is”, without warranty of any kind, express or implied. In addition, this information is based on IBM’s current product plans and strategy, which are subject to change by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this presentation or any other documentation. Nothing contained in this presentation is intended to, or shall have the effect of: • Creating any warranty or representation from IBM (or its affiliates or its or their suppliers and/or licensors); or • Altering the terms and conditions of the applicable license agreement governing the use of IBM software. Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multiprogramming in the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 New Features of DB 2 10 and Info. Sphere Warehouse 10 DB 2 is at the core of both DB 2 10 is the underlying database! DB 2 10 Info. Sphere Warehouse 10 DB 2 database software offers industry leading performance and reliability on a choice of platform from Linux, Unix and Windows to z/OS A complete real-time data warehousing platform that delivers superior scalability and availability, design, build, and management tooling, and business analytics. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 High Performance. Low Costs. Low Operational Cost Ease of Development Reliability Parallel processing, deep compression, & automation SQL compatibility, native XML and graph stores, & cloud support High availability, fast recovery, & online utilities © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Building on the Pillars of DB 2 Low Operational Costs Ease of Development Faster Query Response SQL Compatibility enhancements Improved Index Mgmt Graph Store Adaptive Compression Row and Column Multi-Temperature Access Control Data Management Temporal Capabilities Real-time Data Warehousing Reliability DB 2 pure. Scale enhancements Workload Management Enhancements HADR Supports Multiple Standby Servers © 2012 IBM Corporation

IBM Confidential until 03 April 2012 New Release Highlights Faster business decisions – Multiple instances of 3 x faster performance for complex query workloads 1 – Real-time operational data warehousing Lower storage costs – Have seen more than one client achieve greater than 7 x overall space savings with Adaptive Compression, with some tables achieving more than 10 x space savings 2 – Multi-Temperature Data Management Improved data availability with DB 2 pure. Scale enhancements Easy switch from Oracle Database to DB 2 – Average PL/SQL compatibility moves above 98% 3 1. 2. 3. Based on internal tests of IBM DB 2 9. 7 FP 3 vs. DB 2 10. 1 with new compression features on P 6 -550 systems with comparable specifications using data warehouse / decision support workloads, as of 29 Mar 2012. Based on client testing in the DB 2 10 Early Access Program. Based on internal tests and reported client experience from 28 Sep 2011 to 07 Mar 2012. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Multiple Instances of at least 3 x Faster Query Performance Increase Ability to Meet SLAs; Postpone Hardware Upgrades Multi-core parallelism enhancements Performance improvements for: – – Queries over star schemas Queries with joins and sorts Queries with aggregation Hash joins Higher performance – Up to 35% faster out-of-the-box performance – Multiple instances of at least 3 x faster when using new features * Lower costs – Postpone hardware upgrades “IBM and Intel® have collaborated over a decade to optimize DB 2 performance with Intel® Parallel Studio 2011, software development suite on Intel® Xeon® processors. We are excited to see a ~10 x improvement in query processing performance using DB 2 10 over the previous DB 2 version, running on IBM System x 3850 using Intel® Xeon® Processor E 7. Customers can now realize dramatically greater performance boost at lower cost per query running IBM DB 2 10 on servers powered by Intel® Xeon® processors. ” —Pauline Nist, GM Software Strategies, Intel’s Datacenter & Connected Systems Group * Based on both external tests by partners, as well as internal tests of IBM DB 2 9. 7 FP 3 vs. DB 2 10. 1 with new compression features on P 6 -550 systems with comparable specifications using data warehouse / decision support workloads, as of 29 Mar 2012. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Index Management Re-defined Increase Ability to Meet SLAs; Lower Administration Costs Jump Scan Smart Index Pre-fetching Smart Data Pre-fetching Predicate Evaluation Avoidance Higher performance – Faster index performance Lower costs – Fewer indexes to maintain – Dramatic reduction in index reorgs “Jump Scan optimizes buffer usage by 75 to 80%, resulting in very good improvement in overall performance and saving the CPU cycles. ” —Shanmukhaiah D, Cognizant Technology Solutions. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Smart Index Pre-Fetching Means Easier Management DB 2 9. 7 DB 2 10 28% faster Index Page Reads (Thousands) DB 2 9. 7 Query Time (Seconds) DB 2 10 Query Time (Seconds) Results based on IBM internal testing. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 DB 2 Workload Management Increase Ability to Meet SLAs; Postpone Hardware Upgrades CPU limits – % of resources DB 2 can consume – % of limit a service class can consume – Hard shares and soft shares Available for all platforms Higher performance – Prioritize important workloads – More efficient distribution of workloads Lower cost Service Class A 30% Service Class B CPU shares 50% Other Processes 20% DB 2 Service Class C – Postpone hardware upgrades “The new Workload Manager feature helped us significantly improve performance in our production systems. This makes DB 2 an even better alternative for customers who are using other database software. " —Elvis Hsu, Technical Supervisor, STI © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Breakthrough Savings with Adaptive Compression Lower Storage Costs; Lower Administration Costs DB 2 10 Adaptive Compression DB 2 9. 1 Table Compression DB 2 9. 7 Temp Space & Index Compression Adaptively apply both table-level compression and page-level compression Table re-orgs not required to maintain high compression Compress archive logs 11 © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Adaptive Compression has provided 7 x or greater overall space savings for more than one client, with some tables achieving 10 x space savings 10 x 10 x 8 x 4 x 4 x Based on client testing in the DB 2 10 Early Access Program. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Adaptive Compression Shrinks your Data Storage Needs Higher performance – Faster queries for I/O-bound environments – Faster backups Lower costs – Postpone upcoming storage purchases – Lower ongoing storage needs – Easier administration with reduced need for table re-orgs “Page-level dynamic compression is one of the new DB 2 features that will reduce planned outages and increase storage savings by up to 2 X over DB 2 9. 7%. ” —Jessica Tatiana Flores Montiel, DAFROS Multiservicios “Our migration from Oracle Database to DB 2 resulted in a 40% storage savings. Upgrading to DB 2 9. 7 and index compression brought our average savings to 57%. Now adaptive compression brings our average savings to 77%, dramatic savings!” —Andrew Juarez, Lead SAP Basis / DBA, Coca Cola Bottling Company. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Multi-Temperature Data Management Increase Ability to Meet SLAs; Postpone Hardware Upgrades Storage pools for different tiers of storage – For range partitions, policy-based automated movement of data HOT WARM SSD RAID SAS RAID COLD SATA RAID ARCHIVE Optim Data Growth Higher performance – Improved ability to meet SLAs while retaining greater amount of data for analysis Lower costs – Embrace new lower-cost storage technology – Further reduces the cost for meeting SLAs “The multi-temperature database management feature of DB 2 V 10. 1 is great because the hardware world is not just RAM and hard disks. There are many types of storage options with different I/O speeds and prices. This feature allows administrators to make optimal use of these different devices, balancing expensive SSDs with cheaper SATA disks and everything in between. Using SSDs for indexes and logs and a SATA array for the data, we noticed fantastic improvements in I/O speeds, especially for synchronous reads. Additionally, the background movement of data between the storages groups is very fast. ” —Thomas Kalb, CEO ITGAIN Gmb. H © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Time Travel Query Easily Analyze Historical Trends and Predict Future Demand Temporal logic & analysis Valid time, transaction time, “AS OF” queries Higher performance – Native support for fast performance Lower costs – Eliminate need to maintain and update custom temporal implementations – Easy to administer (simply turn on for any table) “The use of standardized SQL syntax for temporal operations and the integration deep into the database engine, make DB 2 a leader in second generation bitemporal data management - Bitemp 2. 0!” —Craig Baumunk, Principal at Bitemporal. Data. com © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Graph Store Rapid Application Development Optimized way to store graph triples in DB 2 Curt Cotner owns. Car 2012 Ferrari Curt Cotner owns. House 123 Maple Ave, Chicago Curt Cotner owns. Boat 2001 Thunderjet Supports SPARQL 1. 0 query language Higher performance – Accelerates leading open source semantic Web framework by up to 3. 5 x Lower costs – Rapid development with schema-less approach – Easy adaption as needs evolve – Simpler data management for triples Based on internal benchmark tests of Rational Jazz graph store usage, comparing DB 2 10 Graph Store with Jena TDB version 0. 8. 10. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 DB 2 Graph Store Accelerates Leading Open Source Semantic Web Framework by up to 3. 5 x Faster Based on internal benchmark tests of Rational Jazz graph store usage, comparing DB 2 10 Graph Store with Jena TDB version 0. 8. 10. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 DB 2 pure. Scale Enhancements Increase Ability to Meet SLAs; Easily Add or Remove Capacity Geographically-dispersed clusters Further Improving IBM’s Shared-Disk Cluster Capability Workload management for DB 2 pure. Scale Multiple database support – Easy multi-tenancy Range partitioning support Additional backup/restore options Support for 10 -gigabit Ethernet Support for multiple Infiniband adapters and switches “Vormetric’s integration with DB 2 pure. Scale GPFS provides IBM customers with a fantastic combination of Vormetric Data Security with pure. Scale availability, capacity and scalability. Improved performance and availability with data security offers our mutual customers a phenomenal solution. ” -- Todd Thiemann, Senior Director, Product Marketing Vormetric, Inc. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Row and Column Access Control Easy Compliance with Privacy and Sensitive Data Requirements Fine-grained access control – Hide rows from unauthorized users – Mask the value of columns for unauthorized users Policy-driven security, with flexible policies Does not require classification Account Income Branch 1111 -2222 -3333 -4444 Ana 22, 000 A 2222 -3333 -4444 -5555 Bob 71, 000 B 3333 -4444 -5555 -6666 Celia 123, 000 B 4444 -5555 -6666 -7777 Teller Amy sees Name Dinesh 172, 000 C Telemarketer Pat sees Account Name Income Branch 2222 -3333 -4444 -5555 Bob 71, 000 B xxxx-xxxx-4444 Ana 22, 000 A 3333 -4444 -5555 -6666 Celia 123, 000 B xxxx-xxxx-5555 Bob 71, 000 B xxxx-xxxx-6666 Celia 123, 000 B xxxx-xxxx-7777 Dinesh 172, 000 C © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Easy and Low Cost Security and Privacy Compliance Higher performance – Less data duplication than using “Views” to mask data – More secure than using “Views” to mask data Lower cost – Easier to implement and maintain – Easier compliance with privacy and sensitive data requirements – Easier to maintain that using application code to mask data “Because we deal with sensitive securities and financial information, the privacy of that information is a top priority. Row and Column Access Control will help enhance our security solutions and help us meet strict regulatory guidelines. ” —Shi Jin Li, China Securities Depository and Clearing Corporation Ltd. “Row and Column Access Control help us to improve data confidentiality and security in production environments. ” —Jessica Tatiana Flores Montiel, DAFROS Multiservicios © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Real-Time Data Warehousing Faster Business Decisions; More Accurate Business Decisions Continuous feed of data Parallel processing Supports multiple connections Higher performance – Faster availability of data – Minimal impact on query performance – No downtime (even for large volumes of data) Lower costs – Costs less than solutions outside database – Reduced infrastructure costs “You can now continuously feed data into your data warehouse at a high rate even whilst you are running queries against the tables in your data warehouse. Info. Sphere Warehouse 10 represents a greatly strengthened offering for the data warehouse market. ” —Ivo Grodtke, LIS. TEC Gmb. H © 2012 IBM Corporation

IBM Confidential until 03 April 2012 In DB 2 10 Early Access Program testing, DB 2 obtained an average of 98% compatibility with Oracle PL/SQL Easily Move from the More Expensive Oracle Database; Leverage Oracle Skills with DB 2 9. 7. 1 • • Moved from Oracle Database to IBM DB 2 Used “compatibility features” 3 -30 x faster query performance 200% improvement in data availability Increase compatibility 9. 7. 1 Improve BOOLEAN Increase compatibility 9. 7. 1 Conditional Compilation Enhancement 9. 7. 1 Basic DPF Support Broaden coverage 9. 7. 1 OCI Support Broaden coverage UDF Parameters: DEFAULT Increase compatibility Obfuscation Enhancement 9. 7. 2 NCHAR, NVARCHAR, NCLOB Increase compatibility 9. 7. 3 NUMBER Performance 9. 7. 3 Runtime “purity level” Enforcement Increase compatibility 9. 7. 3 RATIO_TO_REPORT Function Increase compatibility 9. 7. 3 RAISE_APPLICATION_ERROR Increase compatibility 9. 7. 3 Small LOB Compare Increase compatibility Multi-action Trigger & Update Before Trigger Increase compatibility 9. 7. 4 Autonomous Tx Improvements Increase compatibility 9. 7. 4 LIKE Improvements, LISTAGG Increase compatibility 9. 7. 4 ROW & ARRAY of ROW JDBC Support Increase compatibility 9. 7. 5 Pro*C Support Increase compatibility 9. 7. 5 Nested Complex Objects Increase compatibility 10 Local Procedure Definitions Increase compatibility Local Type Definitions Increase compatibility 10 JSC Rietumu Banka Increase compatibility FORALL/BULK COLLECT 10 “We switched from Oracle Database to IBM DB 2 and cut our costs in half, while improving performance and reliability of business applications. ” UDF Parameters: INOUT 9. 7. 1 9. 7. 4 Banco de Crédito del Peru 9. 7. 1 9. 7. 2 “The total cost of ownership with DB 2 running on IBM systems is almost half the cost of Oracle Database on Sun systems. ” Increase compatibility 9. 7. 2 Reliance Life Insurance SUB STRB PL/SQL Performance Based on internal tests and reported client experience from 28 Sep 2011 to 07 Mar 2012. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 HADR now Supports Multiple Standby Servers Increase Ability to Meet SLAs; Disaster Recovery HADR now supports more than one stand-by server If Primary Server fails, Principal Standby takes over If Principal Standby then fails, can switch to Auxiliary Standby can provide complete offsite availability, while maintaining speed of local standby © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Accelerate Value for New Features Increase Ability to Meet SLAs; Lower Administration Costs Updated Database Admin solutions: – IBM Data Studio – Info. Sphere Data Architect Updated Performance Mgmt solutions: – Info. Sphere Optim Performance Manager – Info. Sphere Optim Query Workload Tuner – Info. Sphere Optim Configuration Manager Higher performance – Immediate support for new performance features – Enhanced Visual Explain, Access Plan Explorer and Index Advice – Extended Insight identifies source of performance issues Lower costs – Immediate support for new time saving features (incl. Temporal, Multi-Temperature Data Management & Row and Column Access Control) – IBM solutions are integrated and consistent © 2012 IBM Corporation

IBM Confidential until 03 April 2012 Coca Cola Bottling Company “We’ve saved more than a million dollars over the past four years in licensing, maintenance and storage costs by migrating from Oracle Database to DB 2. We’ve reinvested these savings into other business projects while keeping our operating expenses flat. As a result, we don’t have to pass rising costs on to consumers, which allow us to maintain our sales volumes and market share. ” —Tom De. Juneas, IT Infrastructure Manager, Coca Cola Bottling Company. © 2012 IBM Corporation

IBM Confidential until 03 April 2012 New Releases Build on the Pillars of DB 2 Low Operational Costs Ease of Development Faster Query Response SQL Compatibility enhancements Improved Index Mgmt Graph Store Adaptive Compression Row and Column Multi-Temperature Access Control Data Management Temporal Capabilities Real-time Data Warehousing Reliability DB 2 pure. Scale enhancements Workload Management Enhancements HADR Supports Multiple Standby Servers © 2012 IBM Corporation

IBM Confidential until 03 April 2012 DB 2 vs Info. Sphere Warehouse At a glance features… Feature DB 2 10 Info. Sphere Warehouse 10 OLTP OLAP/Warehousing DB 2 Database Adaptive Compression Multi-Temperature Data Management Time Travel Query Row & Column Access Control DB 2 pure. Scale Real-Time Data Warehousing HADR Info. Sphere Warehouse 10 still includes, data mining, cubing and more warehousing tools in addition to the above features © 2012 IBM Corporation

Скачать презентацию DB 2 10 Info Sphere Warehouse 10

3239f9741873066ea9249b54fe517bc1.ppt

Количество слайдов: 27