Oracle Exalytics Briefing March 5, 2014 Dave Miller, Mythics Enterprise Architect Greg Mika, Mythics Enterprise Architect Agenda • • • • • • Introductions About Mythics Exalytics Overview Demonstration Scenario – BI Modernization Mythics Technology Innovation Center and Enterprise Architecture Team • Review • Questions The Evolution of Mythics Value Added Partner Oracle Reseller • Efficiency • Contracts • Relationships 2000 • Certifications • Consulting • Training Oracle Systems Integrator • Hardware • Architects • Pre‐Sales • Innovation 2006 The Mythics Value to Oracle & Our Customers 3 mythics.com 2013 One Company for Any Oracle Need 4 Mythics Consulting Core Capabilities Award winning consulting group with experience across a wide array of Oracle solution areas. • • 800+ engagements across multiple vertical markets & agencies Diverse technical backgrounds with common Oracle thread • Strong project management capabilities • Key relationships with Oracle product development • Highly skilled team with numerous Oracle specializations 5 Organizational Focus Enterprise Infrastructure Cloud Services High Availability / Disaster Recovery Engineered Systems: Exadata/Exalogic/ODA Managed Services Fusion Middleware WebCenter Content and Portal Oracle BPM/SOA Custom ADF WebLogic Server BI & Data Warehousing OBIEE Data Mart Development Tactical Data Warehouse Support IV&V Security & Identity Management Identity & Access Management FISMA Compliance, HSPD‐12 CAC/PIV enablement Applications Oracle COTS Implementations Application / Modernization What is Exalytics? • • Formally named Exalytics In-Memory Machine An Oracle Engineered System (Combination of hardware and software optimized and engineered to maximize performance, scalability, and reliability) purpose-built for Analytics, Business Intelligence, and Enterprise Performance Management. •Oracle BI EE •Times10 •BI Apps •Hyperion/Essbase • •Endeca •R •Mobile X3-4 (Intel) • • • • • T5-8 (SPARC) 2 TB RAM 2.4 TB Flash 40 Xeon CPU cores 1 Gb, 10 Gb, 40 Gb Net 5.4 TB Local disk + 8 Gb FC to SAN • • • • • • 4 TB RAM 3.2 TB Flash 128 SPARC CPU cores 1 Gb, 10 Gb, 40 Gb Net 7.4 TB Local disk + 8 Gb FC to SAN Zero Overhead Virtualization 6 Confidential & Proprietary – © Mythics, Inc. Exalytics X3-4 : Front Extra Slides 5.4 TB Disk RAID Exalytics X3-4 : Back Extra Slides 8Gb Fibre Channel 1GbE Net ILOM 10GbE Net 40Gb Infiniband What are the Benefits of Exalytics? Reduce operational cost and risk with fully tested to bottom stack of optimized hardware and software Deliver lightning-fast performance & infinite data-scale with world's fastest database machine Provide fastest performance for business intelligence applications, EPM applications, and large-scale mobile deployments Instantly identify outliers and patterns in large, complex data sets through speed-of-thought visual exploration Seamless migration of existing OBIEE and Essbase Applications Dramatically faster response time enabled through storing data in main memory and flash How Does it Work for Traditional BI? • Intelligent Adaptive In-Memory Cache – Decides what gets stored in-memory – Adapts to changes in analytic workload • In-Memory Database – Oracle TimesTen Database – Advanced Columnar Compression – In-Memory Analytic Functions 2 TB or 4 TB RAM Intelligent In-Memory Cache TimesTen In-Memory Database for Exalytics How Does it Work for Traditional BI - Before Query & Analysis Interactive Scorecards Dashboards Reports & Publishing Office Search Detect & Alert Embedded Mobile Common Enterprise Information Model BI Server OLTP & ODS Systems Data Warehouse Data Mart Exadata OLAP Sources Packaged Unstructured & Applications (Oracle, SAP, Others) Semi-Structured Excel XML/Office Business Process How Does it Work for Traditional BI - After Query & Analysis Interactive Scorecards Dashboards Reports & Publishing Office Search Detect & Alert Embedded Mobile Common Enterprise Information Model BI Server with Detailed Usage Tracking Summary Advisor Usage Analysis Cache Miss Cache Hit BI Server Script Aggregate Selection Scheduled Refresh TimesTen for Exalytics OLTP & ODS Systems Data Warehouse Data Mart Exadata OLAP Sources Packaged Unstructured & Applications (Oracle, SAP, Others) Semi-Structured Excel XML/Office Business Process Demo What Else Can Exalytics Do? OBI EE + Times10 •Where did I Spend? •How much did I spend? •What did I buy? •Was it a legitimate purchase? Hyperion + Essbase •If I spend this much in the past how much will I spend in the future? •What if I refresh Hardware every 4 years instead of 3? •What if I upgrade RAM in year 3 and upgrade every 5 years? Endeca •If I mine my help desk tickets can I see which brands have the most problems? What types of problems? •What is the sentiment on Social Media for the vendors that I use? R •Can statistical analysis tell me the best time to buy? •Who are the best vendors to use based on historical pricing? Current State BI Modernization Scenario • Bought piecemeal over time leading to separate components on separate servers • Procurement /Spend Analytics on IBM • OBIEE on Linux • Hyperion Planning on Windows Prod DR BI Apps BI Apps OBIEE OBIEE Hyperion Planning Hyperion Planning • Costly, Inefficient, Challenging to Support • Each has separate DR environment • Different HW/OS vendors for Support • Disk and traditional networking infrastructure struggles to meet performance goals • Can’t take full advantage of Exadata • Are you able to do statistical analysis or examine unstructured data? How about Mobile? Future State BI Modernization Scenario • Hardware and Software Engineered Together Data Center DR Data Center BI Apps, OBIEE, Hyperion, Endeca BI Apps, OBIEE, Hyperion, Endeca • Procurement /Spend Analytics, OBIEE, and Hyperion Planning on one Exalytics – 40+ cores, 2TB+ RAM, 2TB+ Flash • Simple, Efficient, Easy to Support Single DR platform Support = One Throat to Choke Bundled Patches are easily applied Performance SLAs are met (CPUs + RAM + Flash + Infiniband + In‐Memory Software) • Exadata and Mobile access ‐ out of the box • Endeca for unstructured analytics, R for statistical analysis – out of the box • • • • Exadata Exadata Technology Innovation Center and Mythics Enterprise Architecture Team People and Resources to Support Oracle Customers Product Detail Exadata X2 At Tech Center Exadata X3 Onsite, Offsite Exalytics Full Stack ODA Mobile, Tech Center ZFS Storage With Exadata X Series Blades At Tech Center, OVM Cluster OVM Cluster At Tech Center, OEM, Endeca, EBS, EPM 17 mythics.com Mythics EA Team •Brent Seaman •Dave Miller •Randy Hardee •Greg Mika •Ted Nanayakara •Pradip Tyagi 100+ Years ORCL Exp. Oracle Exalytics In‐Memory Machine Extreme performance Oracle business intelligence platform • Fastest OLAP Query, Reporting & Analysis • Fastest Financial and Operational Planning • Best BI & EPM Cost/Performance • BI Apps / EPM Apps Are Certified Thank You and Questions For More Information •Monthly Webinars http://www.mythics.com/events/ •Oracle Database 12c •Oracle Engineered Systems •Oracle ZS3 Storage •Mythics BLOG http://www.mythics.com/blog/ •Reach out to your Mythics Rep •Schedule a visit to Mythics’ Technology Innovation Center in Chantilly, VA •Schedule a meeting with the Mythics Enterprise Architecture Team