Save money with Postgres on IBM PowerLinux

Save money with Postgres on IBM PowerLinux

• 1.
  Save money withPostgres on IBM PowerLinux © 2013 EnterpriseDB Corporation. All rights reserved. 1
• 2.
  Postgres is nowthe 4th most popular database (DB-Engines, 2H 2014) © 2013 EnterpriseDB Corporation. All rights reserved. 2 Gartner Magic Quadrant October 2013 • 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.
• 3.
  EDB and IBM:Trusted Partnership • EDB part of Power8 launch • Performance and scalability optimization • Sales teaming on Oracle customers looking to migrate to EDB • IBM’s largest LoP resellers and SIs teaming with EDB • IBM and Red Hat are investors in EDB: 3 way teaming © 2013 EnterpriseDB Corporation. All rights reserved. 3
• 4.
  EDB Postgres Pluson IBM PowerLinux The Price-Performance Choice PowerLinux price-performance EDB performance, scalability & cost EDB 80%+ TCO savings over Oracle Price-performance advantage …enhanced by Power8! © 2013 EnterpriseDB Corporation. All rights reserved. 4
• 5.
  IBM Case Studywith EDB on PowerLinux 7R4 $250,000 $200,000 $150,000 $100,000 $50,000 $0 $27,600 $51,755 $62,874 PowerLinux 7R4 SPARC T5-2 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $134,555 Total 3-yr TCO © 2013 EnterpriseDB Corporation. All rights reserved. 5 $152,000 Total TCA SW TCA HW TCA $0 $315,194 PowerLinux 7R4 SPARC T5-2 EDB Enterprise Edition: $6,900/socket 4 sockets Annual subscription (No discount) Oracle EE: $47,500/core 32 cores 22%/yr SWMA (90% discount) 171% lower total TCA vs. SPARC w/ Oracle 134% lower 3-year TCO vs. SPARC w/ Oracle 451% higher software TCO
• 6.
  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" 6 © 2013 EnterpriseDB Corporation. All rights reserved. 6 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 HStore
• 7.
  POSTGRES innovation Services & training © 2013 EnterpriseDB Corporation. All rights reserved. 7 ENTERPRISE reliability 24/7 support Enterprise-class features & tools Indemnification Product road-map Control Thousands of developers Fast development cycles Low cost No vendor lock-in Advanced features Enabling commercial adoption of Postgres
• 8.
  POSTGRES PLUS ADVANCEDSERVER Security Tools Performance Compatibility © 2013 EnterpriseDB Corporation. All rights reserved. 8
• 9.
  POSTGRES PLUS ADVANCEDSERVER Security • Enhanced Auditing • Row Level Security (VPD) • SQL Injection attack guard • Server-side code protection • Multiple US Gov’t certifications including EAL2 © 2013 EnterpriseDB Corporation. All rights reserved. 9
• 10.
  POSTGRES PLUS ADVANCEDSERVER Bundled Tools • Oracle, SQL Server & PostgreSQL to Postgres Plus replication • Enterprise management, monitoring, and tuning • Multi-master replication • HA failover protection • Oracle, SQL Server & MySQL to Postgres Plus migration • Update monitoring © 2013 EnterpriseDB Corporation. All rights reserved. 10
• 11.
  POSTGRES PLUS ADVANCEDSERVER Performance • 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 © 2013 EnterpriseDB Corporation. All rights reserved. 11
• 12.
  POSTGRES PLUS ADVANCEDSERVER Oracle Compatibility • 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 © 2013 EnterpriseDB Corporation. All rights reserved. 12
• 13.
  Oracle Compatibility Compatiblewith: Your people Your apps Your business Oracle Developers Oracle Applications • Run applications written for Oracle virtually unchanged • No need to retrain Oracle DBAs and developers • Support for PL/SQL language and OCI interoperability • Replication for easy sharing of data 13 © 2013 EnterpriseDB Corporation. All rights reserved. 13 Everything works on PPAS! No disruption to your ongoing operations!
• 14.
  Oracle Migration Assessment 2. Review features used in Oracle client application Difficult Easy 4. Overall composite score and migration plan with workarounds and time estimates 14 Oracle 1. Analyze Oracle schema layout for supported features in PPAS 3. Supported features and recommended fixes © 2013 EnterpriseDB Corporation. All rights reserved. 14 Survey: 51% needed slight to no app changes to migrate
• 15.
  Oracle vs. EDBTCO on IBM PowerLinux reduction 95 % 3 YR TCO © 2013 EnterpriseDB Corporation. All rights reserved. 15 Oracle Enterprise Edition EDB Postgres Plus Enterprise Edisiton License Fee Per Core (4 sockets/32 cores) (Power processor) (4 sockets/32 cores) (Power processor) Database $47,500 included in subscription Partitioning $11,500 Included Data Guard $11,500 Included Diagnostics $5,000 Included Total License Fee per Core $75,500 included in subscription Total License Fee per Server (CapEx) $2,416,000 $0 Annual support/subscription cost per core 22% of License Fee $6,900 per socket Annual Support/Maintenance per Server (OpEx) $531,520 $27,600 Total 3 Year License and Support Cost $4,010,560 $82,800 No CAPEX Annual OPEX cost savings 98 %
• 16.
  Power8 benefits forPostgres Plus & apps • Performance − Postgres Plus performance has been p8 optimized using IBM Advance Toolchain − Apps on Postgres Plus take advantage of P8’s 8 SMT threads per core • Scalability − P8 larger addressable cache sizes enable scaling ever-growing databases sizes • Security − P8 cryptographic capabilities improve app security for regulatory compliance • Big Data workloads − Postgres Plus leverages P8’s massive memory and broader data pathways © 2013 EnterpriseDB Corporation. All rights reserved. 16
• 17.
  Not just traditionalworkloads, but also Big Data with ACID compliance Postgres maximizes value by enabling a wider range of workloads from a relational database: • Postgres’ Object-Relational roots provides flexibility and extensibility for unstructured data types, languages and plug-ins • Handles many NoSQL workloads with support of XML, JSON and HStore (key-value store) data types • Foreign Data Wrappers enable read/write integration with other NoSQL technologies • Non-durable (unlogged) storage capability • Postgres Plus Advance Server connector for Hadoop © 2013 EnterpriseDB Corporation. All rights reserved. 17
• 18.
  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 © 2013 EnterpriseDB Corporation. All rights reserved. 18
• 19.
  Increase ROI &Lower Risk with EDB Effort/Resources LEARN VALIDATE & DEPLOY OPERATE © 2013 EnterpriseDB Corporation. All rights reserved. 19 ROI Time EDB SOLUTIONS CUSTOMER CHALLENGES § Postgres capabilities assessment § EDB products, services and resources § Risk management § In-house skills & resource availability § Project management § Postgres best practices § Operational support § Ongoing skills development § Postgres Evaluation Support Kit § Postgres Kick Start § Postgres Developer Kick Start § Postgres Team Success § Postgres Team Success with RemoteDBA § Product Enterprise Enablement § Postgres Enterprise Enablement with RemoteDBA
• 20.
  EDB on IBMPowerLinux The Price-Performance Choice • 98% TCO reduction vs. Oracle • Robust, mission critical capabilities • Optimized for PowerLinux • Close partnership with IBM • Full array of support & services packages © 2013 EnterpriseDB Corporation. All rights reserved. 20
• 21.
  © 2013 EnterpriseDBCorporation. All rights reserved. 21