Which Postgres is Right for Me?

boreddizzyΔιαχείριση Δεδομένων

16 Δεκ 2012 (πριν από 4 χρόνια και 4 μήνες)

319 εμφανίσεις

© Copyright 2012 Hewlett
-
Packard Development Company, L.P. The information contained herein is subject to change without notice
.

Sean Doherty, Vice President, Business
Development

EnterpriseDB

Corporation


2

EnterpriseDB, Postgres Plus and Dynatune are trademarks of
EnterpriseDB Corporation. Other names may be trademarks of their
respective owners. © 2010. All rights reserved.

EnterpriseDB Corporate Overview

Presented by EnterpriseDB Corporation

Sean Doherty, Vice President, Business Development

IT Dilemma



Basic IT economic
problem is not solved
and getting worse


Proprietary software
companies cannot
change fast enough


Oracle and others are
raising prices in a
difficult economic
climate


Vendor Consolidation

3

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Why Now


IT Strategic Budget Problem

Where I Need to
Spend Budget $

Where I Spend
Infrastructure
S/W Budget $
Today

4


DBMS Up to
35% of Total
Spend!*

* Forester Research

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Why Now


IT Strategic Budget Problem

Where I Need to
Spend Budget $

Where I Spend
Infrastructure
S/W Budget $
Today

Other (OS, etc.)

Middleware

DBMS
Maintenance &
Fees

Revenue
Generating
Applications

“Big Data”
Challenges (BI,
DW)

Deriving Business
Value from Data

5

Free up
DBMS spend
and use it for
growth!!

* Forester Research

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

EnterpriseDB
-

The Enterprise PostgreSQL Company

6


The Enterprise PostgreSQL company


Founded in 2004, first product GA in 2005


120+ employees


1,300+ customers across all market segments


60,000+ downloads / week of PostgreSQL and related products


Enabling database consolidation using PostgreSQL and advanced
Oracle compatibility


Saving customers millions through the power of open source


Strong financial backing:

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Bringing the Advantage to Enterprises


Fast development cycles


Thousands of developers


Better code


Lower cost

Open Source Software


24/7 support


Services and training


Certification


Indemnification


Product strategy

Commercial Software

7

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

8

EnterpriseDB, Postgres Plus and Dynatune are trademarks of
EnterpriseDB Corporation. Other names may be trademarks of their
respective owners. © 2010. All rights reserved.

PostgreSQL Introduction

PostgreSQL the Database

9


25+ years


of enterprise
-
class development


of enterprise
-
class features



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

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

PostgreSQL and the Community

10


Independent & Thriving Development Community


6 core team members (2 employed by EnterpriseDB)


16 committers for v9.0 (3 employed by EnterpriseDB)


275 contributors for v9.0 (7 employed by EnterpriseDB)


9,000,000+ downloads / year


EnterpriseDB’s Bruce Momjian was one of the founders of
the PostgreSQL Global Development Group


Thousands of active deployments worldwide in public and
private sector organizations of all sizes



CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

PostgreSQL Customers

11

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

12

EnterpriseDB, Postgres Plus and Dynatune are trademarks of
EnterpriseDB Corporation. Other names may be trademarks of their
respective owners. © 2010. All rights reserved.

Postgres Plus
®

Advanced Server

What Is Postgres Plus Advanced Server?

PostgreSQL

13


The world’s most advanced open
source database


In continuous development for more
than 20 years


Designed for mission
-
critical OLTP
environments


Used by the world’s largest
commercial and government
organizations


PostgreSQL

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

What Is Postgres Plus Advanced Server?

PostgreSQL

14

Compatibility


Run applications written for Oracle
virtually unchanged


No need to re
-
train Oracle DBAs
and developers


Support for PL/SQL language and
OCI interoperability


Replication for easy sharing of data


CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

What Is Postgres Plus Advanced Server?

PostgreSQL

15

Security


Arguably the world’s most secure
database


Additional proprietary features built
into the database


CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

What Is Postgres Plus Advanced Server?

PostgreSQL

16

Performance


Built for high performance OLTP


