Presentation Transcript

1. Keynote : Database as a Service Ratan SanjayDirector, Enterprise Management & Cloud Solutions , APAC
2. Traditional Database Service Deployments Dedicated Databases Cause Server and Software Sprawl Was the only practical way to ensure good QoS Performance, scalability and reliability Caused high costs for Hardware, software and labor Multiple servers, databases, and OS’s to maintain Backup, patch, upgrade, monitor, optimize Complex provisioning of dedicated services Slow to deploy new solutions Engineering Sales Manufacturing Marketing Service Finance Human Resources IT/Operations
3. Business Challenges For IT Leaders Deliver Database Services Faster, Cheaper and with Lower Risk Agility  Cost  Risk  10X Faster Deployments 50% Lower Total Cost of Ownership 100% Service Level Achievment
4. Database as a Service Goals Agility  Cost  Risk  Self-Service Shared Resources Higher Availability Service Catalog Metering Tighter Security Elasticity Automation Greater Control
5. Evolution to Database as a Service Siloes Standardized Consolidated Service Delivery Enterprise Cloud Complex Simple Unified Efficient Agile
6. Characteristics of Database as a Service Self-Service Provisioning Faster time to value and greater agility Resource Pooling Increased utilization and lower costs Standard Configurations Increased productivity and lower risks Metered Usage Greater transparency and predictability Best Practices Higher service levels and better support Elasticity Rapid response to change in demand
7. Database Service Definitions A formal statement of service capabilities, policies, and procedures
8. Database Service Catalog Design Process Bronze Silver Gold Small Large RAC Data Guard Backups Medium X-Large PDB Database Schema Private Public Provider Hybrid
9. Database as a Service Catalog Example RAC, Data Guard GOLD RAC SILVER Backups BRONZE XL ✔ L M M S ✔
10. Measuring Success for Database as a Service Cost Risk Agility Measurement Metrics Denser hardware utilization Resolve end-of-life issues Reduce provisioning time Operational Savings Capital Savings Time to Provision % Compliant % Utilization SLA Attainment Simplify administration Achieve compliance Faster scale-out Consumption based billing Consolidate security controls Management automation Standardization Improved quality of service More focus on capability
11. Database as a Service PlanningCurrent state analysis before consolidation
12. Database as a Service Choices of Approach Shared Database Virtual Machines Dedicated Databases Consolidation Density Share Servers & OS Share Servers, OS & Database Share Servers
13. Achieve Database as a Service Today With a Two-Prong approach New Project New Project Stand up DBaaS platform today to show immediate value for new projects 1 DBaaS In parallel, consolidate/optimize with long term goal to move to strategic DBaaS 2 Siloed Standardized Hybrid DBaaS Consolidated Private DBaaS
14. Exadata Improves Consolidation Performance Unique technology for accelerating all database workloads Smart Flash Cache Uses flash for physical I/O Smart Flash Log Uses flash to improve log I/O latency Smart Scan Runs portions of a database query in storage Hybrid Columnar Compression (HCC) Reduces the number of blocks and I/Os
15. Exadata Improves Consolidation DensityOracle Exadata supports more databases per machine
16. Prioritizing Consolidated Mixed Workloads Oracle Exadata enables safe consolidation of diverse workloads Database Resource Manager CPU resource management for conventional and pluggable databases Exadata I/O Resource Management By tenant pluggable database, job, SQL, user, service, etc. Exadata Network Resource Management Prioritizes critical messages through the entire fabric e.g. Web users prioritized over ad-hoc reporting
17. Oracle Database as a Service Applications Management Platform as a Service Security Cloud Management Database Vault Oracle Database 12c Oracle Multitenant Oracle Database 11g Diagnostics and Tuning Advanced Security Exadata Database Machine SPARCSuper Cluster Active Data Guard Real Application Clusters Real Application Testing Audit Vault and Database Firewall
18. Multitenant Improves Consolidation Density6x Less H/W Resource, 5x more Scalable than dedicated databases OLTP benchmark comparison Only 3GB of memory vs. 20GB memory used for 50 databases Pluggable databases scaled to over 250 while separate database instances maxed at 50
19. Advantages of Multitenant Architecture Easy to adopt, reduce costs, increased agility Rapid provisioning and portability Greater database consolidation density Container Database Manage many databases as one
20. Multitenant Provides Agility for New ProjectsFast Provisioning, Snapshot Clones
21. Managing Database as a Service With Oracle Enterprise Manager
22. Case Studies
23. Case Study Database as a Service India’s second largest Private Bank with nearly 2800 branches, 11,000 ATMs 20 million customers Employees: 56,000 Revenue: USD 5 Billion FOCUS ON Consolidation, Self-Service Provisioning, Lifecycle Management Challenge: Database sprawl over 168 racks of real estate Hitting performance ceiling on existing infrastructure Rollout of new database services often wait on infrastructure; taking and average time of 3 days Solution: Run new database applications on Exadata while legacy applications run on IBM AIX EM 12c based Self-Service Provisioning of databases EM 12c Lifecycle Management features for Discovery, Compliance, Patching, etc Reduced new database rollout time from 3 days to 3.5 hours Standardized database offering for Developers and QA reducing any significant configuration drift and compliance challenges BENEFITS
24. Case Study DATABASE DEPLOYMENT £20.076 Billion in Revenue 93,000 Employees in 170 Countries5,000 Databases FOCUS ONDatabase-as-a-Service Challenge: Growing application sprawl Application deployment was slow, complex and expensive Database infrastructure was “rapidly falling into legacy“ GOAL: Make BT #1 for customer service and cost reduction After Oracle Enterprise Manager: Consolidated databases onto private DBaaS Cloud IT team now manages 30% more databases with 20% fewer personnel hours No more wasted time: harmonized management tools, processes, and methodology Reduced server sprawl, increase operational efficiencies by deploying databases faster
25. Oracle Database as a Service Everybody wins… Users Get: Better performance & service Self-service provisioning Pay per use IT Gets: Standardized deployments Less maintenance Simplified support
26. Oracle Database as a Service Oracle Enterprise Manager, Oracle Multitenant and Oracle Exadata Container Database