Putting Postgres to Work for You

Putting Postgres to
Work for You
•  Migrate to an Open Source based, Enterprise
Class DBMS.
•  Minimal code changes.
•  Same skill sets, Similar tools.
© 2015 EnterpriseDB Corporation. All rights reserved.
1
Keith Alsheimer
CMO
April 2015
Cut your DBMS Spend by 70-80%
Are premiums for database
technology robbing value
from your customers?
How do you measure the ROI
of paying a premium?
© 2015 EnterpriseDB Corporation. All rights reserved.
2
where would
you invest
the savings?
Mobile Enablement Social
Media
Visualization
Consumerization Cloud
Enablement Big Data
Insights Analytics
Are you paying more for database and
getting less out of your applications?
© 2015 EnterpriseDB Corporation. All rights reserved.
3
Investment Strategy for IT Stack Components
Analytics
Mobile
Innovation:
Invest for Brand
Applications
Middleware
Commodity:
Rationalize for Stability
Database
Bloat
Operating
System
Virtual
Machine
© 2015 EnterpriseDB Corporation. All rights reserved.
4
$$$$
Landmark Moments . . .
Can you remember the same reluctance
paying premiums for Solaris (UNIX)?
Notable Quotes: We must run on Solaris.
Nothing beats the reliability of Solaris.
We will lose customers if we move off Solaris.
I could not sleep at night if we moved off Solaris.
We cannot run our business on Open Source UNIX.
We have invested too much in Solaris to move now.
I built my career & this organization on Solaris!
We have done this before, but it takes leadership!
© 2015 EnterpriseDB Corporation. All rights reserved.
5
ODBMS Pricing Comparison
COST PER CORE CALCULATION
(2x4 Server w/ x86 chip)
ORACLE
(50% DISCOUNT)
EDB POSTGRES PLUS
(0% DISCOUNT)
SAVINGS
License Price (8 cores)
$380,000
$0.00
$380,000
Discounted Price
$190,000
$0.00
$190,000
0.5
1
Total License
$95,000
0
100%
Maintenance
$20,900
$13,800
34%
3 Yr TCO
$157,700
$27,600
82%
HW Factor
Annual Savings
per core
© 2015 EnterpriseDB Corporation. All rights reserved.
$16,263
6
Applications by Complexity
Oracle, SAP, MS
Apps
proprietary apps
of Record
20% of all Apps
ISV apps
Custom apps
Applications of Differentiation
60% of all Apps
Applications for Innovation
20% of all Apps
© 2015 EnterpriseDB Corporation. All rights reserved.
7
Web apps
& Mobile
Inventory Apps for conversion
Enterprise Example: 100 Apps
Apps
of Record
20% of all Apps
20 = packaged Oracle,
SAP, Sharepoint, etc.
60 = custom
20 = Web/other
Applications of Differentiation
60% of all Apps
Applications for Innovation
20% of all Apps
Custom application footprint:
−  2 dual socket, quad core servers per app
−  16 cores/app x 60 apps = 960 cores
© 2015 EnterpriseDB Corporation. All rights reserved.
8
Application Migration Process
•  Migration Apps: Middle Tier Inventory
−  60 apps x 16 cores = 960 cores
•  1st Cut: Screen 50% into high readiness tier
960 CORES
1
Pool
2
3
50%
30%
20%
days/app
15 days
20-30 days
40 days
# of apps
30 Apps
# cores
480 cores
288 cores
192 cores
net savings $7.7 Million
$4.5 Million
$2.8 Million
3 yr (Net) ROI
18 Apps
459%
© 2015 EnterpriseDB Corporation. All rights reserved.
375%
9
12 Apps
278%
Conversion ROI: Tier 1 Apps
Parameters Costs
Analysis+&+Planning
4-­‐6 months dev 3 year TCO Migration+&+Remediation
30 Applica;ons 16 physical cores/ App EnterpriseDB
subscription+costs
!""!Assumes!application!templates.
30
3
1800
Apps
Days/!App
$/!Day
!""!Assumes!established!workflow,!3!developers,!1!test,!and!1!manager.
30
12
800
Apps
Days/!App
$/!Person/!Day
30
16
$13,800
3
Apps
Cores/!App
$/!App/!Year
years
480 cores total 5 headcount ~ 15 man days/ App 50% discount on Oracle L&S $162,000
$288,000
Total+Costs
$1,242,000
$1,692,000
Savings
Oracle+License
(50%+discount)
Oracle+Support
30
16
$11,875
!""!
Apps
Cores/!App
$/!Core
years
30
16
$2,613
3
$3,762,000
Apps
Cores/!App
$/!Core
Total+Savings
$9,462,000
(Net)+ROI
459%
(Net)+FCF
$7,770,000
$5,700,000
ROI
(Net)+ROI
(Net)+FCF
© 2015 EnterpriseDB Corporation. All rights reserved.
10
Gartner: Relational OSDBMS Maturity
Evaluation 2009 v. 2015
Key Drivers for Open Source (EnterpriseDB) adoption
•  Available DBA resources . . .
•  Available tools for administration . . .
•  Functional completeness necessary to support rich applications (even compatibility
with leading products, as with EnterpriseDB’s support for Oracle PL/SQL)
•  Mature functionality necessary to support mission critical applications, such as high
availability, scalability and clustering.
. . . there is an increase in larger application vendors
beginning to offer applications based on OSDBMS
platforms.
•  The best example is Infor.
•  April 2014, Infor announced the availability of the Infor LN ERP on . . . the
EnterpriseDB Postgres Plus DBMS².
•  This migration is possible because of the Oracle compatibility feature and the
maturity of the (EnterpriseDB) product . . .
© 2015 EnterpriseDB Corporation. All rights reserved.
11
EDB: The Postgres Company
© 2015 EnterpriseDB Corporation. All rights reserved.
12
EDB Overview
Ø 
Ø 
Ø 
Ø 
Founded in 2004
Offices in US, EMEA, APAC & ASEAN
Global support network
Strategic partners with IBM, HP, Red
Hat and Infor
Ø  2,700+ customers
Ø  64 customers in F500; 137 in Forbes
Global 2000
Ø  Leaders Quadrant in 2014 Gartner
Magic Quadrant for ODBMS
Select Customers Using Postgres Plus Advanced Server
© 2015 EnterpriseDB Corporation. All rights reserved.
13
2015 Gartner ODBMS Magic Quadrant
Gartner Comments:
•  EnterpriseDB is the primary
contributor to the PostgreSQL
Community
•  EnterpriseDB’s Postgres Plus
Oracle compatibility is now more
than sufficient to run both
mission-critical and non missioncritical applications.
•  Infor, a major application
platform independent software
vendor, added EnterpriseDB as
a DBMS platform choice.
•  Reference customers continue
to identify the compatibility with
Oracle, the stability of the DBMS
and the product support as
strengths.
© 2015 EnterpriseDB Corporation. All rights reserved.
14
Postgres Plus Advanced Server
Security
Bundled Tools
•  Fine Grained Audit Logging
•  Row Level Security (VPD)
•  Role based access control
•  SQL Injection protection
•  EAL2 certification
•  Encryption at rest, transit
•  SMR/MMR replication
•  Failover management
•  Backup & Recovery
•  Enterprise management,
monitoring and tuning
•  Migration Toolkit
Performance
Compatibility
•  Resource Management
•  JSONB
•  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
•  PL/SQL, OCI support
•  Oracle SQL extensions
•  User defined objects
•  Function packages
•  Database links
•  Oracle-like tools:
EDB*Loader, EDB*Plus,
EDB*Wrap
•  Foreign Data Wrappers:
-Hadoop;, MySQL; Mongo
-Read/write
-No ETL required
© 2015 EnterpriseDB Corporation. All rights reserved.
15
15
EDB Compatibility for Oracle®
COMPATIBLE WITH
Your People
Your Apps
Your Business
Oracle Developers
Oracle Applications
Everything works on PPAS!
•  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
© 2015 EnterpriseDB Corporation. All rights reserved.
16
No disruption to
your ongoing
operations!
Survey: Ease of Migration
Organizations that migrated Oraclebased applications to Postgres Plus
Advanced Server stated the degree to
which they had to modify these
applications:
not at all: 16%
slightly 1-19%: 35%
moderately 20-49%: 35%
substantially 50-89%: 13%
extensively 90-99%: 0%
completely 100%: 0%
51% HAD SLIGHT TO NO MODIFICATIONS
© 2015 EnterpriseDB Corporation. All rights reserved.
17
EDB Migration Process
ASSESSMENT
DATABASE
MIGRATION
APPLICATION
MIGRATION
DEPLOY
© 2015 EnterpriseDB Corporation. All rights reserved.
Identify Candidate
Database(s)
Run Migration
Assessment Tool
Review Results
& Solutions
Prepare
Environments
Migrate the
Schema Definition
Migrate the Data
Connect the
Application
Test & Verify
Revise
Monitor
Manage
18
Tune
Assesment is Quick & Easy with EDB Tools
ASSESSMENT
Run Migration
Assessment Tool
Identify Candidate
Database(s)
QUICK AND POWERFUL
EASY TO READ RESULTS
•  Download tool and run
•  23 seconds to evaluate 60,000 pl/sql code
with 2500 database objects
•  Supports Oracle versions 9i, 10g, 11g, 12c
•  Scans the database and examines
all objects
•  Technical assessment reports
immediately auto-generated
© 2015 EnterpriseDB Corporation. All rights reserved.
19
Review Results
& Solutions
Migrate Yourself or Work with EDB
DATABASE
MIGRATION
Migrate the
Schema Definition
Prepare
Environments
Migrate the Data
THE MIGRATION TOOLKIT IS
COMPREHENSIVE, FAST AND FLEXIBLE
SERVICES PACKAGES MINIMIZE RISK
AND ACCELERATES DELIVERY
•  Comprehensive: Packages, Procedures, Functions, Object
•  Plan – detailed analysis and migration
•  Fast: Parallel data load, native connectivity, bypass logging…
• Flexible: Online / Offline, Schema subsets, inline datatype
•  Advisory - support your migration
Types, Users/Roles…
changes, row filters…
e d Se
dvanc
rver o
to A
Direct
MySQL
ma
Sche
DB Objects
Data
perform your database migration
Advanced
ation
Migr
a
t
a
/D
Server
PostgreSQL
Schema M
igration
Migration Scripts
SQL Server
Schema DD
L you can ed
project with consulting
•  Implement – consulting services to
QL
tgresS
r Pos
Oracle
roadmap plan
it / execute
later
© 2015 EnterpriseDB Corporation. All rights reserved.
20
Deploy with EDB Tools & Services
DEPLOY
POSTGRES ENTERPRISE
MANAGER IS A ONE
STOP SHOP TOOL
•  Monitor
•  Manage
•  Tune
© 2015 EnterpriseDB Corporation. All rights reserved.
Monitor
Manage
Tune
REMOTE DBA & ARCHITECTURAL
HEALTH CHECK
•  24x7 Monitoring provides peace of mind
•  Monitor and Manage by our expert RDBAs
•  Tune up with an Architectural Health Check
21
Sample Solutions Powered by EDB
BY ACTIVITY
BY SIZE
•  Medical billing service
•  System monitoring solution provider
−  7TB, 2 billion TPD (~20,000 TPS) across
3 databases
−  7TB
•  Financial services clearing house
•  Telco new mobile phone ordering system
−  3-6 TB
−  Peak 6200 TPS, Load tested to 8000 TPS
•  Distribution and warehousing
management
•  Securities trading application
−  Normal 800 users w/ 2750 TPS; Peak
reported 10,000 TPS; 1 billion writes/day
−  4+TB
•  Real Estate search application
•  Financial services marketing platform
−  2TB
−  200,000 selects/sec, 25k write TPS
•  Internal ticket tracking application
•  Media company serving online content
−  2TB
−  Reported at 75,000 TPS (heavy reads)
•  Online content metadata management
for Google Drive-like app
−  Normally ~ 1000 concurrent DB users
© 2015 EnterpriseDB Corporation. All rights reserved.
22
Sample Solutions Powered by EDB
BY INDUSTRY
Aerospace and Defense
Geospatial Weather Tracking App. Acoustics Intelligence Project, Command and Control System, Operational and Analysis System
Financial Services
Credit Card Payments, Cross Promotional Offers for Consumer Billing Statements. Financial Trading and Clearing Systems, Insurance
Policy Transaction System
Government
Distribution Mgt, Drivers License Database, Metadata Mgt for CMS. Personnel Record Keeping
Healthcare
Billing Solution, Clinical Research Information System, Paperless Referral System
High Technology
Authentication Mgt. Digital Certificate Mgt, Storage Optimization and Capacity Planning, Online Gaming Platforms
Geospatial Applications
General Purpose Location Mapping, Points of Interest Mgt, Satellite Tracking
Retail
Retail Parts Catalog for 3,500 stores / 50,000 employees
Telecommunications
Billing System, Customer Facing Order Mgt, Network Device Status Monitoring, Network Routing, Carrier Authentication Mgt
Transportation and Warehousing
Distribution and Warehouse Management
© 2015 EnterpriseDB Corporation. All rights reserved.
23
© 2015 EnterpriseDB Corporation. All rights reserved.
24
Thank You
I would love to hear from you!
Keith Alsheimer
[email protected]
Twitter: @keithalsheimer
© 2015 EnterpriseDB Corporation. All rights reserved.
25