Oracle Database Public Cloud Services

(1)

Oracle Database

Public Cloud Services

A Strategy and Technology Overview

Bob Zeolla

(2)

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.

(3)

Strategy and Technology Overview - Agenda

What is Oracle Database Cloud?

What’s New?

Real World Use Cases

1

2

3 Real World Use Cases

Business Intelligence Cloud Service

Show Me How it Works

3

4

(4)

Overview & Introduction

(5)

Oracle Platform as a Service Strategy

Multitenant Database Architecture Enables the Hybrid Cloud

On Premises

Same Architecture

Oracle Cloud

(6)

Choice of Scalable Oracle Database Cloud Services

Exadata

Enterprise

Small Business

Developer

(7)

Oracle Database Cloud Service

Full Spectrum of Database Cloud Offerings

Free

Schema /

Multitenant *

DBaaS

Managed DBaaS

Exadata

Managed Exadata

2016

2015

2012

2014

2015

Editions

EE with Lockdown

SE2, EE, HP, EP

EE, HP, EP

EP

Implementation

1 Schema

1 Schema / PDB*

1 Dedicated DB

1+ Dedicated DBs

DB Management

Oracle

Customer

Oracle

Customer

Oracle

Max Storage

100MB

5, 20, 50GB -1TB*

50GB – 4.6TB

42TB – 168TB

Max CPU

< 1

~1

1 – 16

28 – 272

28 - 272

(8)

• Oracle Delivers Data Security

–

Data encrypted by default in the Cloud

Securing the Hybrid Cloud

Oracle Cloud – Security By Default

–

Data encrypted by default in the Cloud

–

In transit, and at rest

8

(9)

(10)

Oracle Database Cloud Service

3 Levels of Management

Managed*

Automated

Automated install, patch,

24-7 active monitoring and

management. Backup, recovery

and patching are fully managed

with opt-in time windows.

On Premises

Oracle Cloud

Automated install, patch,

upsize / downsize,

backup / restore / recovery,

configuration & monitoring.

10 Virtual Image

Database software ready to

install. Same software as

distributed for on premise use

.

(11)

General Purpose

Engineered Systems

Oracle Database Cloud Service

Infrastructure

• Test, Development, Enterprise Applications

• Compute Shapes - by OCPU, Standard or High RAM

• Block Storage – by the GB

• Up to 4.6TB database

• Mission Critical, Intensive OLTP and Decision Support

• ¼, ½ and Full Rack Shapes

• Fixed Storage and Memory by Shape

(12)

Automated Database Cloud Service – Full Instance Editions

Extreme Performance

High Performance

Enterprise Edition (EE)

adds…

Multitenant

Partitioning

Advanced Compression

Real Application

Clusters (RAC)

In Memory

• Data Guard

• All standard EE features

Reference: http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html

Advanced Security, Label

Security, Database Vault

Active Data Guard

• Full database instance

• Up to 16 OCPUs

• Transparent Data

Encryption (TDE)

Standard Edition

Real Application Testing

OLAP, Analytics, Spatial and

Graph

Management Packs

Greater Capabilities

(13)

Oracle Database Cloud Service

Database

Ready for

Use

Allocate

Compute

Allocate

Storage

Set Keys &

Privileges

Request

for

Service

_Provision

OS

Install &

Configure

Database

Configure

Tools

Configure

Access

Configure

Backups

Automated Database Provisioning with a 5 step wizard

Reduced time and complexity

to provision database services

Increased standardization

of the “fleet”

New use cases that were not

practical before.

(14)

Automated

DBA and Patching

Backup/Recovery

plus HA & DR

Simple Provisioning

Automated Cloud Tooling

Oracle Database Cloud Service

DBA and Patching

_{plus HA & DR}

Any Language

Comprehensive

Security

(15)

Oracle Database Cloud Service

Data Transfer and Connectivity

High-bandwidth direct

Connection with co-located

Data transfer services via

shipment of secure portable

Secure IPSec connectivity

using virtual private

Software VPN

Connection with co-located

data center

shipment of secure portable

storage devices.

using virtual private

networks

Hardware VPN

(16)

What’s New?

(17)

Oracle Database Cloud Free Service – Coming in 2015

• Free Oracle 12c Database Schema Service

• As many “Database Services” (or schemas)

within an overall quota of 100MB

• Available for as long as you use it

• Easy developer and administrator browser

access

Overview of Capabilities

General

Purpose

access

• Easy access to Java and HTML5 (JavaScript)

developers with RESTful connectivity

• SQL Developer based worksheet

• Browser based SQL workshop access via APEX

(18)

Oracle Database Exadata Cloud Service – Now in Production!

• ALL Oracle Database EE Features and Options

• UNIQUE Exadata Performance and Technologies

• MISSION CRITICAL Availability, Security

• EXTREME PERFORMANCE OLTP, Analytics, In-Memory DB

Best Database on Best Platform with Best of Cloud

FINANCE

STUDENT

HR

DW

• EXTREME PERFORMANCE OLTP, Analytics, In-Memory DB

• EASY, NO RISK Migration: Cloud, On-Premise, Hybrid

• ZERO Infrastructure Management

• NO CAPEX: Monthly Subscription

Oracle Confidential – Internal 18

CALL

CENTER

(19)

X5-2 Full Rack

X5-2 Half Rack

X5-2 Quarter Rack

Oracle Database Cloud Edition

Extreme Performance

Configuration Option

Max

Min

Max

Min

Max

Min

Database Grid OCPUs

₂₇₂

₁₁₂

₁₃₆

₅₆

₆₈

₂₈

Total Memory (GB) (256GB per node)

Oracle Database Exadata Cloud Service

Technical Specifications

