Introduction to Database as a Service

(1)

Introduction to Database as a Service

(2)

Establish an IT delivery model that reduces costs, meets

demand, and fulfills the state’s legislative goals

Re-align current strategic initiatives and delivery models to

match the alternate models established in a new

Roadmap and Future State Architecture

Set up detailed OpEx business models

to meet agency budget constraints

Develop a cloud service provider capability model,

business architecture, and operating model for

bringing state agencies into the cloud

Create an infrastructure that allows you to scale with

customer demand at identifiable price points

Database as a Service (DBaaS)

Starts With The Business Needs

(3)

…That Drives and Supports the IT Agenda

Consolidate data centers across the state and

consolidate disparate IT infrastructures

Allow agencies to utilize a consumption-based

model for database services

Decrease our unit price while still meeting agency demand

Develop a prioritized list of architecture recommendations

based on the future state architecture

Create a set of transition architectures that progress the

current state to the desired future state

Provide a cost analysis and benefit analysis from

each transition architecture

(4)

Solution: Texas DCS DBaaS - Benefits

On Demand Database

Services

• Faster Time to Value

• Business Agility

Improved Performance

• Increased productivity

• Continuity of operations

• Advanced monitoring

Standard Technologies

& Best Practices

• Complete tool set, Standard

processes, Simplification

• Higher Reliability,

Simplification, better Support

Resource Pooling

• Increased Utilization,

• Efficiency

• Lower Costs

Predefined DB

configuration

• Quality of Service

• Productivity

• Lower Risks

Defined Capacity,

Metering of Usage

• Transparency

• Predictability

Elasticity

• Agility

• Rapid Respond to Change

• Scalability

Additional Security

• Protection for data at rest

• Data access isolation and

control

Cost Savings

• Faster time to value

• Optimized system

• Reduced licensing costs

• Reduced storage costs

• Single vendor accountability

(5)

Solution: Texas DCS DBaaS - Capabilities

Performance

• Integrated HW and SW

engineered together

• Offload data access from

DB processors to Storage

• Group data for access and

administration benefits

Cost

• Less disk space required for

DB files

• Less time required to test DB

upgrades

Security

• Encrypt data at rest and in

transit over the network

• Segregate data access for

privileged users

HA/DR

• DB fault tolerance,

performance, scalability

• Reporting and backup

processing on DR DB

DB Management

• Provide an automated self-

diagnostic engine

• Automates the tuning

process with SQL advisors

• DB configuration, patching,

and change management

Migration

• Move data without

business interruption

• Fast data load into the

database

System Management

• Integrated enterprise IT

management environment

• DB provisioning, resource

mgmt, and chargeback

(6)

Solution: Texas DCS DBaaS - Products

Performance

• Exadata Engineered

System

• Exadata Storage

Software

• Oracle Partitioning

Cost

• Oracle Advanced

Compression

• Oracle Real Application

Testing

Security

• Oracle Advanced Security

• Oracle Database Vault

HA/DR

• Oracle Real Application

Clusters (RAC)

• Oracle Active Data Guard

DB Management

• Oracle Diagnostics Pack

• Oracle Tuning Pack

• Oracle DB Lifecycle

Management Pack

Migration

• Oracle Golden Gate

• Oracle Data Pump

System Management

• Oracle OEM R12

• Oracle Cloud

Management Pack

(7)

Texas DCS DBaaS – Infrastructure Foundation

DBaaS Requirements

 Many Databases of all Sizes

 Unpredictable Volumes

 Mixed Workloads

• OLTP / Web Commerce

• Reports / Ad hoc Queries

• Data Loads / Backups / Batch Jobs

• Data Marts / Warehouses

• Development / Test

• Upgrades / Maintenance

 Outages are Costly

 Security is Mandatory

Oracle Exadata

 Pre-Built & Optimized

 Scalable Capacity

 Workload Prioritization

 Continuous Availability

 Maximum Security

(8)

DBaaS Infrastructure – An Innovative Approach

VS

(9)

A High Performing and Scalable DB Infrastructure

 Simplification / Minimum Moving Parts

 HW and SW Engineered to work together

 Open Standards Architecture

 High Performance and Scalability

 High Availability and Disaster Recovery

 Flexibility & Speed (Resource Pooling)

 Automation & Simplicity (Optimized System)

 Information Security & Integrity

Engineered Together

Tested Together

Certified Together

Deployed Together

Upgraded Together

Managed Together

Supported Together

ENGINEERED

TECHNOLOGY STACK

(10)

Texas DCS DBaaS – Exadata Platform of Choice

One architecture for…

• Online Transaction Processing

• Data Warehousing and Reporting

• Database Consolidation

• GIS

Exadata is Texas’ Strategic Database Platform

For Oracle Database Workloads

(11)

TX DCS DBaaS Service Catalog: DB Size

Extra Small Database

• Entry level database environment for small agencies or departmental

applications

Small Database

• Standard Agency level database with no intensive processing requirement

Medium Database

• Medium sized database environment for Agency DB consolidation

Large Database

• Optimal service for large, complex database and data warehouse

environments

(12)

