Download as PDF, PPTX
Uploaded byEDB
Optimizing Open Source for Greater Database Savings and Control
The document outlines the strategic benefits of using PostgreSQL alongside proprietary solutions to optimize enterprise data management while significantly reducing costs. It highlights the advancements in PostgreSQL, its enterprise-class features, and the successful case studies of organizations transitioning from Oracle to PostgreSQL. Additionally, it emphasizes the importance of leveraging existing skills in database administration for increased productivity and efficiency.
Optimizing Open Source for Greater Database Savings and Control
- 1. Optimizing with OpenSource Sean Doherty, SVP Sales & Business Development © 2014 EnterpriseDB Corporation. All rights reserved. 1
- 2. Webcast Objectives • Evolutionof today’s new enterprise data infrastructure model • Do more with less − Use open source and proprietary solutions together, strategically • Workloads best suited for introducing Postgres into your environment − Key advances in recent Postgres releases that support new data types and evolving data challenges • Success milestones for evaluating the ‘when and how’ of expanding Postgres deployments • How to get started © 2014 EnterpriseDB Corporation. All rights reserved. 2
- 3. The Need Fora Better Way © 2013 EDB All rights reserved 8.1. 3
- 4. Strategic IT BudgetProblem UP TO 35 % of software budgets are spent on Database Management Systems: EDB reduces your DBMS costs by 80% or more enabling you to invest in emerging technologies DBMS Maintenance and Fees BIG DATA 4 © 2014 EnterpriseDB Corporation. All rights reserved. 4 CLOUD COMPUTING
- 5. It’s More ThanJust Cost Savings • Lower Cost − Total Cost of Acquisition and Ownership • Ease of Use − Set up and managing • Flexibility − Integration − No lock-in • Community and Technology Roadmap − Product evolution and organization • Enterprise-class Support and Services − Who’s going to help you? © 2014 EnterpriseDB Corporation. All rights reserved. 5
- 6. Optimizing with OpenSource © 2013 EDB All rights reserved 8.1. 6
- 7. Open Source UseEvolving Largest Savings Potential Savings Many companies have adopted OSS for other layers of their software stacks. The rewards for database are even greater. TODAY OPERATING SYSTEM MIDDLEWARE Time © 2014 EnterpriseDB Corporation. All rights reserved. 7 DATABASE
- 8. Postgres’ Growth DB-Engines Ranking,December 2013 We congratulate MongoDB, PostgreSQL and Cassandra for their extraordinary achievements in 2013….The fact that we have three open source tools and two NoSQL systems amongst the winners may be an indication of what 2014 has in store for us. © 2014 EnterpriseDB Corporation. All rights reserved. 8
- 9. Postgres: A ProvenTrack Record • Most mature open source DBMS technology • Enterprise-class features (built like Oracle, DB2, SQL Server) • Strong, independent community driving rapid innovation Fully ACID Compliant MVCC Point in Time Recovery (PITR) Data and Index Partitioning Bitmap Indexes ANSI Constraints Triggers & Stored Functions Views & Data Types Nested Transactions Online Backup Online Reorganization Foreign Keys Streaming Replication Multi-Core Support JSON support 9 © 2014 EnterpriseDB Corporation. All rights reserved. 9
- 10. Postgres Plus: ASuper-Set of Features Synchronized with and contributing to the PostgreSQL community © 2014 EnterpriseDB Corporation. All rights reserved. 10
- 11. Case Study: StaggeringCost Savings Oracle vs. Postgres Plus Advanced Server Fantastic ROI when you move to Postgres • $1,706,673 of 3-year cumulative benefits by moving to EnterpriseDB PPAS on HP Integrity BL890c server blades • Return on investment of 271% • Internal rate of return of 101% • Payback period of 12 months Source: TCO/ROI Analysis with ROI Analyst from Alinean, Inc. © 2013 EDB All rights reserved 8.1. 11
- 12. Survey: Reuse OracleDBA Skills 71% of surveyed organizations using Postgres Plus Advanced Server identified the ability to use existing Oracle DBA skills as having the greatest impact on the productivity of their DBA team. Source: TechValidate Survey © 2014 EnterpriseDB Corporation. All rights reserved. 12
- 13. POSTGRES PLUS CLOUD DATABASE Enterprise Control &Portability EASY • Easy, fast start-up in minutes • Self-healing clusters • Elastic storage • Automatic failover Adds disk space when needed • Elastic scale out • Scheduled backups • Easy to use monitoring Adds clusters automatically based on usage levels MAXIMUM CONTROL • Private instances Not shared • Set your own scale-out and backup parameters • Access to set your own tuning configurations PORTABILITY • Run PostgreSQL or Postgres Plus • Same DB in Cloud as in Data Center - Portability between environments • AWS, OpenStack, CloudStack or bare metal environments © 2014 EnterpriseDB Corporation. All rights reserved. 13
- 14. Implementation Process © 2013EDB All rights reserved 8.1. 14
- 15. Postgres Plus DeploymentStrategies Strategy Benefits Develop/Deploy New LOB Applications • Significant cost savings for non mission critical systems • Leverages all existing Oracle skills • Very low risk Deploy Postgres Plus as Oracle Replication Server • Significant cost savings • Leverages Postgres Plus Replication Server • Leverages all existing Oracle skills • Improves transaction and query performance Migrate/Rewrite non Mission Critical Oracle Apps to Postgres Plus • Significant cost savings • Leverages all existing Oracle skills • Very low risk Migrate/Rewrite Mission Critical Oracle Apps to Postgres Plus • Biggest cost savings • Leverages all existing Oracle skills • Greatest deployment flexibility © 2009 EnterpriseDB Corporation © 2014 EnterpriseDB Corporation. All rights reserved. 15
- 16. Postgres Fit Matrix(New and Existing) Single Department Mission Critical 99.99%+ availability; geographic failover <1 TB; < 100 concurrent users Multi-Department/Enterprise Standard Mission Critical Standard 99%+ availability 99.99%+ availability; geographic failover > 1 TB; highly integrated; > 1000 concurrent users 99%+ availability OLTP Web Apps ODS Archiving Reporting DWH Data Mart COTS Best Fit © 2014 EnterpriseDB Corporation. All rights reserved. Good Fit Emerging 16
- 17. How To ContainCosts License Creep: • Expansion of existing applications • New applications Hardware Upgrades EXISTING apps Y1 Y2 Y3 # Licenses NEW apps • Hardware upgrades Y4 Complementary Coexistence: Reduced Cost & Increased Control: • NEW apps on Postgres • Avoid additional license costs • Move easy-to-migrate existing apps • Reduce dependencies on vendors • Reassign other licenses to support HW upgrades and core apps • Improve negotiating leverage © 2014 EnterpriseDB Corporation. All rights reserved. • Lower costs over time 17
- 18. Applications Built onPostgres © 2014 EnterpriseDB Corporation. All rights reserved. 18
- 19. Evolution and Growthof Postgres • Object Relational Database features from the 90’s • XML storage capabilities at the turn of the century • NoSQL & Non-standard SQL features: − − − − − JSON Nondurable storage Hstore PLV8 Full Text Indexing • Foreign Data Wrappers • PPAS Connector for Hadoop • Oracle database compatibility © 2014 EnterpriseDB Corporation. All rights reserved. 19
- 20. Market Forces InfluenceDirection New Workloads/Platforms (Big Data & Cloud) High-end Enterprise Requirements Easy to Use/Deploy PostgreSQL is growing from the “middle out” © 2014 EnterpriseDB Corporation. All rights reserved. 20
- 21. Postgres’ Future New Workloads/Platforms (BigData & Cloud) • Liasons with other communities • FDW for common no-SQL DBs • Continues to evolve new data types: JSON, XML, Hstore High-end Enterprise Requirements Easy to use/Deploy • • • • • • • • • • • • Diagnosing Problems Configuring for success Still easier installs Tighter integration with frameworks Integration with other data stores Very simple in the cloud © 2014 EnterpriseDB Corporation. All rights reserved. 21 Vertical Scale (parallel query) Horizontal Scale Performance Diagnostics Incremental Backup Integration with other data stores Zero down time upgrades
- 22. Future Data &The Edge Cases Volume Amount of data Variety Velocity Types of data Transac/ons + Users Postgres Meets Your New Data Challenges © 2014 EnterpriseDB Corporation. All rights reserved. 22
- 23. EDB Enterprise Enablement Plan • Existing: • Migration Assessment testing • Prioritization, scheduling, execution Checkpoint • Postgres & EDB capabilities Resource Commitment Learn • Best practices • Business case parameters • New: • ROI Validation • Performance design Discover • Inventory all DB’s • ID license options & cost savings potential Develop Agile Enablement • Architectural assistance • Infrastructure DBA services • Group apps into logical & manageable sets • Create multi-year transformational road map • Assess in-house skill levels • Assemble crossfunctional teams Operate • Ongoing support • Remote DBA • Training & certification • Cloud DBMS • Developer subscriptions • Migration Factory assistance • EDB professional services • Agile enablement cycles are repeated with manageable groups of applications and databases • Business metrics are continuously measured and priorities reassessed © 2014 EnterpriseDB Corporation. All rights reserved. 23
- 24. Assessing Ease ofMigration Oracle 1. Analyze Oracle schema layout for supported features in PPAS 2. Review features used in Oracle client application Difficult 3. Supported features and recommended fixes 4. Overall composite score and migration plan with workarounds and time estimates 24 © 2014 EnterpriseDB Corporation. All rights reserved. Easy 24
- 25. Survey: Ease ofMigration Organizations that migrated Oracle-based applications to Postgres Plus Advanced Server stated the degree to which they had to modify these applications. Source: TechValidate 51% had slight to no modifications © 2014 EnterpriseDB Corporation. All rights reserved. 25
- 26. New Gartner ODBMSMagic Quadrant Gartner Comments: • Community leadership — EnterpriseDB is the primary contributor to the PostgreSQL community and is responsible for many new features of PostgreSQL, including JSON. • Functionality — The functionality of EnterpriseDB's Postgres Plus has increased greatly, and with the Oracle Compatibility Feature is now more than sufficient to run both mission-critical and non-mission-critical applications. • Stability and compatibility — References specifically call out compatibility with Oracle, the stability of the DBMS and product support as strengths. © 2014 EnterpriseDB Corporation. All rights reserved. 26
- 27. Product road-map Enterprise-class features & tools Services &training 24/7 support Control Get The Best Of Both Worlds Indemnification POSTGRES ENTERPRISE innovation reliability Low cost Advanced features No vendor lock-in © 2014 EnterpriseDB Corporation. All rights reserved. Fast development cycles 27 Thousands of developers
- 28. EDB Serves All YourPostgres Needs PostgreSQL Management REMOTE DBA © 2014 EnterpriseDB Corporation. All rights reserved. Postgres Plus Advanced Server Security Postgres Plus Cloud Database High Availability 24x7 SUPPORT Performance PROFESSIONAL SERVICES 28 TRAINING
- 29. POSTGRES PLUS ADVANCEDSERVER Bundled Tools Security • Oracle, SQL Server & PostgreSQL to Postgres Plus replication • Enterprise management, monitoring and tuning • Oracle, SQL Server & MySQL to Postgres Plus Migration Tools • Fine Grained Audit Logging • Row Level Security (VPD) • SQL Injection attack guard • Server-side code protection • EAL2 certification Performance Oracle Compatibility • Faster Partitioning - 400x faster writes - 76x faster selects • SQL Profiler – fix slow workloads • Bulk Data Loader - 2x faster • Index Advisor - speeds up inquiries • Query Hints - optimizer control • DynaTune - memory upgrades • Bulk Collect/Fetch/Binding of arrays • Dynamic runtime statistics reveals SQL wait bottlenecks © 2014 EnterpriseDB Corporation. All rights reserved. • Faster, easier migrations • PL/SQL, OCI support • Oracle SQL extensions • User defined objects • Function packages • Database links • Oracle-like tools: EDB*Loader, EDB*Plus, EDB*Wrap 29 29
- 30. Discussion • Capabilities alignedto needs • Next steps © 2014 EnterpriseDB Corporation. All rights reserved. 30
- 31. © 2014 EnterpriseDBCorporation. All rights reserved. 31