Oracle Database Cloud

(1)

Oracle Database Cloud

Shakeeb Rahman

(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

(3)

Agenda

•  Cloud Introduction

•  Oracle’s Cloud Offerings

•  Database Cloud Service

•  Architecture

•  Summary

(4)

The Cloud

Essential Characteristics / Industry Definition

Special Publication 800-145

= Internet Access from All Devices = Automation

= Multi Tenant / Virtualization = Capacity on Demand

(5)

The Cloud

Service Models

Infrastructure as a Service (IaaS) Raw compute or storage resources typically virtual machines

Database as a Service (DBaaS) Ability create / access / size database using database API’s

Platform as a Service (PaaS) Managed full environment, database, web servers etc

Software as a Service (SaaS) Application services accessed from cloud clients

(6)

Cloud Database Offerings

Market Spectrum Amazon EC2 / DB AMI Amazon RDS Microsoft SQL Azure Salesforce.com Database.com Salesforce.com Force.com

Oracle Database Cloud Service

Heroku

Fully Managed Solution

(7)

The Cloud

•  Complexity and Capital Cost Paid by Provider

–  Fully automated provisioning and management

–  Managed Service: Software, Hardware, Upgrades, Backups –  Data centers and staff

•  Monthly Service Fee

–  Pay for capacity and compute resource used –  Predictable operating expense fees

•  Capacity on Demand

–  Use what you need when you need it –  No need to predict future capacity

(8)

Oracle Cloud

(9)

Database Cloud Service

(10)

Oracle Database Cloud Service

•  Easy

•  Self service provisioning

•  Free Trials

•  Standards Based

•  SQL, Java, REST, HTML5

•  Enterprise Grade

•  Oracle Enterprise Edition* / Exadata

•  24-7 Support and management

•  Simple Pricing

•  S5, S20, S50 based on DB size

•  Month-to-month and term subscriptions

(11)

Oracle Database Cloud Service

•  New cloud-based development / deployment

–  Java Application Deployment (with purchase of Java Service)

–  Oracle Application Express (APEX) Development and Deployment –  RESTful Web Service publishing

–  Future services will broaden Oracle’s cloud capabilities

•  Migrating existing applications

–  Oracle Application Express (APEX) - with some limitations –  Java Applications - with some limitations

•  Target Markets

–  Small & medium sized businesses –  Departmental and lines of business –  IT departments

–  Partners and ISVs

(12)

Oracle Database Cloud Service

Oracle Application Express (APEX), SQL Developer, and Cloud Portal User Interfaces

APEX SQL Workshop SQL Developer APEX Application Builder

RESTful Web Services _{Packaged Applications} _{My Services Portal}

SQL Development SQL Development / Data Loading HTML5 App Dev

(13)

Oracle Database Cloud Service

APEX SQL Workshop •  Browser Based •  Integrated SQL Development •  SQL Command •  SQL Scripts •  Object Browser

(14)

Oracle Database Cloud Service

SQL Developer

•  Free OTN Download

•  Local DB Connections

•  Cloud Connections

•  Data Loading (Shopping Cart)

•  Browse Cloud Objects

•  Migrations from Third Party DB

•  More robust then Oracle APEX SQL workshop for local DB

Development

(15)

Oracle Database Cloud Service

APEX Application Builder

•  Browser Based

•  Create and Import Applications

•  Wizards

•  User Interface Themes

•  Robust Reporting

•  Declarative Forms

•  Charts / Calendars

•  Pluggable Components

(16)

Oracle Database Cloud Service

RESTful Web Services

•  Defined using Oracle APEX or SQL Developer

•  Easily create RESTful APIs

•  Call from STATIC HTML via Javascript that returns JSON

•  Public or Authenticated via OAUTH

•  Integrate with any App Dev

(17)

Oracle Database Cloud Service

RESTful Web Services – Example JavaScript Source with Oracle Cloud REST call

$(document).ready(function () {var theme = getDemoTheme(); //var url = "../sampledata/beverages.txt";

var url = "https://database-trialabsg.db.us1.oraclecloudapps.com/apex/ cfulistLastTen";

//

// prepare the data var source = {

datatype: "json", datafields: [

{ name: 'empno', type: 'int' }, { name: 'ename', type: 'string' },{ name: 'job', type: 'string' }, { name: 'hiredate', type: 'string' },

{ name: 'sal', type: 'string' }, { name: 'deptno', type: 'int' } ],

id: 'id’,url: url };

var dataAdapter = new $.jqx.dataAdapter(source); $("#jqxgrid").jqxGrid(

{

width: 990, source: dataAdapter, theme: theme, sortable: true, filterable: true, altrows: true,columns: [

{ text: 'Emp No', datafield: 'empno', width: 250 },{ text: 'Name', datafield: 'ename', width: 250 },

{ text: 'Title', datafield: 'job', width: 180 },{ text: 'Salary', datafield: 'sal', width: 120 },

{ text: 'Department', datafield: 'deptno', minwidth: 120 } ]

}); });

var url = "h*ps://database-‐

(18)

Oracle Database Cloud Service

Packaged Applications

•  One Click Install

•  Simple Point Solutions

–  Survey Builder –  Project Tracking –  Data Reporting –  Bug Tracking

–  Community Requests

–  Many more (also available on OTN)

•  Mobile Interfaces

•  Upgradable

(19)

Oracle Database Cloud Service

(20)

Oracle Database Cloud Service

Oracle Cloud Administration Portal (https://cloud.oracle.com then click sign-in)

•  View Utilization Metrics & Outage Notifications

•  Export Data Structures and Data

•  Launch APEX Service

•  Oracle Store punch-out

•  Lockout Public Access

•  Manage Access Control

•  Links to resources / chat

•  Enable APEX App Archiving

(21)

(22)

REST over HTTPS

HTTPS

Oracle Enterprise Edition

v11.2.0.3 on Exadata and RAC + Cloud Lockdown, no SQL*Net

JDBC

RESTful Web Services

Any client the can use REST JS, PHP, Java, .NET, Objective C

Oracle Java Cloud

Java application deployment JDBC access from WLS to DB

SQL Developer

Data browsing Data loading/unloading

Oracle Application Express

Application development and Deployment SQL development

Oracle Database Cloud Service

Database Service Data Access

(23)

Oracle Database Cloud Service

Multi-Tenant Architecture with Schema-Based Tenant Isolation

Service 1 Service 2 Service 3 Service 4 Schema 1 Schema 2 Schema 3

Schema 4 _{Oracle Database with}

Application Express

APEX

SQL Developer

Rest

(24)

Oracle Database Cloud

Infrastructure and Architecture

VM VM VM VM

• 

Scalable: Exadata and Exalogic

• 

Full Stack: Apache, WebLogic, Identity Management, Secure FTP

• 

High Availability: Oracle 11gR2 Enterprise Edition and RAC

• 

Secure: Data isolated by schema and table-space (data file)

• 

Open: Open architecture with no “lock-in”, uses industry standards Secure FTP

Oracle 11gR2 Enterprise Edition

(25)

Database Cloud Service

Database Instance Table Table Schema Table Table Schema Compute Node Data File Tablespace Data File Tablespace Database Instance Table Table Schema Table Table Schema Compute Node Data File Tablespace

•  Multi Tenant Shared Hardware

–  Each tenant gets a completely isolated schema –  Each Exadata compute node has multiple

database instances

–  Each instance has multiple schemas (or tenants) –  Each schema / tenant is a container that can

manage database tables, indexes, code, etc. –  Each schema has one dedicated tablespace –  Each tablespace has one data file

–  No co-mingling of customer data

•  RAC One Node - Active/Passive mode

–  8 nodes, each with 3-5 database instances

•  Active Data Guard using Physical Standby

–  Uses Logical Standby for rolling upgrades –  With no Database downtime

(26)

(27)

Oracle Cloud

Benefits of Public and Private Cloud

Consolidation

Virtualization and Multi tenancy Server Farms

Yields greater resource utilization

Standardization

Standard configurations Standard API’s

Simplifies Security and Upgrade

Automation

Fully automated provisioning, usage metrics, outage notifications, upsize and downsize

(28)

Oracle Database Cloud Service

Why use Oracle

•  Write Once Run Everywhere

–  Leverage the same skills, code, and capabilities on premise and in the cloud

–  Develop on the cloud and deploy on premise, develop on premise deploy to cloud

•  Instant Access

–  Provision free trials or production environments in minutes –  Upsize when you need additional capacity

–  Full self service purchase and upsize on the Oracle Store with M2M and Term Contracts

•  Full Managed Service

–  Mid tier WLS application services

–  Oracle 11gR2 Enterprise Edition Database on Exadata –  Oracle IDM Identity Management

(29)

Oracle Database Cloud Service

Why use Oracle’s Database Cloud Service

•  Access to an Oracle database at a very low M2M price of $175

•  Gain access to Oracle Database 11gR2 on Exadata as a fully managed service

•  Get the advantages of the cloud today

•  Industries most robust browser based App Dev Framework (APEX)

•  Over 20 example and packaged app point solutions

•  Robust Data Loading and database deployment via SQL Developer

•  Declarative RESTful web service publishing

(30)

Oracle Database Cloud Service

Call To Action

1.  Get Free Trial on http://cloud.oracle.com

(31)

Join the Conversation

@OracleCloudZone #CloudWorld, #OracleCloud www.facebook.com/OracleCloudComputing

Try now: cloud.oracle.com Learn more: oracle.com/cloud

(32)

(33)

(34)