Up to
200
% faster than
PostgreSQL


Faster than MySQL for OLTP


CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

What Is Postgres Plus Advanced Server?

PostgreSQL

17


Online migration toolkit to migrate
all data and business logic from
Oracle to EnterpriseDB


Online migration toolkit to migrate
data and schema for MySQL, SQL
Server, and Sybase


Familiar and intuitive for DBAs and
developers


Postgres Enterprise Manager


Management & Monitoring


Tools

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

What Is Postgres Plus Advanced Server?


Built on the world’s most advanced
database

PostgreSQL


8
h

generation Oracle compatibility


World
-
class security add
-
ons


Performance that rivals any other
proprietary RDBMS


Enterprise
-
class developer and
DBA tools


Installation, performance tuning,
and maintenance services


Software indemnification


PostgreSQL

18

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

19

EnterpriseDB, Postgres Plus and Dynatune are trademarks of
EnterpriseDB Corporation. Other names may be trademarks of their
respective owners. © 2010. All rights reserved.

Oracle Compatibility

Oracle Compatibility


Run applications written for Oracle virtually unchanged


No need to re
-
train Oracle DBAs and developers


Support for PL/SQL language and OCI interoperability


Replication for easy sharing of data


Dramatic Cost Savings


No Vendor Lock
-
in


20

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Compatibility Means:


SQL extension support


Decode, NVL, Substr, NVL2, Date/time functions


PL/SQL support


REF, Implicit and explicit cursors, Looping, variable declarations, Bulk
binding, Explicit Transaction Control


Tools


EDB*Plus, EDB*Loader , EDB*Wrap


Features


Packages, procedures, Functions, Triggers, Users, Roles, Hints, Synonyms


Data Types


Integer, number, char, double precision, float, varchar2, blob, clob, xmltype,


Built
-
in Packages


DBMS__:SQL, LOB, JOB, PIPE, ALERT, OUTPUT, UTILITY, PROFILER


UTL_:FILE, MAIL, SMTP, ENCODE, TCP


Oracle
-
like Data Dictionary


ALL_, DBA_, USER_ views


CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Migration Example

22

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Database Migration Toolkit



Online Migration Toolkit enables point and click migration from
Oracle


Automatically Migrates:



23



Data



Schemas



Stored Procedures



Triggers



Functions





Sequences



Packages



Views



Database Links



Synonyms



CONFIDENTIAL

©
2012
EnterpriseDB. All rights reserved.

24

EnterpriseDB, Postgres Plus and Dynatune are trademarks of
EnterpriseDB Corporation. Other names may be trademarks of their
respective owners. © 2010. All rights reserved.

EnterpriseDB


HP Partnership

25

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

DB2, Informix

Websphere

Windows, Linux,
AIX

X, I, P, Z

Oracle Database

Weblogic, Fusion

Windows, Linux,
Solaris

SPARC

HP & EnterpriseDB Provide the Stack

26

Postgres Plus
Advanced Server

JBoss, Tomcat

Windows, Linux,
HP
-
UX

ProLiant, Integrity

CONFIDENTIAL

©
2012
EnterpriseDB. All rights reserved.

TCO for HP Integrity Superdome 2

Tremendous savings when you move to open
-
source technology

Source: TCO/ROI Analysis with ROI Analyst from Alinean, Inc.


Overall savings of $4,062,127
over three years with HP
Integrity Superdome 2 and
Enterprise DB


Return on investment of 191%


Internal rate of return: 74%


Payback period of 15 months

6/7/2012

27

Oracle vs. EnterpriseDB

TCO with HP Integrity BL
890
c i
2
Servers


Fantastic ROI when you move to open source technology

Source: TCO/ROI Analysis with ROI Analyst from Alinean, Inc.


$1,706,673 of 3
-
year cumulative
benefits by moving to
EnterpriseDB on HP Integrity
BL890c server blades


R
eturn on investment of 271%


Internal rate of return: 101%


Payback period of 12 months

6/7/2012

28

Oracle vs. EnterpriseDB

Unique initiative with a worldwide presence and coverage