TX DCS DBaaS Service Catalog

Sample DBaaS Service Catalog

Offering Catalog Cores Memory Storage

Extra Small 1 6 GB 100 GB min

Small 2 12 GB 200GB min

Medium 4 24 GB 300GB Min

Large 8 36 GB 400GB Min

*Sizings can be combined to create 'custom' configurations

Service

Level

DB H/A Business

Continuity

Storage Backup DR Outage

RTO

(estimate)

DR RTO

Silver Single Node

(Primary Site)

N/A No Mirror Tape D4-D1 48 Hr Max +72 Hr

Gold Dual-node RAC

(Primary Site)

N/A Mirror Tape D4-D0 24 Hr Max +24 Hr

Platinum Multi-node RAC

(Primary Site)

50% Capacity

(Geo Site)

Multi-cell mirror

and replication

Rep

Storage

DP 1 Hr Max +1 Hr

(13)

TX DCS DBaaS Isolation: All Service Levels

• Centralized

system

management

• Secure access

for full control

• Holistic Patching

• Monitoring &

Transparency

of usage and

operation

• No one else

can bring

down your

applications

• No one else

can access

your data

• Encryption

• PCI, HIPAA

Security Availability

Management

Auditing

(14)

Texas DCS DBaaS in Summary: Agency Value

Mission

impact

Quicker Time

to Use

You Can Do

More

IT Cost

Savings

Assets

HW

SW

Operations

Green

Support

Reduce

Complexity

Standardize

Consolidate

Automated

Support

Significant storage and

backup savings

Helps drive datacenter

consolidation

Do more for lower costs

Software is included. No

licensing costs

Shrink data center sprawl

One vendor to call

Lowers cost of support while increasing

maintainability

One admin team, one tool set, etc.

Uses common infrastructure services

A full array of Oracle software and the

latest in hardware is included

Pre-configured out of the box

Reduces power and

cooling costs

Agency

Value

(15)

Getting Started: Engagement Process Overview

•Present Services

and Value

Proposition

Present

•Submit Request

for New DBaaS

Tenant Account

Nominate

•Technical

Discovery &

Assessment

Of Oracle DB

footprint

Assess

•Develop Personalized

Migration Plan &

Scheduling

•Assign Resources

Plan

•Proof of

Concept

•Test

•Validate

Pilot

•Migrate Data with

Tools, Follow

Migration

Methodology

Migrate

• Coordinate

DNS

Switchover

Go Live

Flyer and

Presentation

Short

List

Tenant

Questionnaire

Standard WBS

Test Plan

Acceptance

Plan

Success

Story

(16)

Thank You

QUESTIONS?

(17)

Exadata DBaaS Environment

Texas DCS, Oracle DBaaS bundled software benefit

Product Qty Metric Price List License Discount Net Price

Annual

Support

TOTAL 1st

Year

Database Enterprise Edition 0 CPU $47,500 $0 45% $0 $0 $0

Diagnostics Pack 3 CPU $5,000 $15,000 45% $8,250 $1,815 $10,065

Tuning Pack 3 CPU $5,000 $15,000 45% $8,250 $1,815 $10,065

RAC 3 CPU $23,000 $69,000 45% $37,950 $8,349 $46,299

Partitioning 3 CPU $11,500 $34,500 45% $18,975 $4,175 $23,150

Advanced Security 3 CPU $11,500 $34,500 45% $18,975 $4,175 $23,150

Life Cycle Management 3 CPU $12,000 $36,000 45% $19,800 $4,356 $24,156

Data Vault 3 CPU $11,500 $34,500 45% $18,975 $4,175 $23,150

Advanced Compression 3 CPU $11,500 $34,500 45% $18,975 $4,175 $23,150

Ausit Vault and DB Firewall 3 CPU $6,000 $18,000 45% $9,900 $2,178 $12,078

Real application Testing 3 CPU $11,500 $34,500 45% $18,975 $4,175 $23,150

Golden Gate 3 CPU $17,500 $52,500 45% $28,875 $6,353 $35,228

Active Data Guard 3 CPU $10,000 $30,000 45% $16,500 $3,630 $20,130

TOTAL $408,000 $224,400 $49,368 $273,768

(18)

DBaaS Pricing

DBaaS Environment Unit Price Quantity/yr Cost/yr

Silver Extra Small $2,144.82 12 $25,738

Silver Small $4,289.63 12 $51,476

Silver Medium $8,500.55 12 $102,007

Silver Large $16,843.68 12 $202,124

Gold Extra Small $2,307.06 12 $27,685

Gold Small $4,614.13 12 $55,370

Gold Medium $9,143.59 12 $109,723

Gold Large $18,117.86 12 $217,414

Platinum Extra Small $4,614.13 12 $55,370

Platinum Small $7,509.54 12 $90,115

Platinum Medium $14,862.98 12 $178,356

Platinum Large $29,413.73 12 $352,965

NOTE: Partner Group #2 receives 35% discount off prices above due to existing ULA .

Optional Additional Storage / 200GB (per 200 GB) $182.04

Optional Additional Instance Memory / GB (per GB) $145.07