Database as a Service: An Architecture Based Approach to Designing DBaaS

1. Database as a Service:An Architecture Based Approach to Designing DBaaS Rajesh Kumar 14-May-2014 Social. Mobile. Complete.

2. Evolution to Database as a Service Traditional Silos Standardized Platform Consolidated Platform Service Delivery Platform Enterprise Cloud Platform • Standardized hardware and software stack • Standard deployment configuration • Catalog of database services and service levels • Shared & secure central data infrastructure • Dynamic optimizations & resource mgmt • Automated systems management • Fully dynamic and unified resource pools • IT as cloud broker: arbitration and brokerage • Secure hybrid cloud integration (vendors, partners, etc.) • On-demand, resilient, and tiered self-service • Rapid service elasticity and automation • Metering, automated cost allocation & chargeback • Physical • Dedicated & heterogeneous • Static with disconnected analytics Siloed Standardized Federated DBaaS Consolidated Private DBaaS Lower Risk Lower OpEx Lower CapEx Higher Agility Fully Optimized

3. DBaaS Architecture Development Process • Aligns DBaaS future state architecture with your business strategy and goals • Maximizes alignment with key DBaaS stakeholders to promote buy-in • Helps identify high value targets for building your service • Embraces an iterative approach to reduce risks

4. The Business Context establishes an organization’s motivations for investment and specific goals to be achieved Establishing metrics up front insures results are measurable and achievable Include the view points of ALL of your key DBaaS stakeholders DBaaS Business Context

5. Common Drivers for Database as a Service Metrics Cost Risk Agility Op Ex save Cap Ex save Time to provision % compliant SLA attainment % utilization Denser hardware utilization Resolve end-of-life issues Reduce provisioning time Simplify administration Achieve compliance Faster scale-out Consumption based billing Consolidate security controls Management automation Standardization Improved quality of service More focus on capability IT Simplification

6. DBaaS Architecture Vision DBaaS Architecture Vision Artifacts • Defines the key characteristics and scope of your service • Provides a platform to obtain feedback and buy-in from key stakeholders • Helps maintain alignment with the Business Context • Contains key architecture artifacts that drive your DBaaS implementation plan and build

7. What characteristics does DBaaS typically provide?

8. Example DBaaS Architecture Principles

9. Capabilities Model for DBaaS • Establishes the organizational, operational, and technical context for your service • Identifies key integration points for automation

10. DBaaS Use Cases Aligning People, Process, and Technology

11. DBaaS Service Definition The Service Definition is a formal statement of service capabilities, policies, and procedures from the DBaaS consumer’s perspective.

12. DBaaS Service Catalog Design Process • Bronze • Silver • Gold Small Large • RAC • Data Guard • Golden Gate Medium X-Large PDB Database Schema Private Public Provider Hybrid

13. DBaaS Conceptual Architecture Example Self Service Portal Web SSO Authentication BC Management Vulnerability Management Backup Storage & Management Remote Patching ASR Database Administration and Automation Orchestration RDBMS Manageability Tool RDBMS Database Backups Data Load/Unload Tools Billing/ Chargeback Event Monitoring Capacity Management Job Control System External Job Control Systems BC Tier Support Resource & Workload Management NOC API’s Metering DB Clone/ Refresh Data Load/Unload Access Universal DBA Roles Multi-Tenant Support Deployment Capacity Planning RDBMS S/W Provisioning Database Relocation Database Management Data Access Service Administration Oracle*Net Encryption CMDB RDBMS Log Management Universal App. Roles Network Address Management DB Name Resolution Patch Management Health Monitoring Code / Artifact Deployment Data Distribution Authentication Network Address Resolution Audit Log Capture SQL Interfaces Compliance Monitoring Performance Monitoring DB Hibernate/ Activate Network Configuration Service Identity, Entitlements and Audit Directory OS Break Glass OS Step Up Auth User Registry Entitlement Mgmt Security Audit

14. Current State Analysis • Identifies initial deployment opportunities • Establishes the current level of operational maturity • Provides a baseline for key DBaaS metrics • Determines where to focus development

15. DBaaS Future State Architecture Focus Areas • Definition of your DBaaS future state architecture requires a comprehensive view of your service including: • People • Process • Technology

16. Developing a DBaaS Roadmap

17. DBaaS Strategic Roadmap Example Phase 2 Phase 3 Phase 1 Reduction in IT Delivery Time through Standardized Software and Infrastructure Reduction in IT Delivery Time through Pre-Deployed and Configured Platform Reduction in IT Delivery Time through DBaaS BusinessStrategy • Database Service Portfolio • Database Service Delivery • Business Service Portfolio • Consolidated Database Platform • Consolidation of Database Resources and Management • Resource Based Charge-Back / Utilization Accounting • Standardized Database Platform • Standardized Database • Increased Database Capacity • Established Platform for Consolidation TechnologyStrategy Skills – Customized Exadata Training Skills - DBaaS Service Management Resource Planning and Balancing Skills – Service Delivery and Tracking Operational Changes Process – Service Development Process and DB Service Design Process – Provisioning, Chargeback, and Accounting Process – Consulting to Develop Packages and Development Factory, Utilization Reporting – for budgeting history • Incremental Infrastructure Build-out • Increased Resource Utilization • Foundation for DBaaS • Added Capacity for Business Initiatives • Scalable / Demand based Infrastructure Investment • Limited Scope / Repeatable Service Management Model • DBaaS Rapid Provisioning – reduce time by 300% • Shared / Automated Resource Management and Delivery Outcome

18. Chargeback and Cost Recovery Overview

19. High Level Chargeback Strategies Evolve the complexity of your model with your overall DBaaS roadmap

20. DBaaS Governance Considerations • Use ITIL to identify key gaps in DBaaS readiness and governance. • Use RACI to determine who needs to be: • Responsible • Accountable • Consulted • Informed • in managing the service.

21. Architecting DBaaS • Organization’s Service Strategy • Target Consumer Community • Service Business Requirements • Financial Strategy, Chargeback Models, Rate Structure • Engaging Departments/Customers Summary Business • Application • Workload characteristics • Standards, • Access • Information • Integration • Security • Infrastructure • Deployment Models • Capacity • Availability • Security and Audit Operation • Resource Allocation/Organizational Structure • Service Development Framework • Service Management Framework • Workflow & Repository (i.e. Consumer accounts) Technology

22. DBaaS Architecture Development Process Governance Roadmap Future State Current State Business Context Architecture Vision Focus Areas Deliverables

23. How Can You Learn More? • Navigate the Cloud with Oracle • Inquire about Oracle’s IT Strategy with your Oracle account team • Visit www.oracle.com/goto/EA for more thought leadership on Cloud Computing and DBaaS