slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Enterprise Manager DBaaS : Database, Schema, or Terabytes of Data in Minutes PowerPoint Presentation
Download Presentation
Enterprise Manager DBaaS : Database, Schema, or Terabytes of Data in Minutes

Loading in 2 Seconds...

play fullscreen
1 / 51

Enterprise Manager DBaaS : Database, Schema, or Terabytes of Data in Minutes - PowerPoint PPT Presentation

  • Uploaded on

Enterprise Manager DBaaS : Database, Schema, or Terabytes of Data in Minutes. Shailesh Dwivedi Director Product Management. Description . Session: CON1719 Title : Oracle Enterprise Manager DBaaS : Database, Schema, or Terabytes of Data in Minutes

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Enterprise Manager DBaaS : Database, Schema, or Terabytes of Data in Minutes' - yan

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
enterprise manager dbaas database schema or terabytes of data in minutes
Enterprise Manager DBaaS: Database, Schema, or Terabytes of Data in Minutes


Director Product Management


Session: CON1719

Title: Oracle Enterprise Manager DBaaS: Database, Schema, or Terabytes of Data in Minutes

Description: Database as a service (DBaaS) is the latest trend in providing automated database services to a wide set of end users. In this session, you will learn about the latest features in DBaaS, including schema-based consolidation, thin provisioning of data, and other exciting features.

safe harbor
Safe Harbor

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.

table of contents
Table of Contents
  • What is DBaaS?
  • Key Challenges
  • Oracle’s Cloud Solution
    • Database and Schema Consolidation
    • Rapid Template based Provisioning
    • Data Cloning (Storage Copy on Write and RMAN Backups)
  • Customer Story – HDFC Bank
total cloud control
Total Cloud Control

Integrated Cloud Stack Management

Business-Driven Application Management

Complete Cloud Lifecycle Management



Self-Service IT

Simple and Automated

Business Driven

customers have a choice of clouds
Customers Have a Choice of Clouds


Shared by multiple organizations

Hybrid Cloud

Private Cloud

Public Cloud

  • Cloudbursting – overdraft for peak loads
  • Dev/Test & production
  • B2B integration
  • CapEx & OpEx
  • Lower total costs
  • Control & visibility
  • Multiple apps sharing resources
  • OpEx
  • Fast & inexpensive to start
  • Outsourced services
  • Multiple tenants sharing resources

Private Cloud: PaaSvsIaaS

  • Increasing Enterprise value with Private PaaS
  • Private PaaS
  • Enforces standardization and consolidation
  • Provides Security and Compliance
  • Maximizes component re-use
  • Minimizes hand coding
  • Maximizes flexibility and control
three key challenges
The problem of many and varied
  • Manual, time consuming provisioning
  • Data, lots of data!
Three Key Challenges
need for standardization and consolidation
Need for Standardization and Consolidation

Complex and ever growing database estate

Highcost of operation

High cost of deployment

PoorUtilizationH/W, CPU,



Workloadmultiple skills,lots of disparate


poor automation

“a mixture of versions, operating systems, hardware; rapidly falling into legacy”

Poor service,

long lead times

consolidation at paas and iaas layers
Consolidation at PaaS and IaaS Layers
  • Consolidate onto standard, shared and elastically scalable PaaS




  • Standardized PaaS for all applications reduces heterogeneity, cost and complexity
  • Accelerated new application development
  • Cost savings from less hardware, power and data center space









  • Software stack heterogeneity, cost and complexity persists
  • No administration (O&M) cost savings
  • Consolidate onto shared IaaS without standardization
  • Cost savings from less hardware, power and data center space


dbaas cloud models
DBaaS Cloud Models

Infrastructure Cloud

Database Cloud

Database Cloud




















Shared Database

Shared database instances






Increasing Consolidation

Shared Cluster

Shared pool of servers


Shared pool of hypervisors

considerations for choosing the right model
Considerations for Choosing the Right Model
  • Brownfield or Greenfield?
  • Commodity Servers Vs Engineered Systems?
  • Applications to be deployed, and their database footprint?
  • Expected SLAs from business users?
  • Isolation or Security requirements?
  • Ease of management? Available skill set?
  • Is self service needed? If yes, who is the user, and what do they expect from this service?

Most Customers Settle On a Combination these Models

examples of dbaas cloud model usage
Examples of DBaaS Cloud Model Usage

Shared Cluster

Shared Database

Shared Server

  • Application DBA
  • Provision database for a complex packaged application e.g. eBiz
  • Application Tester
  • Clone a production database for performance testing
  • Application Developer
  • Provision one or more schemas for a homegrown custom application
  • Sales Engineer
  • Provision schema with data for a training app
  • Junior DBA
  • Build test environment to verify a database patch
  • Application Developer
  • Provision application middleware and database on the same VM
Key Challenge 2: Manual and admin based provisioning Solution: Rapid provisioning of Standardized Templates
need for rapid template based provisioning


Need for Rapid Template based Provisioning

Database-as-a-Service Deployment(End-user driven)

Traditional App Deployment(Admin driven)

Specify and procure hardware

Request database deployment

Configure hardware

Deploy hardware


Adjust capacity as demand changes


OS and Storage

Deploy operating system and configure storage

Server Hardware

Retire database when not needed

Deploy database

User unaware of underlying infra

Self-Service Provisioning

em 12c most comprehensive dbaas solution
EM 12c: Most Comprehensive DBaaS Solution
  • Self service paradigm for database deployment and management
    • Pre-packaged, pre-configured database configurations
    • One-click provisioning and deployment of databases
    • On-demand scalability of underlying platform
  • Support for allthreeDBaaS deployment models
  • Metering and chargeback/showback for IT accountability
  • Data cloning using Storage copy on write and RMAN Backups
  • Intelligent Auto-placement, Quota Management, Role based access, and so on ..
schema as a service

Ultimate consolidation of databases (shared database deployment model)

Each application user gets one or more database schema(s)

Service level guarantee through Database Resource Manager

Security isolation through Data Vault

Integrated with Database 12c Pluggable Databases

Multiple pluggable databases within a single container database

Schema as a Service
schema as a service user portal
Schema as a Service User: Portal
  • Out-of-box console ; no additional set up required
    • Supports custom background
  • Rich service catalog:
      • Database instances
      • Schemas
  • Database portal functions
    • List all databases and schemas
    • List requests, quota usage, and notifications
    • Resource Monitoring
    • Backup/restore
  • RESTful Web Service based APIs and CLIs
schema as a service user features
Schema as a Service User: Features
  • A ‘Schema’ request provides
    • 1 Database (Application) Service
    • N schemas/users
    • 1 master account that has grants over other schemas
    • 1 tablespace
  • Request for a ‘Schema’ instance
    • Choose service templates with/without seed data
    • Rename and set passwords for schemas
    • Upload custom sql scripts for execution
    • Pick duration
  • Home page for management of provisioned instances
dbaas setup schema as a service
DBaaS Setup: Schema as a Service

Roles and Responsibilities

Self Service Administrator

Cloud Administrator

dbaas cloud resource model
DBaaS Cloud Resource Model

PaaS Zone

Collection of various pools – MW & DB

Based on geography, cost center, …

Database Pool

Defines a homogeneous collection of Databases or Oracle Homes

Mandatory criteria

- platform, db version, availability (SI/RAC)

Optional criteria

- SLAs, security, product lifecycle, …

Databases and Oracle Homes – Single instance and clustered







N = Node

SI = Single Instance

RAC = Real Application Clusters

setup service catalog capture publish to catalog
Setup Service CatalogCapture -> Publish to Catalog
  • Publish Service Template to Service Catalog
    • Schemas with or without data and objects
    • Assign roles and privileges for master account
    • Register pre and post creation sql
    • Tablespace encryption for secure environments
  • Capture Database Provisioning Profiles
  • Capture schema and data from existing databases
  • Uses datapump for export/import
setup service catalog contd
Setup Service Catalogcontd.

Workload Sizing and Placement

  • Workload Sizes
    • Based on projected usage of CPU, Memory, and Storage
    • Define Small/ Medium/ Large workloads
    • Attach to Service Templates
  • Placement Algorithm
    • Simple: By number of services
    • Advanced: Based on projected workload characteristics
  • Resource Manager for CPU allocation
  • Fixed Datafile Size for storage allocation
chargeback reporting
Chargeback Reporting

Chargeback Administrator

Self-Service Portal User

Line of Business User

  • Rollup based on LDAP hierarchy
  • Summary and Trending reports for Usage and Charge
  • Drilldowns
  • Integrate with BI Publisher
  • Generate Reports in variety of formats
    • Excel, Word, HTML, PowerPoint, PDF
  • Email or FTP reports
  • Charge Trend reports broken down by resource
  • Selectable detail levels
  • Charge Plan configuration
