An introduction to

Oracle Database
Jenny Tsai-Smith
Vice President
Oracle Database Product Management
 Data is the invisible power
inside nearly every
action and decision in
public, private, and
commercial life.

2
The Future is Data Driven

Creating value from data will

increasingly determine
competitiveness

To become data driven,

enterprises need
Data Driven Apps
and Paradigms
3
Copyright © 2021, Oracle and/or its affiliates
Data Driven Apps Create Value from Data in New Ways

Machine Real-Time IoT Graph

Learning Analytics Analysis

Text Spatial
Document Blockchain
Search Processing
s

4 Copyright © 2021, Oracle and/or its affiliates

Data Driven Apps are Built Using New Dev Paradigms

Microservices Events SaaS Distributed

Data

CI/CD API Driven Defense Low Code

Development in Depth

5 Copyright © 2021, Oracle and/or its affiliates

Approaches | Single-Purpose vs Converged

Amazon & Niche Database Oracle Database

Vendors

Amazon Amazon Amazon Amazon

Aurora DocumentD Redshift Quantum
B Ledger

Azure MongoDB Snowflake Google

Synapse Document Store Data Warehouse Big Query
Analytics

Run single-purpose proprietary database Run converged, open, SQL Database

for each data type and workload for multiple data types and workloads

6 Copyright © 2021, Oracle and/or its affiliates

 Data Fragmentation from Single-Purpose Databases

• Each single-purpose database stores a fragment

of your enterprise data, requiring data to be
moved around and transformed

• Integrating fragmented data makes application

development and analytics extremely complex

• Operating many unique databases is inherently

complex, expensive, and risky

n contrast, the converged approach is inherently simpler, lower cost, and lower risk.
4 Copyright © 2021, Oracle and/or its affiliates
Strategy | World’s Best Converged Database Engine
Enterprise-class performance, scalability, reliability & security for all data-driven
workloads
Any Data Any Workload Most Productive

Converged, open, SQL Transparent scale-up, scale- Developers & Architects,

database for multiple data out, sharding, in-memory, Data Analysts/Scientists and
types and data models parallel SQL DBAs

8 Copyright © 2021, Oracle and/or its affiliates

 Oracle Multitenant Simplifies SaaS Architectures

• Oracle makes it simple to implement secure and

modular SaaS Apps Pluggable Databases (PDB)
Per Tenant Tenant
PDB
• Use a separate logical database (PDB) for each SaaS tenant
• Easier to develop – tenants are transparent to App
• More agile - tenants are easily cloned, moved, etc.

• Database enforces tenant security

• No need for risky coding of tenant separation in every App

• Enables tenants to use standard tools (e.g. analytics)

Single Physical Container DB

• Used by Autonomous Database, NetSuite, Fusion

Apps, Taleo
10
Copyright © 2021, Oracle and/or its affiliates
Transparent Scale Out with Real Application Clusters

Apps run across a server pool connected to shared

storage, which:

Provides High Availability

• If a server in the pool fails, database continues to run on the
remaining servers

Enables Scalability
• When more processing power is required, add a new server

Facilitates Online Patching

• Patches can be applied to ne server while the application
remains open on the others

Configuration is completely transparent to the application

Copyright © 2021, Oracle and/or its affiliates | All Rights Reserved.

 Oracle Database Unique Maximum Availability Architecture
(MAA)

Data protection
Platinum

Customer insights and expert

recommendations
RMAN +
Flashback
ZDLRA

24/7 HA features, Active replication

Reference
Gold

architectures configuratio
Replication ns &
operational
practices Active Data GoldenGat
Production Replicated Guard e
site site
Silver

Scale out
Deployment choices
Bronze

Generic Shardin
Engineered DBCS Autonomou RAC ASM
Systems Systems ExaCS/ExaCC s DB
g

Copyright © 2021, Oracle and/or its affiliates | All Rights Reserved.

 Oracle Database Unique Maximum Security Architecture
(MSA)

Database Firewall Database

Deep monitoring of Vault Prevents
admins from Label Security &
database messages
accessing app VPD
data Database enforced
Application row level security
s
Data Safe Cloud Service
Security assessment,
0845 3215 monitoring and
auditing as a service
* * * * 3215

Data Redaction $5Ha1qui

Key Vault
Obscures sensitive HSKQ112
Encryption key storage
data that apps FASqw34 and lifecycle
should not see management
Transparent Data
Encryption
Copyright © 2021, Oracle and/or its affiliates | All Rights Reserved.
Oracle Exadata Is Engineered to be Best Platform for Oracle
Databases

Database Optimized Smart System Automated

Hardware Software Management

• Scale-out compute, • Unique algorithms • Automation and optimization

networking, and storage improve all aspects of of configuration, updates,
• Delivers the fastest database processing performance, and
performance at lowest • Enables consolidation of management
cost OLTP and analytic • Culminating in fully
workloads autonomous infrastructure
14
14 Copyright © 2021, Oracle and/or its affiliates and database
Oracle Database Is Available On-Premises and in the Cloud
Develop and Deploy Anywhere – Extreme Portability