Total Memory (GB) (256GB per node)

_{Total 1,984 GB}

Total 992 GB

Total 496 GB

Raw Flash Capacity – High Capacity

76.8 TB

38.4 TB

19.2 TB

Raw Storage Capacity – High Capacity

576 TB

288 TB

144 TB

Usable Storage Capacity – High Capacity

168 TB

84 TB

42 TB

Storage Servers

12

6

3

(20)

Introducing RAC in the Oracle Cloud – Now in Production!

Bringing Database High Availability & Scalability to the Cloud

Database Cloud Service

(Database as a Service)

Database Exadata

Cloud Service

General Purpose

Engineered Infrastructure

(21)

Oracle RAC for Oracle Database Cloud

2-Node Cluster for Database as a Service

Scale Beyond Single Instance

no longer confined to single VM processor,

memory, and IO resources

Database High Availability

protection from instance failure

Automated, Rolling Patching

no outages for OS and database

maintenance

Simple Provisioning

provision a RAC database in minutes

(22)

Real World Use Cases

What can I use Oracle Database Cloud for?

(23)

Oracle Database Cloud

Typical Use Cases…

• Database Backup to the Cloud

• Disaster Recovery to the Cloud

• Business Critical Workloads in the Cloud

• Web Application Development Anywhere

Real World Use Cases - Today

• Web Application Development Anywhere

• Testing Database Applications

• Testing Database Upgrades

• Analytic Sandboxes

(24)

Oracle Database Backup Cloud Service

Backup on-premise or Cloud Databases to

Oracle Database Backup Service hosted in

Oracle Public Cloud

Cost effective, scalable cloud storage for

database backups (10.2 and above)

Offsite Backups with Simple and Low Cost Cloud Backup

On-Premises

Cloud

Databases

End-to-end enterprise-grade data encryption,

compression and protection

• Clients

: Data is always encrypted with

keys kept locally at client, optionally

compressed, and securely transmitted

• Cloud

: Encrypted data is protected with

3-way mirroring on every write

(25)

Disaster Recovery (DR) to the Cloud

• Disaster Recovery to Cloud for Databases

–

On-premises Primary

_{Oracle Cloud Standby (PaaS)}

–

Using Data Guard or Active Data Guard

–

Manual do-it-yourself model

• Oracle validated

(Active) Data Guard

On-Premises

Oracle Cloud

Sandbox Test/Dev in

the cloud

Oracle validated

–

End-to-end deployment procedure

• Try it Out Now

–

Detailed MAA Technical Paper available*

–

Scripts and some level of automation provided

On-Premises

Primary Database

Oracle Cloud

Standby Database

(26)

• Choice of application development

frameworks

• Same application tools as used

in-house

Oracle Database Cloud

for Application Development

Oracle APEX

Oracle REST

Data Services

*

_*

Java

Node.js

house

• Suitable for new and existing

applications

• Reduces capital and operational

expenses

26

(27)

Test Upgrades to 12c with Oracle Database Cloud

• A fully configured 12c instance up and running in 60 minutes

• Use the cloud to practice the upgrade procedure

• Test out new 12c features and capabilities

• Make a mistake and want to start over?

–

Delete it and create another one

–

Use cloud storage to share data sets

• Multiple upgrade methods

–

Use Transportable Tablespaces

–

Data Pump export/import upgrades

–

Remote clone PDBs

(28)

Business Intelligence Cloud Service

Ed Hook – Higher Ed.

Business Reporting and Student Analytics

(29)

Introducing BI Cloud Service

• Data Mashup across Managed and

User Data

• Proven Reporting Solution

• Integrated with Oracle DB

• Browser and mobile support

• Clean page design

(30)

Consistent Definitions Drive Better Decisions

• Single Source Of Truth

–

Across data sources

–

Across teams

• Governance

–

Data Lineage and Version Control

–

Data Lineage and Version Control

• Security

(31)

• Highly intuitive

“do-it-yourself”

visual data discovery built on the

OBIEE platform

• Rich library of visualizations

• Fully Interactive Story-telling

Visual Analyzer

Data Discovery \ Interactive Visualization Client

• Fully Interactive Story-telling

• Data blending

(32)

Rapid Provisioning

Sign Up

Quickly provision your BI instance

No Installation Required

Log On

Oracle Managed patching and

upgrades

(33)

BI Cloud Service Demo

(34)

Show Me How it Works

Oracle Database Cloud Provisioning Demo (with RAC and Exadata)

(35)

(36)

1

(37)

(38)

3

(39)

(40)

5

(41)

(42)

(43)

(44)

Wrap Up

(45)

Oracle

Database

as a

Service

Oracle

Exadata

Cloud

Service

Oracle Database Cloud – Summary of Services

• 100%

compatibility with

on-premises

• Fully automated or

managed backups,

patching and

tooling

Full-featured dedicated single-node/RAC database

Primary Use Case: Dev, test and deployment of existing apps

Highest-performing and most-available database platform

Primary Use Case: Mission-critical applications and high

density database consolidation

Service

Oracle

Database

Schema

Service

Oracle

Database

Backup

tooling

• Simple to move

locations or create

a hybrid cloud

• Simple

provisioning in a

few clicks

Fully managed Database Schema as a service for app dev with

APEX, SQL Developer, Java Cloud and RESTful Web Services

Primary Use Case: Development and deployment of

departmental applications

(46)

For More Information

About Oracle Database Cloud Service

https://cloud.oracle.com/database

Oracle Database Cloud 30-Day Free Trial

https://cloud.oracle.com/database

Join the Conversation

@OracleCloudZone #OracleCloud

www.facebook.com/OracleCloudComputing

https://blogs.oracle.com/dbaas

(47)