HP Intel Solution Centers


10 years of success, worldwide programs
including Cloud Center of Excellence, RISC to
HP Intel Architecture Migrations, HP Networking
Customer Visit Center and more


Over 200 projects conducted successfully


Complete IT (400+ systems) & Telecom
infrastructure


Strategic partnership with Red Hat



Portfolio of 40+ solutions with access to HP and
Intel ecosystem of partners, including
EnterpriseDB


Complete test & validation environment


Strategic partnership with Intel, 10
-
year long
standing collaboration


A unique proof point in the industry with a proven
service offer

Grenoble

Plano

Shanghai

Mission
: Accelerate the adoption of new and innovative solutions by creating simple and rewarding
end
-
to
-
end customer experiences that benefit our customers and partners, in a compelling and
engaging collaborative environment. M
ore information available at
http://www.hpintelco.net


6/7/2012

29

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Oracle Migration Program Benefits


Oracle Migration Assessment


Pre
-
analysis interview


Analysis of Oracle schemas to be migrated


Finds possible migration issues


Unsupported Features


Unsupported Syntax


Implementation Differences


Findings documented with possible workarounds in final report


Post analysis discussions to review findings


Oracle Migration Factory Services


Migrate the database(s) to Postgres Plus Advanced Server


Resolve any issues


Implement workarounds for missing or different functionality


Perform sanity checking of unit functionality


Document the changes/workarounds


Educate Customer on changes/workarounds


Advise on application level changes needed


Customer can customize with add on options


30

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Oracle Migration Assessment Process

31

Get Oracle Migration Assessment Results

1

Supported
Features in

PPAS & required
work
-
arounds
(database)

Static Analysis of Oracle Schema

and database layout

2

Review of features used in Oracle client application

Static Analysis of Source Code

Developer Interviews

Supported
Features in

PPAS & required
work
-
arounds
(application)

CONFIDENTIAL

©
2012
EnterpriseDB. All rights reserved.

Analysis of Results

32

3

Evaluate results along 5 axis using proven algorithms

Considered, detailed report
describing supported features
along with elaboration of issues
and recommended fixes to ensure
seamless migration of production
database. (database &
application)


Score of
1


10
assigned based
analysis of steps
1
and
2


1
difficult


10
minimal effort


Work abounds for identified missing
features


Time estimates given in man weeks


4

Migration report developed

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Oracle Migration Factory Core Services


Customer provides data
-
less Oracle export of database


Migrate the database(s) to Postgres Plus Advanced Server


Resolve any issues


Implement workarounds for missing or different functionality


Perform sanity checking of unit functionality


Requires input/output from customer on same units in Oracle


Document the changes/workarounds


Educate Customer on changes/workarounds


Advise on application level changes needed


Return migrated databases to Customer


Via pg_dump


Customer can customize with add on options

33

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Oracle Compatibility & Migration Strategies

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 non Mission
Critical Oracle Apps to
Postgres Plus


Significant cost savings


Leverages all existing Oracle skills


Very low risk

Migrate Mission Critical
Oracle Apps to

Postgres Plus


Biggest cost savings


Leverages all existing Oracle skills


Greatest deployment flexibility

34

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

Summary


Migrations are easy, secure and cost
-
effective


Compatibility provides:


Lower cost of migrations


Shorter migration timelines


Lower risk (you can always go back)


EnterpriseDB provides:


Oracle compatibility


Automated tools for safe, reliable and easy migrations


And others: MySQL, SQL Server & Sybase (databases & schemas)


Migration expertise for:


Planning


Testing


Performing migration


Roll out


EnterpriseDB & HP partnership provides:


Postgres Plus Advanced Server builds for Windows, Linux and HP
-
UX


Pre
-
sales support and services to help through the process

35

CONFIDENTIAL

© 2012 EnterpriseDB. All rights reserved.

36

EnterpriseDB, Postgres Plus and Dynatune are trademarks of
EnterpriseDB Corporation. Other names may be trademarks of their
respective owners. ©
2010
. All rights reserved.

Thank You