On- Public Cloud@Custom Dedicated

Premises Cloud er Region
Hosted, co-managed, or fully managed (autonomous)

• Database Editions • Autonomous Database • ADB Cloud@Customer • Autonomous

(Enterprise, • Database Cloud Service • Exadata Database
Standard, • Exadata Cloud Service Cloud@Customer • Database Cloud
Express) • Database on OCI Service
• Database Options Compute • Exadata Cloud
• Exadata DB Service
Customer
Machine Choice of Cloud Strategies: Hybrid Cloud, Intercloud/Multicloud
15 Copyright © 2021, Oracle and/or its affiliates
Oracle Autonomous Database
Easiest Way to Take Advantage of Oracle Converged Database Engine

Self-Driving Self-Securing Self-Repairing

Automates all Protects from both Protects from all
database and external attacks downtime
infrastructure and malicious including planned
management, internal users maintenance
monitoring, tuning

Copyright © 2021, Oracle and/or its affiliates | All Rights

Reserved.
Autonomous Database Takes the Journey Forward
Eliminates all complexities of database deployment and management

Infrastructure Oracle Automated Data

Automation Database Center Operations
With Exadata Automation Augmented
by Machine Learning

17 Copyright © 2021, Oracle and/or its affiliates

 Autonomous Database as Modern Data Warehouse
Empower business innovators with next generation cloud data warehouse

Data Sources Oracle Autonomous Business

Database Analytics
Applications

Oracle Oracle
EBS NETSUITE
Data Insights Graph Analysis

Databases NoSQL
Business Spatial Analysis
Modeling
Files {…} CSV

Transform Machine Learning

Streaming
Services

Data
Lake OCI Object Data Load Low-Code
Storage
AppDev

18 Copyright © 2021, Oracle and/or its affiliates

 Oracle Autonomous Database placed
#1 for all four Operational Use Cases and
#1 or #2 for all four Analytical Use Cases
in 2020 Gartner Critical Capabilities for Cloud DBMS
Reports
Source: Gartner Critical Capabilities for Cloud DBMS for Operational Use Cases, Merv Adrian, Donald Feinberg, Rick Greenwald, Adam Ronthal, Henry
Cook and Gartner Critical Capabilities for Cloud DBMS for Analytical Use Cases, Henry Cook, Donald Feinberg, Merv Adrian, Rick Greenwald, Adam
Ronthal, November 2020
The Gartner documents are available upon request from Oracle. Gartner does not endorse any vendor, product or service depicted in its research
publications, and does not advise technology users to select only those vendors with the highest ratings of other designation. Gartner research
publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all
warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.
GARTNER is a registered trademark and service mark of Gartner, Inc. and/or its affiliates in the U.S. and internationally and is used herein with
19 Copyright
permission. © 2021,
All rights Oracle and/or its affiliates
reserved
The World Runs on Oracle Database

97%
of the FORTUNE Global 100
depends on Oracle Database
Our Customers

Examples of customers who signed large contracts in FY21 Some examples of ADB customers

21 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal

Kaiser Permanente
modernizes healthcare
delivery

• Migrated off Teradata to Oracle Database on

Exadata

• Runs Epic Clarity packaged applications; up to

10x performance increase on Exadata

• Uses Exadata Cloud Service as part of disaster

recovery (DR) solution

• Board of Directors mandate to evaluate only cloud

options

• Successful cloud DR solution led to Oracle Fusion

SaaS contract

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

Unicomer Group innovates
retail insights

• Leading specialty retailer with more than 1,100

stores in 27 Latin American countries

• ATP-D and ADW-D consolidated 60 data

sources for a unified dedicated data store to
monitor business performance

• ADB auto-scaling reduced cost by 60%

compared to AWS

• 4-6X database performance improvement

and faster report generation, resulting in 3x
more requests for advanced analytics from
across the company.

• Scalable and flexible infrastructure to

accelerate mergers and acquisitions

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

MESTEC optimizes
manufacturing

• Leading SaaS provider for intelligent

manufacturing planning and execution

• Used ATP for flexibility to scale up or down

highly available database in seconds

• 600% performance improvement with

ATP combined with Azure Interconnect

• Zero downtime for patching at half the

infrastructure and labor cost

• Harnessing the power of data to drive up to

60% improvement in productivity

Copyright © 2021, Oracle and/or its affiliates

1. start with what is the data capital opportunity and why converged database
approach,
2. then talk about the benefits of having the same converged database engine on-
prem, on public cloud, and cloud@customer, emphasizing our support for
hybrid cloud and inter-cloud/multicloud.
3. Next, I'll talk about the main customer workload types and
1. map them to best-fit database services (co-managed vs fully-managed):
packaged apps, bespoke apps, data warehouse/analytics, disaster recovery,
etc.
4. As I drill down into the services, I'll talk very briefly about the key features and
technologies (e.g., RAC, Multitenant, Exadata, Autonomous, Data Guard, GoldenGate,
etc).
5. I'll end with a couple of customer stories - probably Kaiser Permanente, and Unicomer.
Storyboard/Outline
Overview of current Database products
• What are they (on-prem through autonomous)
• Use cases for each
• Business benefits of each
• Management responsibilities for each (what the customer manages vs what Oracle
manages)
How are customer facing roles positioning the value of each database solution
How should OCI executives think about the relationship between OCI and each DB
Roadmap (what is coming and when)
Who can execs reach out to to further support executive discussion about our databases (if
customers want to go deeper)

