EnterpriseDB – The PostgreSQL Company (Technical) - Vdel.com

cuttlefishblueData Management

Dec 16, 2012 (4 years and 8 months ago)

147 views



EnterpriseDB
EnterpriseDB
The PostgreSQL Company
The PostgreSQL Company
Grega Bremec
Grega Bremec
Softergee
Softergee


PostgreSQL
world's most advanced open-source database
BSD license
active community
20 years of development
designed for demanding OLTP environments
proven in practice

BASF, UNCF, State Department, IMDB,
Greenpeace, SourceForge, Afilias, Apple, Fujitsu,
Sun, Cisco, Skype, ...


EnterpriseDB
the PostgreSQL company

established in 2004, Westford, MA

over 100 employees

over 300 customers

Sony, British Telecom, Fujitsu, Guardian, Juniper, ...

65 strategic partners

2 of 5 core PostgreSQL committee members


EnterpriseDB
PostgresPlus development
commercial support (24/7)
training
consulting
maintenance
implementations


PostgresPlus
designed on PostgreSQL

limitless flexibility

wide array of functions

security and protection

transactional support

data integrity


PostgresPlus Standard Server
open-source
database management (pgAdmin)
JDBC and ODBC drivers
distributed cache (pgmemcache)
integrated connection pooling (pgBouncer)
job scheduler (pgAgent)
integrated replication, GIS, other modules
dynamic debugger
Oracle replication


PostgresPlus Advanced Server
database management
DynaTune, DRITA
federated and hierarchical queries
Oracle compatibility
migration tools
InfiniteCache
GridSQL
SQL/Protect
query optimization hints


Oracle Compatibility
49 dictionary views
Oracle SQL extensions
Oracle Database Links
PL/SQL
User Defined Packages
EDB*OCI
Replication Server
Migration Studio


Migration Benefits
no need to

train DBAs and developers

perform complicated data migration

risk substantial application code changes

engage in long-term re-testing
migrations

otherwise measured in man/months to years

perfomed in man/days or weeks


InfiniteCache
disk access is slow

especially so with mostly random reads
cache memory is expensive

above a certain limit
ideal DB access pattern is memory read
assumptions

there are free resources available in the network

the network is reliable

the network is faster than the disk


InfiniteCache
standard database operation


InfiniteCache
InfiniteCache operation


InfiniteCache
based on memcached
uses distributed memory (secondary cache)
random, mostly read scenarios much faster
sequential scan bypasses InfiniteCache
nodes redundant

node failure simply reduces performance


InfiniteCache
performance


GridSQL
data warehouses tend to outgrow
scale-out is difficult due to design
solution requirements

parallel data import

parallel processing

transaction support

support for modifications

heterogenous environments


GridSQL
target audience

small and medium first-time DW users

small and medium data-mart users

existing Oracle users in need of DW offload


GridSQL


GridSQL
loosely-coupled, shared-nothing architecture
data sets

works with meta-data
(GridSQL database)

schema information

records DDL

partitioning and replication can be used
central coordinator, agents
SQL statements formed and distributed to agents
results merged and processed by coordinator


GridSQL
performance


PostgreSQL Scalability


PostgresPlus Benefits
Standard Server

fully open-source

certified binaries

subscription optional
Advanced Server

Oracle compatibility

performance add-ons

inter-platform development environment
StackBuilder