Oracle Exadata Database Machine Případové studie v bankovnictví Ing. Josef Krejčí Principal Sales Consultant, Engineered Systems Oracle Czech 5. června 2014 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Co je Oracle Exadata Database Machine? Všichni mluví o EXADATA … • Inteligentní storage • DB server • DB options • Spolehlivé řešení • Úspěšný produkt • Bedna pro data a Database • Řešení, které Vám ušetří čas Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 3 Exadata spoří Váš čas v několika oblastech 1. Před-konfigurováno a optimalizováno pro běh Oracle databáze Upgrades Design 2. Rychlá instalace - připraveno pro migraci dat po objednání do 28 kalendářních dnů (26+2) 3. Rychlá a snadná migrace databázových úloh – infrastruktura jako celek otestována Operations Tuning Installation Testing 4. Redukce optimalizačních kroků při stavbě DB infrastruktur - vše maximálně vyladěno 5. Minimalizace výpadku - vše redundantní, vyměnitelné za chodu. 6. Zjednodušení procedur správy (Patching, Upgrades) - vše již otestováno - snížení rizika Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 4 Více než 7500 instalací po celém světě 50% datové sklady, 50% OLTP nebo smíšená zátěž • Petabyte datové sklady • Financial Trading řešení • E-Commerce sítě • Konsolidační platforma pro stovky databází Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 6 ExadataTV www.youtube.com/ExadataTV • 30+ video referencí Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 7 Oracle Exadata zákazníci - reference http://www.oracle.com/customers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 8 Oracle Exadata Database Machine - instalace v ČR Seznam v čase OKsystem Mailprofiler Arrow Homecredit J&T banka „Logistika“ MMR J&T banka ČMSS Arrow EquaBank „Logistika“ O2 CZ Typ / Generace Počet Datum Exadata V1 / Half Rack Exadata X2-2 / Quarter Rack Exadata X3-2 /Eighth Rack Exadata X3-2 / Eighth Rack Exadata X3-2 / Eighth Rack Exadata X3-2 / Quarter Rack Exadata X3-2 / Eighth Rack Exadata X3-2 / Eighth Rack Exadata X4-2 / Eighth Rack Exadata X4-2 / Eighth Rack Exadata X4-2 / Eighth Rack Exadata X4-2 / Eighth Rack SuperCluster T5-8 / HalfRack 1x 1x 1x 2x 2x 3x 1x 1x 2x 1x 2x 2x 1x 2009 Únor 2012 Březen 2013 Únor 2013 Květen 2013 Červen 2013 Červenec 2013 Srpen 2013 Listopad 2014 Leden 2014 Březen 2014 Květen 2014 Květen 2014 Květen Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 10 Oracle Exastack Program v České republice Aplikační dodavatelé již pro vás Oracle Exadatu Database Machine otestovali Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 11 Případové studie Finance Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 12 Out-of-the-Box Transformation “With our migration to Exadata we've seen a 17x performance improvement, having made no changes to our application.” – Electronic Data Warehouse Head, BNP Paribas Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 13 Operating Cost Savings “With the implementation of Oracle Exadata Database Machine, data processing performance improved significantly, and the bank acquired the ability to analyze increasing data volume in much shorter cycles. In addition, compressing the data volume by 75% reduced electrical usage and costs.” – Marcus Prätzas, Head FDW, Deutsche Bank Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 14 Game-Changing Performance “We chose Oracle Exadata to help keep us nimble by delivering a response time of less than 100ms over petabytes of data.” – Sehmuz Bayhan, CTO PayPal Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 15 Database Infrastructure Consolidation “As the business seeks more services on demand, we needed to provide that resilient platform and Exadata provides us a consolidated platform for database services that can meet all those needs” – Nicolas Tan, Head, Infrastructure and Platform Services Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 16 Více a podrobněji v odpoledním bloku … • Oracle Exadata Database Machine Jaké jednoznačné výhody přináší pro finanční instituce – Tématický blok - Multichannel FrontEnd, sál Gracie od 15:00 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 17 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 18 Oracle Exadata Database Machine Jaké jednoznačné výhody přináší pro finanční instituce Ing. Josef Krejčí Principal Sales Consultant, Engineered Systems Oracle Czech 5. června 2014 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 21 Exadata Delivers The Shortest Time To Value Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 22 Standardized and Simple to Deploy • All Exadata Database Machines are the same ‒ Delivered ready-to-run ‒ Tested and documented ‒ Highly supportable ‒ No unique configuration issues ‒ Identical to configuration used by Oracle Engineering • Runs existing OLTP and DW applications ‒ Full 30+ years of Oracle DB capabilities ‒ No Exadata certification required • Leverages Oracle ecosystem ‒ Skills, knowledge base, people and partners Deploy in Days, Not Months Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 23 Exadata Saves Money on Design • Purpose-Built for Database Workloads – 30+ Years of Design Best Practices Upgrades Design – A Balanced End-To-End Design – Carefully Selected Components Operations Installation • High Availability and Scalability – Highly Available Design Maximizes Uptime – Field Upgradability Accommodates Growth Tuning Testing • Intelligent Storage Maximizes Investment – Software (Smart Scan, Flash Cache, HCC) – Hardware (InfiniBand, PCI Flash Cards) Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 24 Exadata Saves Money on Installation • Fully Functional System Delivered – Pre-Racked, Pre-Cabled, Pre-Tested Upgrades Design – Complete Rack Rolls into Data Center – Your Configuration is Not Unique Operations Installation • All Software is Pre-Installed – Software Installed To Your Specifications – Fully Stress-Tested At Customer Handoff Tuning Testing • Fully Documented Installation – Documentation Generated By Oracle – Installation Documents Delivered at Handoff Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 25 Exadata Saves Money on Testing • More Productive Technical Testing – Best Practices Used During Installation Upgrades Design – Fully Patched to Latest Patchset – Technical Testing Minimized Operations Installation • More Productive Functional Testing – High Performance Design Speeds Testing – Little Time Wasted on Performance Issues Tuning Testing • Faster Go-Live, Shorter Time To Value – Go-Live in Days/Weeks, not Months – Start Benefitting from Exadata Right Away Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 26 Exadata Saves Money on Tuning • High Performance Day One – Extreme Performance was Pre-Validated Upgrades Design – Remaining Issues may be in Logical Database Design or in Sub-Optimal SQL Statements • Lower Day-To-Day Tuning Effort Operations Installation – Exadata Design is Inherently Highly Efficient – DBAs Can Focus on Database Design Issues Tuning Testing • Single Management Framework – One Tool for Database and Hardware Mgmt – Visibility of All Components in the Stack Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 27 Exadata Saves Money on Operations • Organizational Efficiency – Engineered Systems Reduce Complexity Maintenance Design – Staff Can Focus on Adding Business Value • Hot Swappable Components and Spares Operations Installation – Hot-Swappable Power Supplies and Fans – Additional Spare Disk(s) Onsite – Additional Spare Flash Card(s) Onsite Tuning Testing • Oracle Platinum Support (At No Cost) – Proactive Fault Notification – Fast Response Time and Resolution Time Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 28 Exadata Saves Money on Upgrades • Patches Are Bundled Together – Patches are Delivered in Complete Sets Upgrades Design – Oracle Ensures Patches Work Together – One Patch Bundle for All Components Operations Installation • Rolling Upgrades are Possible – Database Upgrades with No Downtime – Storage Upgrades with No Downtime Tuning Testing • Oracle Platinum Support (At No Cost) – Oracle Can Do The Patching For You – Up To Four Times Per Year Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 29 Exadata Saves Money Six Ways 1. Pre-Designed for Optimal Performance and Management Upgrades Design 2. Fast, Repeatable Installation – Done by Oracle’s Own Experts 3. Faster, Easier Database Testing Operations Installation 4. Reduced Tuning Efforts, More focus on Value-Add 5. Minimal Impact From Hardware Failure, Fast Resolution to Issues Tuning Testing 6. Simplified Patching and Upgrades – Reduced Effort, Reduced Testing, Reduced Risk Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 30 Exadata’s IT and Business Benefits Drive Better IT Practices and a More Productive Business Deploy new systems in days. Delivered ready-to-run. Reduce administrative complexity and Simplify support Eliminate application delays, bottlenecks and long-running jobs I.T. Shrink data center through consolidation to questions faster and more predictably Business Make more informed decisions based on deeper analysis of data for new service and product offerings productivity Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 31 Breaking Traditional Database Performance Bottlenecks Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 32 Traditional Database Deployment Issues Servers • Traditional architectures don’t scale – The separation of servers from storage across slow SANs can bottleneck performance – Modern multi-core CPUs consume data 10x faster than SAN arrays can deliver it SAN Bottleneck • Capital Costs – Storage arrays dominate the costs of DB deployments • People Costs and Complexity – Deployments are very complex and must be tuned, tested, and maintained by each customer Storage Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 33 Engineered For Extreme Database I/O An unbalanced configuration < 20% Possible Efficiency Database CPUs Memory HBAs Switches Controllers Disks Memory HBAs Switches Controllers Disks Exadata’s configuration 100% Possible Efficiency Database CPUs Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 34 Exadata’s Technologies Technologies – Prepackaged and Fully Supported • Databases Have Only Advanced Incrementally for 10+ Years • Suddenly, Many Technologies are Revolutionizing the Industry • Exadata Exploits Technologies and Makes Them Mainstream – Intelligent Storage – Flash Memory – Columnar Compression – Ultra Fast Networking Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 35 Traditional Query Processing Using Traditional Storage What Were Yesterday’s Sales? Oracle Database Storage Array Retrieve Entire Sales Table Select sum(sales) where salesdate= ‘04-Jun-2014’ … SUM All Rows returned Traditional SANs are “Block Servers” Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 36 Exadata Query Offload Using Exadata Storage Servers What Were Yesterday’s Sales? Oracle Database Oracle Exadata Storage Retrieve Sales for Jun 04 2014 Select sum(sales) where salesdate= ‘04-Jun-2014’ … SUM Matching Rows returned Exadata is an “Intelligent Row Server” Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 37 SAN Bottlenecks Restrict Databases Fiber Channel Quickly Becomes a Bottleneck Database Servers Traditional SAN Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 38 Exadata Has Ultra-Fast Storage Links Storage Servers InfiniBand Delivers Unlimited Bandwidth Database Servers High Bandwidth, Low Latency 40 Gigabit Links (40 Gigabits read and write) Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 39 Disk Latency Slows Responsiveness About 300 I/Os Per Second, Per Drive Rotational Delay Seek Time Controller Bottleneck Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 40 Smart Flash Cache Speeds Responsiveness Hot Data Blocks are Cached In Flash Memory Sub-Millisecond Access Hot Data Blocks Automatically Managed New Zero Overhead Flash Compression* *With Oracle Advanced Compression Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 41 PayPal: Real-Time OLTP Benefits “We chose Oracle Exadata to help keep us nimble by delivering a response time of less than 100ms over petabytes of data.” - Sehmuz Bayhan, CTO PayPal Objectives •Analyze 100% of payments for risk in < 100 milliseconds Faster Applications Reduced Risk Exposure Maximum Availability 10x Faster Overall 99.99% Analysis 99.99% 2x Exadata X2-8 2x Storage Expansion 2x Exadata X2-8 2x Storage Expansion Production (Primary Data Center) Standby (DR Data Center) Increased Payment Volume 200% Increase •99.999% uptime •2x increase in transaction volume Solution •3 Pods, each with two X2-8’s plus two X2 Storage Expansion Racks, and Active Data Guard to identical standby configuration Active Data Guard WAN @ 650+ miles (30 ms) 24 Exadata Systems in total, across 3 “pods” 120 TB database • 300,000+ executions per second • 40 ms (average) response times (99.99%) Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public X 3 = 360 TB total 42 Deutsche Bank: Financial Data Extreme WarehouseStorage Benefits “With the implementation of Oracle Exadata Database Machine, data processing performance improved significantly, and the bank acquired the ability to analyze increasing data volume in much shorter cycles. In addition, compressing the data volume by 75% reduced electrical usage and costs.” Usage Savings 1000s of users 75% reduced electrical usage and costs - Marcus Prätzas, Head FDW, Deutsche Bank Started to add Big Data Preprocess for DW Business Objectives • Disclosure • RWA (Basel I / II) • EC / EL / GVA • Daily Derivatives 2010 211 • Many more Solution • Establish real-time credit risk, regulatory law, and internal management reporting to optimize credit risk analysis, as the ability to perform daily analyses of risk ratios is increasingly important Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 43 Commonwealth Bank of Australia Benefits “As the business seeks more services on demand, we needed to provide that resilient platform and Exadata provides us a consolidated platform for database services that can meet all those needs” OPEX ROI 50~60% reduction 150% in 5 years Rapid Provisioning Months to Minutes Simplified Management Two Oracle Homes - Nicolas Tan, Head, Infrastructure and Platform Services Business Objectives •Cost Savings •Rapid Provisioning 2011 •Extreme Standardization Solution •Exadata for Enterprise servers configured by CBA Commodity clusters configured by CBA  Rapid, reliable deployments Commodity clusters configured by Oracle  Standardized environments Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 44 Automated Service Request (ASR) and Spares Kits Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 45 Automated Service Request (ASR) Customer Data Center Oracle Support Services FRU Replaced by Field Engineer Oracle Field Engineer ! Fault occurs FRU Dispatched by Support Engineer SR routed to Support Engineer Customer SR Creation Email Notification to Customer ASR Fault Telemetry Securely Manager Transmitted to Oracle Product’s Auto-Diagnosis Facility Sends SNMP trap to ASR Manager ASR Service Comprehensive Fault Coverage • CPU • Disk Controllers • Disks • Flash Cards • Flash Modules • InfiniBand • Cards • Memory • System Board • Power Supplies • Fans Service Request is Created Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 46 Exadata’s Unmatched Data Security Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public 47 Secure Database Machine Complete Security Portfolio Legal HR Finance Near-Zero Overhead for fully encrypted database! PREVENTIVE DETECTIVE ADMINISTRATIVE  Application transparent  Decryption in hardware, not software (5x faster) Encryption Activity Monitoring Privilege Analysis Redaction and Masking Privileged User Controls Database Firewall Auditing and Reporting Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Public Sensitive Data Discovery Configuration Management 48 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 49 Oracle Exadata Database Machine - zákazníci v ČR Seznam v čase OKsystem Mailprofiler Arrow Homecredit J&T banka „Logistika“ MMR J&T banka ČMSS Arrow „Finance“ „Logistika“ O2 CZ Typ / Generace Počet Datum Exadata V1 / Half Rack Exadata X2-2 / Quarter Rack Exadata X3-2 /Eighth Rack Exadata X3-2 / Eighth Rack Exadata X3-2 / Eighth Rack Exadata X3-2 / Quarter Rack Exadata X3-2 / Eighth Rack Exadata X3-2 / Eighth Rack Exadata X4-2 / Eighth Rack Exadata X4-2 / Eighth Rack Exadata X4-2 / Eighth Rack Exadata X4-2 / Eighth Rack SuperCluster T5-8 / HalfRack 1x 1x 1x 2x 2x 3x 1x 1x 2x 1x 2x 2x 1x 2009 Únor 2012 Březen 2013 Únor 2013 Květen 2013 Červen 2013 Červenec 2013 Srpen 2013 Listopad 2014 Leden 2014 Březen 2014 Květen 2014 Květen 2014 Květen Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 51 Kompetenční centrum ARROW ECS www.arrowecs.cz/exadata • Kdo Exadata DEMO využívá – Koncoví zákazníci – Partneři • K čemu se Exadata DEMO využívá – Prezentace / workshopy – Testování aplikací ISVs - certifikace – Proof of Concept (PoC) Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 52