Download as PDF, PPTX
Uploaded byMarkus Michalewicz
Why Use an Oracle Database?
The document outlines the advantages of using an Oracle database, emphasizing its flexible standards, high availability, and cost-effectiveness. Key features include support for SQL, multitenant architecture, and automated scalability for varying workloads. It also highlights the integration of advanced technology such as machine learning and cloud services, positioning Oracle as a leader in the database market.
Why Use an Oracle Database?
- 1. Why Use anOracle Database? The 2020 “C-Edition”: Change, Converge, Consolidate & Cloud Markus Michalewicz Senior Director of Product Management Oracle Database High Availability | Scalability | MAA July 15, 2020 @KnownAsMarkus www.linkedin.com/in/markusmichalewicz www.slideshare.net/MarkusMichalewicz
- 2. Safe harbor statement Thefollowing 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, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation. 2 Copyright © 2020, Oracle and/or its affiliates
- 3. The Top 5Reasons to Use an Oracle Database 1 Flexible Standards 2 Scale-on-Demand 3 Highest Availability 4 Cost & Consolidation 5 Secure Future 3 Copyright © 2020, Oracle and/or its affiliates
- 4. The Top 5Reasons to Use an Oracle Database 1 Flexible Standards 2 Scale-on-Demand 3 Highest Availability 4 Cost & Consolidation 5 Secure Future 4 Copyright © 2020, Oracle and/or its affiliates
- 5. Flexible Based onStrong Fundamentals Structured Query Language (SQL) Oracle supports ANSI standard SQL Has extensions to the SQL language for features that are not included in ANSI standard. Multiversion Read Consistency The data returned by a query is committed and consistent for a single point in time. Nonblocking queries Readers and writers of data do not block one another. Non-escalating row level locking Transactions Supporting transactions means the database ensures A.C.I.D. A.C.I.D. à Atomicity, Consistency, Independence, Durability Programmable database features • Stored Procedures & Triggers • Oracle PL/SQL 5 Copyright © 2020, Oracle and/or its affiliates
- 6. Gartner’s Critical CapabilitiesOracle Database* High Availability 5.0 Security 4.5 High-Speed, High-Volume Processing 4.5 Cloud/Hybrid Deployment 4.5 Administration and Management 4.5 Consistency 4.0 Multiple Data Types/Structures 4.0 Automated Data Distribution 4.0 Programmability for HTAP 4.0 Continuous High-Speed Ingest 3.5 Oracle Database – Highest Ranked Industry Standard 6 Same database, same skills * ranked highest multiple years in a row / 2019 Copyright © 2020, Oracle and/or its affiliates
- 7. Oracle Database (Personal Edition) ExpressEdition “Capacity limited EE Test & Development Edition” Oracle Database Standard Edition “Sound Single Instance for SMEs & workgroups” Oracle Database Enterprise Edition “All Inclusive + Options” Export / Import Upgrade Copyright © 2020, Oracle and/or its affiliates7 Flexible Standards Oracle grows with Business Demands Enterprise Edition
- 8. Oracle Grows withBusiness Demands Simplified industry growth / startup lifecycle 8 Copyright © 2020, Oracle and/or its affiliates Idea / Startup Growth Expansion / Mature time sales/growth Enterprise Edition
- 9. Oracle Grows withBusiness Demands Providing a choice of integrated platforms 9 Copyright © 2020, Oracle and/or its affiliates Idea / Startup Growth Expansion / Mature time sales/growth ORACLE AUTONOMOUS DATABASE Enterprise Edition
- 10. Oracle Database –Choice of Deployment Most Manual Most Autonomous DB installed on commodity HW on premises DB installed on Oracle Exadata on premises DB on Oracle Cloud Infrastructure Oracle Autonomous Database Database Cloud Service Exadata Cloud Service (or C@C) Same database, same skills 10
- 11. • Oracle Multitenantmeans self-contained, Pluggable Databases (PDBs) providing - Rapid deployment with Hot Clone - Refresh / incremental refresh - Relocation with no downtime - PDB upgrades (using plug / unplug) • PDBs enable transparent, simplified online lifecycle operations for any application • PDBs speed up database migration to new container databases (in the cloud) Oracle Multitenant – The New Standard Architecture for database consolidation & optimized lifecycle operations 11 Pricing Retail CRM Copyright © 2020, Oracle and/or its affiliates
- 12. Converged Database Use casesare converging 12 Copyright © 2020, Oracle and/or its affiliates Phone calls, messaging, photos, etc. originally required separate products • Now they are features of Smartphones Similarly, ML, JSON, Blockchain, etc. originally required separate databases • Now they are features of a Converged Database
- 13. Use Cases areConverging for Good Reasons Developers innovate faster with converged It is dramatically simpler for developers to invoke extended SQL to execute ML, graph, spatial, blockchain, IoT, etc. in one converged database Instead of implementing distributed execution and data movement across multiple fragmented databases 13 Copyright © 2020, Oracle and/or its affiliates EVENT RPC ETL REPLICATION DB LINKS EVENT RPC ETL REPLICATION DB LINKS EVENT RPC ETL REPLICATION DB LINKS EVENT RPC ETL REPLICATION DB LINKS GraphMLDoc Spatial Reporting
- 14. Single-Purpose Databases Spreadwith Business Demands Contrasting Database Architecture Strategies 14 Copyright © 2020, Oracle and/or its affiliates Run Single-Purpose Proprietary database for each data type and workload Oracle StrategyAmazon and Niche DB Vendors Run Converged, Open, Oracle database for multiple data types and workloads Amazon Aurora Amazon DocumentDB Amazon DynamoDB Amazon Neptune Amazon Quantum Ledger Database Amazon RedShift Amazon Timestream Amazon ElastiCache
- 15. The Top 5Reasons to Use an Oracle Database 1 Flexible Standards 2 Scale-on-Demand 3 Highest Availability 4 Cost & Consolidation 5 Secure Future 15 Copyright © 2020, Oracle and/or its affiliates
- 16. Oracle Real Application Cluster(RAC) transparent, near-linear horizontal scaling Scale-on-Demand with Oracle – Always the Right Size Copyright © 2020, Oracle and/or its affiliates16 Single Instance Oracle Database online vertical scaling (Single Instance) Database with Oracle Sharding linear horizontal scaling for sharding-aware applications
- 17. Copyright © 2020,Oracle and/or its affiliates Linear Scalability Add shards online to increase database size and throughput. Online split and rebalance. Extreme Availability Shared-nothing hardware architecture. Fault of one shard has no impact on others. Geographic Distribution User defined data placement for performance, availability, DR or to meet regulatory requirements. … … … … Some large scale applications want to shard data across independent databases and are willing to modify the application to do so and for getting the benefits listed above. Oracle Sharding for a New Generation of Applications 17
- 18. Automated Deployment Automated Replication System-Managed& Composite Sharding Schema Management Direct & Proxy Routing Online Scale-out/in Automated Resharding Data Movement 12.2 18c 19c 20c User-Defined Sharding PDB Sharding RAC Sharding Mid-tier Sharding Update-able Duplicated Tables Multiple PDB shards per CDB Multiple Table Families Scalable Coordinator High Speed Data Ingest Terraform Support Federated Shards Multi Shard DML Automatic Identification of Sharding Key Sharding Advisor Terraform Support Oracle Sharding Evolution Copyright © 2020, Oracle and/or its affiliates18
- 19. New Generation OracleRAC 19c 19 Copyright © 2020, Oracle and/or its affiliates Ease of use established with Oracle RAC 12.2 Best ever scalability & performance in Oracle RAC 18c + Best ever High Availability in Oracle 19c + 24 7
- 20. “If you havenot looked into the New Generation Oracle RAC 19c yet, you have not experienced what Oracle RAC can do for you.” https://www.oracle.com/technetwork/database/options/clu stering/overview/new-generation-oracle-rac-5975370.pdf https://www.slideshare.net/AnilNair27/oracle-rac-new-generation 20 Copyright © 2020, Oracle and/or its affiliates ORACLE AUTONOMOUS DATABASE
- 21. The Top 5Reasons to Use an Oracle Database 1 Flexible Standards 2 Scale-on-Demand 3 Highest Availability 4 Cost & Consolidation 5 Secure Future 21 Copyright © 2020, Oracle and/or its affiliates
- 22. Highest Availability The standardfor Oracle Database 22 Copyright © 2020, Oracle and/or its affiliates Oracle Multitenant / Pluggable Databases Converged Single Instance Database Oracle Sharding / Oracle RAC Oracle (Active) Data Guard https://www.slideshare.net/MarkusMichalewicz/best-practices-for-the-most-impactful-oracle-database-18c-and-19c-features
- 23. Application Continuity Protect yourapplications from any interruption Application outage protection • For planned & unplanned outages • System outage protection alone does not ensure applications are uninterrupted • Application Continuity continues reads and replays in-flight database requests • 100% transparent to the users and applications – fully automatic • Unique to Oracle! • Available with Oracle RAC and Active Data Guard 23 Copyright © 2020, Oracle and/or its affiliates
- 24. Application Continuity Choose theright flavor for your application 24 Copyright © 2020, Oracle and/or its affiliates Transparent Application Continuity works without Oracle pools, some decisions are made for you Application Continuity uses Oracle pools, customizable
- 25. Application Continuity (AC)& Transparent Application Continuity (TAC) Broadening coverage with every release 12.1 – AC Introduced • JDBC-thin • Oracle pools 12.2 – AC Improved • OCI • ODP.NET 18c/19c – Transparent AC • Non-pooled apps • Default in ADB • Full session state restore 20c – Better Failover • Reset session state • Planned failover 25 Copyright © 2020, Oracle and/or its affiliates • Universal Connection Pool (UCP) • Weblogic Server w/ AGL • ODP.NET unmanaged • OCI Session Pool • IBM WebSphere & Liberty • Apache Tomcat • NEC WebOTX • Red Hat WildFly (JBoss) • Spring • Hibernate For more information see: http://oracle.com/goto/ac
- 26. Oracle Maximum AvailabilityArchitecture (MAA) Copyright © 2020, Oracle and/or its affiliates Reference Architectures Deployment Choices HA Features, Configurations & Operational Practices Customer Insights & Expert Recommendations Production Site Replicated Site Platinum Gold Silver Bronze Replication Data Protection Flashback RMAN + ZDLRA Continuous Availability Application Continuity Global Data Services Generic Systems Engineered Systems DBCS ExaCS/ExaCC Autonomous DB Active Replication Active Data Guard GoldenGate 24 Scale Out RAC ShardingASM 26
- 27. The Top 5Reasons to Use an Oracle Database 1 Flexible Standards 2 Scale-on-Demand 3 Highest Availability 4 Cost & Consolidation 5 Secure Future 27 Copyright © 2020, Oracle and/or its affiliates
- 28. Consolidation Use Multitenant-based consolidationfor cost optimization 28 Copyright © 2020, Oracle and/or its affiliates Increase Functionality Massive Cost Savings and Cloud Agility with Multitenant DecreaseCosts
- 29. 9 PDBs inone CDB Flexible & Cost-Effective Consolidation with Oracle Multitenant Copyright © 2020, Oracle and/or its affiliates29 3 PDBs free of charge per Oracle Database 3 Container Databases (CDB) with 3 PDBs each on 1 server
- 30. 9 PDBs inone CDB Flexible & Cost-Effective Consolidation with Oracle Multitenant Copyright © 2020, Oracle and/or its affiliates30 3 PDBs free of charge per Oracle Database 3 Container Databases (CDB) with 3 PDBs each on 1 server time sales/growth
- 31. General Licensing Models– Oracle Database Supports 2/3 “Classic License” Upfront CAP (once) + Support (continuous) “Subscription” No upfront CAP + Subscription (Support / Usage) “Open Source” No / little upfront CAP + Support (continuous) 31 Often forgotten – implementation / maintenance costs Copyright © 2020, Oracle and/or its affiliates
- 32. Benefit from CloudSizing All workloads exhibit variation – “normal” to “peak” • Annual/quarterly/weekly/daily seasonal variations • Retail/other seasonal transactions, periodic reports and compliance, full backups • But also intraday variation • End-of-day reports, analytics workloads, day/night (e.g., lower daytime workload on sparsely populated landmasses/Pacific Ocean), incremental backups • On-premises common to see “peak” sized “2x normal” • If 16 cores are “normal”, the system may get sized with 32 cores On cloud, it is safe to provision for normal workloads and burst up as needed 32 Copyright © 2020, Oracle and/or its affiliates
- 33. Production Workload Sizing On-premises,size for the peak, plus additional buffer = lots of idle CPU 33 + BufferPeak CPU Usage Normal + Hourly Bursting CPU Usage Peak Buffer On the cloud, size for the normal workload, & use hourly bursting for the peak = no need to add buffer Copyright © 2020, Oracle and/or its affiliates
- 34. Disaster Recovery (DR)and Test & Dev (Dev/Test) Sizing Add OCPUs (expansion / burst) for Hybrid DR 34 Copyright © 2020, Oracle and/or its affiliates CPU Usage Adjust OCPUs for performance testing Oversubscribe using Oracle Multitenant Size for development CPU Usage Same database, same skills log transfer DR
- 35. The Top 5Reasons to Use an Oracle Database 1 Flexible Standards 2 Scale-on-Demand 3 Highest Availability 4 Cost & Consolidation 5 Secure Future 35 Copyright © 2020, Oracle and/or its affiliates
- 36. Oracle Database TraditionallyProvides Strong Security • Core Database Security (users, roles, authentication, etc.) • Encryption of Network Communication • Transparent Data Encryption (TDE) • Column-level Encryption • Oracle Key & Database Vault • Database Auditing • Oracle Audit Vault • Oracle Database Firewall • Label Security • Real Application Security • Virtual Private Database (VPD) • Data Masking and Subsetting 36 Copyright © 2020, Oracle and/or its affiliates
- 37. Mission Critical Security FullArchitecture to Achieve Data Security – Maximum Security Architecture Data Encryption à Advanced Security Prevent Admin Data Access à Database Vault Key Management à Key Vault Centralized Auditing à Audit Vault Testing Security à Data Masking and Subsetting Centralized Security à Data Safe Copyright © 2020, Oracle and/or its affiliates37
- 38. Complete and IntegratedAnalytics Warehouse Data-Driven Outcomes Made Easy – securing your future 38 Copyright © 2020, Oracle and/or its affiliates Power Innovation Boost Efficiency Reduce Risk Any Data Any Format Deep Oracle Apps & Database Integration Files Object Stores Oracle Data Cloud Logs Webclicks Oracle On-Prem Apps Fusion SaaS, NetSuite, SAP, Salesforce, Workday Media Events Streams Data Monetization Dashboards & Reports Machine Learning Models Oracle Apps Data Warehouse AI Enabled Devices Augmented Analytics Data-Driven Apps Flexible Compute Flexible Storage Azure Interconnect On-Prem FastConnect Refine & Integrate Persist & Process Analyze & Predict • Disruption-free modernization to Autonomous • Limitless predictions • Self-service with governance • Enterprise-grade with compelling price Analytics Data Engineering Data Science Analytic Apps Data Lake Data Warehouse Data Mart Oracle Database SQL Server, Azure SQL, … AWS Aurora, RDS, …
- 39. For DBAs ConvergedDatabase means a “transferable technical skill” Example - https://go.oracle.com/DBA 39 Copyright © 2020, Oracle and/or its affiliates https://www.slideshare.net/MarkusMichalewicz/changing-role-of-the-dba-skills-to-have-to-obtain- and-to-nurture-updated-2020-edition Join us and gain an attainable, logical, evolutionary path to add machine learning to your valuable Oracle data skills. Attend this virtual session to start your journey to machine learning. Follow a week- by-week framework so you can learn how to extract more information, insights, and make predictions
- 40. Oracle APEX: Data-DrivenLow-Code Apps Data-driven Application Development made easy with Oracle Database • Oracle APEX Low-Code IDE automatically creates an App starting from a spreadsheet or a table • Data-driven Development that is usable by dev professionals, or tech-savvy business users • Deep integration with database eliminates the complexity of Middle-tiers, connection management, state management, mapping database types to app types, scaling, and HA • Create an App in hours – fastest time-to-value • Easily iterate the App to match evolving business needs Copyright © 2020, Oracle and/or its affiliates40
- 41. “Oracle Makes Modern Development Easier,Faster, More Effective” 41 Copyright © 2020, Oracle and/or its affiliates CI/CD – Online Redefine Microservices - Pluggable Events - Queues Q SaaS - Multitenant Distributed Data - Sharding API Driven - DaaM API Defense in Depth – Declarative Security Low Code - APEX For an overview of all contributing features see: http://oracle.com/goto/database
- 42. World’s Best Database– Oracle Fastest Innovation – Best and Converged OLTP, DW, ML, Graph, IOT, JSON, etc. Safest – Most Scalable, Available, Secure (RAC, ADG, In-Mem, MT) World’s Best DB Platform – Exadata Best for OLTP – Scale-Out, RDMA, Persistent Mem, Flash, Fault-Tolerant Best for Analytics – Smart Storage, In-Memory Columnar World’s Best DB Cloud – Autonomous Database Simplest, Lowest Cost – Admin-free, Low-code, Serverless, Pay-per-Use, BYOL Fastest Transformation – Easy Migration of Existing and New Apps, Cloud@Cust Summary – Unique Technology Enables Achieving Goals 42 Copyright © 2020, Oracle and/or its affiliates
- 43. 43 Copyright ©2020, Oracle and/or its affiliates Thank you Markus Michalewicz (Markus.Michalewicz@oracle.com) Senior Director of Database Product Management @KnownAsMarkus www.linkedin.com/in/markusmichalewicz www.slideshare.net/MarkusMichalewicz
- 44. Our mission isto help people see data in new ways, discover insights, unlock endless possibilities.