27 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted

Converged Databases
Optimized for Multiple Data Types & Workloads

Any Data Any Workload

Relational, JSON, XML, OLTP, analytics, in-
graph, spatial, OLAP, memory, IoT, streaming,
blockchain multitenant, persistent
memory store, etc.

Most Productive Enterprise-Class

Declarative SQL and Best performance,
transactions on any data, scalability, reliability and
Java, JavaScript, AutoML, security for all data and
microservices, events, workloads
CI/CD, APEX

Copyright © 2020, Oracle and/or its affiliates

Data Fragmentation from Single-Purpose Databases

Single-Purpose "best-of- Each single-purpose database

breed" database for each stores a fragment of your
data type and workload enterprise data, requiring data to
be moved around and transformed

Integrating fragmented data makes

application development and
Doc Spatial IoT Blockch
ain
analytics extremely complex

Operating many unique databases

is inherently complex, expensive,
Text Reporti Machine Graph and risky
Searc ng Learning
h

Copyright © 2020, Oracle and/or its affiliates

Converged Database
Deploy it anywhere!

On-Premises

Public
Cloud

Cloud@Customer

33 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted

Native Sharding Simplifies Distributed Data Architecture

Oracle makes it simple to deliver Data Sovereignty or Massive-Scale using native

Sharding
Shard large databases into a farm of smaller databases
• Shards can be placed in-country to satisfy data
One Massive DB sovereignty
to Many Small
DBs • Shards are fully isolated - linear scalability of data and
USA EU ASIA users
• Routes SQL based on shard key, or runs cross shard SQL
Shards • Online addition and reorganization of shards

All the benefits of sharding with all the benefits of a mature SQL Database

Copyright © 2021, Oracle and/or its affiliates | All Rights Reserved.

Database Products & Services
Availability

Converged Single Oracle Oracle Sharding / Oracle (Active)

Instance Database Multitenant / Oracle RAC Data Guard
Pluggable
Databases

35 Copyright © 2020, Oracle and/or its affiliates

Database Products & Services
Autonomous Database

Optimized
for Low-Code
Autonomous
Data Warehouse

Optimized
for JSON

Autonomous
Optimized
Transaction Processing
for Graph
36 Copyright © 2020, Oracle and/or its affiliates
Database Products & Services
Machine Learning, Blockchain, Goldengate

Machine Learning Blockchain GoldenGate Exadata

• item • item • item • item
• item • item • item • item
• item • item • item • item
• item • item • item • item

37 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted

Now | Oracle Exadata X8M
Latest generation of the world’s fastest database machine, on-prem and in Oracle
Cloud

Persistent Memory: Highest Performance & Lowest I/O Latency

• 19 microsecond I/O latency is >50x faster than flash storage

New Faster RDMA Network over Converged Ethernet (RoCE)

Latest CPUs with More Cores, 28% Faster Clock than Exadata X7

40% More Database Storage than Exadata X7

140% More Storage Cores than X7 Accelerates Smart Scans

39 Copyright © 2021, Oracle and/or its affiliates

 Exadata Hybrid Cloud Deployments

Electronics Healthcare Governmental

Manufacturer Provider Organization

PROD DR PROD DR PROD DR

Active Active Active

Data Data Data
Guard Guard Guard
Exadata IaaS Exadata Exadata Exadata Exadata
On-Prem Oracle On-Prem Cloud Service Cloud at Cloud Service
Cloud Customer

E-Business Suite Epic Clarity Data Warehouse Flexcube, Siebel

40
40 Copyright © 2021, Oracle and/or its affiliates
 Multi-Cloud and Converged Database
emphasizing our support for hybrid cloud and inter-cloud/multi-cloud.

From Siloed Multi-Cloud To Converged Multi-Cloud

In Memory
Database
Database Lake
Database Container

Data Gravity Issues

Cloud@Custom On-Premises
er Private Cloud
Customer Workloads
Applications Unlimited & Custom Applications on Exadata and Oracle Database

Applications Unlimited Custom Applications

• E-Business Suite • item

• JD Edwards • item
• PeopleSoft • item
• Hyperion • item
• Siebel

42 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted

Customer Workloads
Data Warehouse and Analytics Solutions

Refine & Persist & Process Analyze & Predict

Integrate

Power
Data Data Innovation
Any Data Warehouse Science
Any Format Data
Boost
Deep Engineering Efficiency
Oracle
Apps & Data Data Analytic
Database Lake Mart Analytics Reduce
Apps
Integration Risk

On-Prem Azure
FastConnect
Flexible Flexible Interconnect
Compute Storage

43 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted