virtual event: oracle exadata strategy and roadmap for new

Virtual Event: Oracle Exadata Strategy and Roadmap for New Technologies27th May, 09.00 – 10.00 CEST

Welcome!Johan HultgrenNordic Sales Director Systems, Oracle

Today’s Agenda(CEST time)

09:00 Welcome & IntroductionJohan Hultgren,Nordic Sales Director Systems, Oracle

2 Copyright © 2020, Oracle and/or its affiliates

09:05 Oracle Exadata Strategy and Roadmap for New TechnologiesAri Ikonen,Solution Architect, Cloud at Customer Solution Engineer Leader, Oracle

09:45 Q & A

Johan HultgrenNordic Sales Director [email protected] Mobile +46767200181


Ari IkonenSolution Architect, Cloud at Customer Solution Engineer [email protected] Mobile +358 438246130

mailto:[email protected]

mailto:Ari%[email protected]

Please Submit any Questions


Please use the Q & A window and type any questions you may have

We will address your questions during the Q & A slot following the presentation

5

Exadata: Strategy and Roadmap for New Technologies, Cloud, and On-Premises

Ari Ikonen

Exadata Vision

• Ideal Database Hardware – scale-out, database optimized compute, networking, and storage for fastest performance and lowest cost

• Smart System Software – specialized algorithms vastly improveOLTP, Analytics, Consolidation

• Automated Management – fully automated and optimizedconfiguration, performance, fault-tolerance, updates

Dramatically Better Platform for All Database Workloads

Copyright © 2019, Oracle and/or its affiliates. All rights reserved.

Oracle Exadata – The game changerInnovation excellence since 2008 - Improvements in every dimension

ExadataV1

ExadataV2

ExadataX2

ExadataX3

ExadataX4

ExadataX5

ExadataX6

ExadataX7

Smart Scan

+ Storage TierIn-Memory Analytics

+ Hot Swap Flash Card

+ Elastic Config+ Columnar Flash

Cache+ VM Support

+ Flash Cache Write-Back

+ 1/8 Rack Release

+ Flash Cache+ Hybrid Columnar

Compression+ InfiniBand

ExadataX8

+ Extended Storage+ Automatic

Indexing+ 60% Performance

Boost

Exadata X8M

+ PMEM

+ RoCE

+ 250% Performance Boost

2008 2009 2010 2011 2012 2013 2014 2016 2017 2019 2019


320xMaximum read IOPS

64xSmart Flash Cache

40xMaximum scan rate

14xDisk storage

capacity

20xDatabase server compute power

5xInternal

interconnect

48xDatabase server

memory

100xClient network

throughput

Thousands of Critical Deployments Since 2008

Best for ALL workloads• Petabyte Warehouses• Super Critical Systems

• Financial trading

• Process manufacturing

• E-commerce

• Packaged Applications• Oracle, SAP, Siebel, Peoplesoft, …

• Database Consolidation

Financial Services, Telecoms, Healthcare, Retail, Public Sector, Travel, Manufacturing, Professional Services, Consumer Goods, Education, Utilities, …

77% of Fortune Global 100 Run Exadata


Exadata Uniquely Achieves Memory Speed with Shared Flash

• Architecturally, storage arrays can share flash capacitybut not flash performance due to network bottlenecks

• Even with next gen scale-out, PCIe networks, NVMe over SAN

• Must move compute to data to achieve full flash potential• Requires owning full stack; can’t be solved in storage alone

• Exadata delivers 560 GB/sec flash bandwidth to any server• Approaches 800 GB/sec aggregate DRAM bandwidth of DB servers

9

ExadataDB Servers

ExadataSmart Storage

NW Fabric

QU

ERY

OFF

LOAD


Latest Flash Creates Giant Bottleneck for SAN Storage

10

Single Flash Drive is Faster than fast SAN

0

50

100

150

200

250

300

350

400

Number of flash drives Th

roug

hput

GB/

sec

All-Flash Array

Exadata

NVMeFlash

40 Gb/secSAN link

5.5GB/sec 5

GB/sec

Exadata Scales as Flash is Added,Flash Arrays Bottlenecked by Network

90% of flashperformance is lost


Exadata Smart System Software

• Fastest Analytics• Unique Smart Scan automatically offloads data intensive SQL operations to storage• Unique Smart Flash Cache and Storage Index automatically accelerate database I/O• Unique automatic conversion of data to fast In-Memory Columnar format in flash

• Fastest OLTP• Fastest OLTP I/O with scale-out storage, RDMA, and NVMe Flash • Fastest scale-out with unique RDMA algorithms for inter-node cluster coordination• Fully redundant and fastest recovery from failed or sick components

• Best Consolidation• Uniquely prioritizes latency sensitive or important workloads through full stack• Uniquely isolates workloads from multiple tenants through full stack


Exadata delivers unmatched Oracle Database capabilities for60 Exadata-only features for Oracle Database

Scalability1. Infiniband Cluster Interconnect 2. Remote Direct Memory Access on Storage I/O3. Exadata High Redundancy Storage 4. High Performance I/O – 6.57 million IOPS from SQL 5. Low Latency I/O – 200 microseconds6. In-Memory Data Mirroring 7. Hybrid Columnar Compression 8. Bloom Filter Joins 9. In-Memory Columnar Tables10. In-Memory External Tables11. Memory Optimized Key/Value Data12. Higher Consolidation Density

Performance1. Active/Active IB Network 2. Exadata Smart Write Back, Smart Flash Logging, Smart

Scan, and Reverse Offload3. Fastest Redo Apply and Instance Recovery 4. Efficient re-silver rebalance after Flash failure 5. I/O latency capping for reads and writes6. Cell IO timeout threshold7. Smart Write Back Flash Cache Persistence8. I/O and network resource management 9. Cell to cell offload for disk repair 10. Cell-to-Cell Rebalance Preserves FlashCache11. Appliance Mode Support

Security1. Full Stack Patching 2. Minimal Attack Surface3. Pre-Scanned & fixed system stack using STIG, Nessus,

and Qualys4. Advanced Intrusion Detection Environment (AIDE) –

similar to virus scanners5. SGX Integration in Exadata Storage Cells

Availability1. Fast Node and Cell Death Detection2. Fast Network Failure Detection3. Redundancy Protection on cellsrv shutdown4. Redundancy Protection on Cell shutdown5. Reduced Brownout for Instance Recovery6. ILOM Hang Detection and Repair7. Automatic ASM Mirror Read on IO error corruption8. IO error prevention with Exadata disk scrubbing/ASM

Corruption repair9. Corruption Prevention with HARD support10. Elimination of false-positive drive failures11. Redundancy Check During Power Down12. Blue OK-to-remove LED Light notification13. Health Factor on predictively failed disks14. Disk Confinement15. I/O hang detection and repair16. Drop Hard Disk for Replacement17. Drop BBU for Replacement

Efficiency1. Exadata Elastic Configuration 2. Cell Alert Summary 3. Flash and Disk Lifecycle Management Alerts 4. Auto Online5. Auto Disk Management6. Priority Rebalance Support7. EM Failure Reporting8. Failure Monitoring on Database Servers9. Updating Database nodes with Patchmgr10. Optimized and Faster Exadata Patching11. Custom Diagnostic Package for Cell alerts12. VLAN support and automation 13. Exachk – full stack health check with critical issue alerts14. Automatic Statistics15. Automatic Indexing

Availability Security Performance

Scalability Efficiency

The Most Differentiated Platform for Oracle Database


In-Memory Analytics Performance in Shared Storage

• Exadata flash throughput approaches DRAM throughput• Analytics SQL bottleneck moves from I/O to CPU

• Exadata storage automatically transforms table data into In-Memory DB columnar formats in Exadata Flash Cache

• Enables fast CPU vector processing in storage server queries

• Uniquely optimizes next generation flash as memory

In-MemoryColumnar Scans

In-FlashColumnar Scans


New Free In-Memory DB Base Level Feature(20c preview)

Automatic indexing uses machine learning The entire process is fully automatic Based on a common approach to manual SQL

tuningIdentifies candidate indexes and validates them before implementingTransparency is equally important as sophisticated automation All tuning activities are auditable via reports Controllable by DBA

Unique Oracle Database automatic indexing capability

Capture

Decide

OnlineValidation Verify

Monitor Identify

Improves database performance and eliminates manual index-tuning


The best place to run Oracle Database

Oracle Exadata X8M


Exadata X8M (major changes in red)

• Scale-Out 2-socket or 8-socket Database Servers• Latest 24 core Intel Cascade Lake

• 100Gb RDMA over Converged Ethernet (RoCE) Internal Fabric

• Scale-Out Intelligent 2-Socket Storage Servers• 1.5 TB Persistent Memory per storage server• Three tiers of storage: PMEM, NVMe, HDD

• Enhanced consolidation using Linux KVM• 2X more guest VM Memory - 1.5 TB/server

• 50% more guest VMs per server - 12 VMs for KVM

Extreme Flash (EF) Storage

Database Server

High-Capacity (HC) Storage

Extended (XT) Storage


New RoCE Internal Network Fabric

• InfiniBand was the only viable RDMA capable network at the inception of Exadata, but now Ethernet has caught up

• RoCE = RDMA over Converged Ethernet

• Industry-standard RDMA capable network cards, switches, protocol• Exadata X8M uses Mellanox RoCE card and Cisco RoCE switch

• Exadata RoCE provides RDMA speed and reliability on Ethernet fabric• 100 Gb/sec throughput – 2.5x faster than 40 Gb/sec InfiniBand• Zero packet loss messaging• Prioritization of critical database messages

World’s first and only RoCE-based Database MachineCopyright © 2019, Oracle and/or its affiliates. All rights reserved.

New Persistent MemoryIntel® Optane™ DC Persistent Memory

• Capacity, performance, and price is between DRAM and flash

• Reads are like DRAM reads but somewhat slower• Writes survive power failure (persist), unlike DRAM• Persistent Writes require sophisticated new software

• Solved in Exadata with Oracle’s deep database expertise• Flush data from CPU cache to PMEM, or

back-out sequence of writes interrupted by a crash• Using persistent App Direct Mode, not volatile Memory Mode• All DB features, incl. Real Application Cluster, are supported

FLASH

Persistent Mem

DRAM

High

er C

ost P

er G

B

Fast

er


Compute Server

Storage Server

Hot

Warm

RDMA

Cold

RoCE

PMEM

FLASH

Exadata X8M With Persistent Memory AcceleratorWorld’s First and Only Shared Persistent Memory Optimized for Database

PMEM accelerator transparently added in from of flash and disk

Database uses RDMA to read PMEM on storage servers

2.5X higher IOs per second than X8

10X better latency than X8

No Application Changes Required - Enabled with Database Software 19c

up to 8x faster than X8

Shared PMEM Performance

Aggregate performance of all PMEM available to all database servers

PMEM Redundancy

Automatic mirroring of PMEM across storage servers transparently protects from PMEM failures

PMEM Security

No direct access to PMEM from DB hosts, only databases can access

Simplest PMEM

No extra management

PMEM RDMA accelerate redo log writes

Flush later to

Flash/Disk


World’s Fastest Database Machine – Exadata X8MExadata X8M storage performance is comparable to in memory

• With the capacity, sharing, and cost benefits of shared storage

• 16 Million OLTP 8K Read IOPS • 2.5x faster than Exadata X8

• < 19 microsecond OLTP I/O latency• 10x faster than Exadata X8

• 8x faster log file writes to accelerate transactions

• 560 GB/sec Analytic Scan throughput• Over 1 TB/sec analytic scans with columnar data in flash

Performance scales as more racks are added – Elastic configurations upto 18 racks

Each rack has up to3.0 PB Raw Disk

920 TB NVMe Flash27 TB PMEM



Analyst reports agree

https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/idc-exadata-x8m-future-of-data-management.pdfhttps://www.oracle.com/a/ocom/docs/applications/performance-management/esg-exadata-x8m.pdf

https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/idc-exadata-x8m-future-of-data-management.pdf

https://www.oracle.com/a/ocom/docs/applications/performance-management/esg-exadata-x8m.pdf

Exadata X8M Benefits

No Application Changes Required

Faster OLTP and Analytics

OLTP10x lower latency

Data-Warehouse/Mixed Workloads2.5x higher IOPS

Perform existing tasks faster Consolidate more reduce cost

Game changer for apps that need real-time access to lots of data

RoCE Persistent Memory KVM


Oracle Converged Database Enables Simplicity and Data Synergy

• Oracle Converged Database Supports all Data Types• Exadata is best platform for all workloads and for consolidation

Copyright © 2019 Oracle and/or its affiliates

Structured and Unstructured

Micro-ServiceIoT, Key-Value

Traditional Next Generation

In-Database Machine Learning is faster and less costly

Unique Exadata added value with massive bandwidth and compute powerData stays in place on Exadata Storage Servers EF Storage Servers with all-flash performance

XT Storage Servers offer Hadoop pricing

Superior performance and scalability

Faster data transformation and preparation with automated tools

Faster model scoring

Superior availability and security

Superior simplicity and economics


Significantsavings

Model “Scoring”Embedded Data Prep

Data Preparation

Model Building

Oracle’s in-DB machine learning

Secs, Mins or Hours

Traditional ML

Hours, Days or Weeks

Data extraction

Data prep & transformation

Data mining model building

Data miningmodel “scoring”

Data prep. &transformation

Data import

25

CLASSIFICATION– Naïve Bayes– Logistic Regression (GLM)– Decision Tree– Random Forest– Neural Network– Support Vector Machine– Explicit Semantic Analysis

CLUSTERING– Hierarchical K-Means– Hierarchical O-Cluster– Expectation Maximization (EM)

ANOMALY DETECTION– One-Class SVM

TIME SERIES– State of the art forecasting using Exponential

Smoothing– Includes all popular models

e.g. Holt-Winters with trends, seasons, irregularity, missing data

REGRESSION– Linear Model– Generalized Linear Model– Support Vector Machine (SVM)– Stepwise Linear regression– Neural Network– LASSO *

ATTRIBUTE IMPORTANCE– Minimum Description Length– Principal Comp Analysis (PCA)– Unsupervised Pair-wise KL Div– CUR decomposition for row & AI

ASSOCIATION RULES– A priori/ market basket

PREDICTIVE QUERIES– Predict, cluster, detect, features

SQL ANALYTICS– SQL Windows, SQL Patterns,

SQL Aggregates

• OAA (Oracle Data Mining + Oracle R Enterprise) and ORAAH combined• OAA includes support for Partitioned Models, Transactional, Unstructured, Geo-spatial, Graph data. etc,

Oracle’s Machine Learning Algorithms

FEATURE EXTRACTION– Principal Comp Analysis (PCA)– Non-negative Matrix Factorization– Singular Value Decomposition (SVD)– Explicit Semantic Analysis (ESA)

TEXT MINING SUPPORT– Algorithms support text– Tokenization and theme extraction– Explicit Semantic Analysis (ESA) for document

similarity

STATISTICAL FUNCTIONS– Basic statistics: min, max,

median, stdev, t-test, F-test, Pearson’s, Chi-Sq, ANOVA, etc.

R PACKAGES– CRAN R Packages

through Embedded R Execution– Spark MLlib algorithm integration

EXPORTABLE ML MODELS– REST APIs for deployment

X1

X2

A1 A2 A3A4 A5 A6 A7


Exadata X8M enables New applications

Fraud detection Network intrusion analytics

High frequency trading IoT Financial

Forecasting

Evaluate more transactions in real

time

Accelerate ML for Big Data Spatial and

Graphs

Faster analytics and modeling enables

greater trading profits

Monitor millions of data points per second

Faster data collection and propability

forecasting


Chose and Mix

Exadata Deployment Models to match your IT, regulatory, and

financial requirements

Exadata Your Way | Exadata Deployment Models

Cloud Service Cloud at Customer

Public Cloud Cloud at Customer On-Premises

Co-Managed Customer ManagedSubscription Purchased

Oracle Data Center Customer Data Center

Oracle Managed

Level of Automation


Gen 2 Exadata Cloud at Customer

Oracle Public CloudCustomer Data Center

Cloud Operations ExaCC

Database Access

by Application Servers

Intranet

Oracle Public CloudControl Plane Customer Admin

Secure TunnelDeploy, Monitor, Lifecycle

Local ControlPlane Servers

Invoke Cloud UI or REST APIs

Copyright © 2019 Oracle and/or its affiliates.

PUBLIC CLOUD HARDWARE

SOFTWARE AND APIs

DATABASE AS A SERVICE IN YOUR DATA

CENTER

PUBLIC CLOUD OPERATIONAL

MODEL

PUBLIC CLOUD FINANCIAL MODEL

SEAMLESSLY INTEROPERATES

WITH PUBLIC CLOUD

Exadata Cloud Management Model

• Customer invokes Oracle Automation for DB and VM lifecycle operations

• Automated: create, delete, patch, backup, scale up, etc.• Only customer has Guest VM and DB admin credentials

• Oracle owns, manages, and controls hypervisor, DB servers, storage servers, InfiniBand, etc.

• No customer access

Hypervisor

Guest VM

Databases

Internal Fabric

Storage

Storage


25% of Fortune Global 100have already adopted Exadata Cloud

“The 4-year infrastructure and operational staff budgets for a traditional best-of-breed IT data center are

58% higher than Exadata C@C.

The cost of Microsoft Azure Stack is 55% higher than Exadata C@Cwhen running Oracle Database 19c.”

Source: https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/wikibon-oracle-gen-2-exacc-bus-value-analysis.pdf


Sentry Data Systems Gains Cloud Benefits with On-Premises Security using Exadata Cloud at Customer


Sentry Data Systems provides Big Data technology solutions that help healthcare providers address their three biggest challenges: reducing total cost of care, managing compliance and producing better quality.

Result100% ROI in six months. 60% decrease in batch processing window. 60% increase in transaction throughput.

Sentry Data Systems ObjectiveFaster ingest and processing of growing data feeds without compromising security.

Industry: Healthcare data analyticsHeadquarters: US

APPLICATIONSData VisualizationGoldenGateOLAPODI

SENTRY DATA SYSTEMS

CHICAGO MIAMI

Exadata Cloud at Customer

Data Guard

PROD DR/DEV/TEST

Pay for Use

Month

Cost

Exadata Powers the Future of Oracle Database

• Everything is Automatic:• Provisioning• Scaling• Tuning• Security and Patching• Fault Tolerance

• Uses machine learning plus the most advanced and proven technologies:• Exadata, RAC, Data Guard, Data Vault, Parallel SQL, In-Memory, Multitenant, etc.

Exadata Powers Oracle’s Autonomous Database

Mission Critical, Simple, Low Risk, Low CostCopyright © 2019, Oracle and/or its affiliates. All rights reserved.

Roadmap: Autonomous Database Cloud at Customer

• All benefits of Autonomous Database Dedicated in your data center• Oracle fully automates and manages DomUs and Databases• Self-Driving• Self-Securing• Self-Repairing

• Customizable Isolation Policies• Customizable Operational Policies

Gen 2 Exadata Cloud at Customer



Exadata: The foundation of Oracle’s Database Cloud strategy

Exadata Cloud Service

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not beincorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be reliedupon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

Statements in this presentation relating to Oracle’s future plans, expectations, beliefs, intentions and prospects are “forward-looking statements” and are subject to material risks and uncertainties. A detailed discussion of these factors and other risks that affect our business is contained in Oracle’s Securities and Exchange Commission (SEC) filings, including our most recentreports on Form 10-K and Form 10-Q under the heading “Risk Factors.” These filings are available on the SEC’s website or on Oracle’s website at http://www.oracle.com/investor. All information in this presentation is current as of September 2019 and Oracle undertakes no duty to update any statement in light of new information or future events.

Safe Harbor


http://www.oracle.com/investor

Johan HultgrenNordic Sales Director [email protected] Mobile +46767200181


Ari IkonenSolution Architect, Cloud at Customer Solution Engineer [email protected] Mobile +358 438246130

Thank you – please reach out for any questions!

mailto:[email protected]

mailto:Ari%[email protected]

Q & A

40

virtual event: oracle exadata strategy and roadmap for new

Documents