Key Challenge 3: Data, lots of data! Solution: Data Cloning using Storage copy-on-write technology and RMAN backups
data cloning overview
Data Cloning Overview
  • Functional Testing of Applications
    • Most functional tests require minimal data changes
    • Testers frequently need to rollback data
  • Most storage based solutions lack lifecycle management capabilities
    • DBA Friendly. Clone ‘Databases’ instead of ‘Storage Volumes’
    • Monitoring and configuration management of the cloned database
    • Upstream Test Master creation workflows (integrated with Masking, Subsetting, etc)
    • Monitor, implement quota and chargeback based on QOS
data cloning options
Data Cloning Options

Technology Comparison

Copy on Write

RMAN Backup

  • Storage basedtechnology
  • Saves space and time
  • Ideal for "use and throw“ i.e. short lived databases
  • Storage Admin involved
  • Oracle Database based technology; Storage neutral
  • Restore time proportional to backup size
  • Leverages existing technology and infrastructure
  • Completely managed by DBAs

Data Cloning

database instant cloning using copy on write
Database Instant Cloning Using Copy on Write


Test MasterDatabase

Masking &Sub setting



Functional Copies– User can create multiple copies for functional testing without consuming space

  • Initial Support for Sun ZFS Storage and NetApp Storage
  • More than just storage volume cloning
  • Users can create snapshots and ‘timetravel’ to an earlier snapshot
dbaas setup database instant cloning
DBaaS Setup: Database Instant Cloning

Roles and Responsibilities

Cloud Administrator

Self Service Administrator

database cloning using rman backups
Database Cloning Using RMAN Backups


RMAN Duplicate

  • Backup-Based Duplication With a Target Connection
  • Backup-Based Duplication Without a Target Connection
  • Backup-Based Duplication Without a Target Connection or a Recovery Catalog Connection

Connect Target

Connect Auxillary



Connect Catalog

dbaas setup rman backups
DBaaS Setup: RMAN Backups

Roles and Responsibilities

Cloud Administrator

Self Service Administrator

about hdfc bank
About HDFC Bank
  • Incorporated in August 1994
  • India’s second largest Private Bank with a nationwide network of
    • Branches: 2,564
      • ATMs: 10,000 (In 1,416 Indian towns and cities) & 20 million customers
    • Debit Cards: 14.9 Million
    • Credit Cards: 5.8 Million
  • Industry: Retail & Corporate Banking
  • Employees: 56,000
  • Revenue: USD 5 Billion

Business Drivers

  • Retail Assets Segment [Lending Business]
    • 50% of HDFC Bank’s Top Line
    • Always under pressure to launch “New Schemes” to compete and stay ahead in this segment
    • IT must respond to this Business need because each new Scheme means – changes to application and testing against Production data [UAT database]
    • Agility in launching new business initiatives

Life Before Database Cloud

  • Average 3.5 days to provision UAT Database for Loan Management Application
  • Silo’ed environment with Average 30% utilization
  • Compliance requirement consume UAT testing resources.
  • DBA activities mean $$ paid to SI for provisioning databases manually
  • Overhead in managing configuration drift between production and test environments.
  • Rollout impact/delay on new business initiatives

Database Consolidation – Application Classification

  • Classify application based on system availability requirement/criticality

Database Consolidation Planning

  • Identify candidate application for Cloud
  • Further Group them based on availability requirement and sub classification based on OS/DB

Cloud Administration Setup

  • Zones
    • Exadata Zone
    • AIX zone
  • Role for each application on Exadata and AIX zone
  • Quota is set based on existing infra available
    • 7 Databases on LOS Application
    • 5 Databases on LMS Application
    • 5 Databases on Web collection Application
  • Universal charge plan
  • Service Templates
    • Exadata -Three templates with data
    • Exadata -Three templates with only structure
    • AIX template for Small, Medium, Large database only structure
provision databases using rman backups
Provision Databases using RMAN Backups
  • Beta Customer for RMAN restoration integration feature with DBaaS
  • Level 0 RMAN Backups of Production Databases from Standby[Bunker Copies]
  • Service Templates created for each of Level 0 Backups
  • Process to Provision Databases through RMAN is same as Empty Databases
  • DBaaS supports three different DBaaS models
    • Database in a dedicated VM
    • Databases in a shared cluster or installation, and
    • Schemas in a shared database
  • Special focus on data cloning
    • Storage copy-on-write technology, and
    • RMAN backups
  • Out of box portal to deliver all types of services