Enterprise DB Postgres Plus Standard Server

14. 06. 08
posted by: Rozvo WebMaster1
Visto: 1401

Enterprise DB Postgres Plus Standard Server  

Está hecho para las necesidades de desarrolladores y pequeñas organizaciones de contar con una base de datos rápida y fácil de instalar, lista para manejar una variedad de tipos de transacciones y trabajos, y está preparada para soportar grandes cargas de datos y de cantidad de usuarios. El Standard Server entrega pruebas certificadas PostgreSQL en plataformas específicas con un solo click en el instalador binario logrando que la adquisición, instalación y actualización del software de código libre sea una tarea simple y rápida. No hay descargas de horas, ambientes de construcción, compilación, pruebas y configuración de que preocuparse.

 

PostgreSQL vs Postgres Plus Advanced Server

Feature Differences PostgreSQL Postgres Plus
Advanced Server
General Differences

Note: All features marked:  , are also Oracle compatible.

  Includes all PostgreSQL features and updates, plus additional:
    - Security features
    - Performance features
    - Developer features
    - DBA features
    - Oracle® Compatibility
    - Enterprise Tools
Enterprise Security Features
Row Level Security (VPD) ⊕   Yes
Enhanced Audit/Compliance   Yes
Server Procedural Language Protection (EDB*Wrap) ⊕   Yes
Enterprise Performance Features
Scalable Partitioning   Yes
Declarative Partitioning ⊕   Yes
Query Optimizer Hints ⊕   Yes
Infinite Cache   Yes
Enterprise Developer Features
Hierarchical Queries ⊕   Yes
19 pre-defined re-usable Function Packages Yes
Synonyms (public and private) ⊕   Yes
Extended Functions and Operators ⊕   Yes
Explicit Commit/Rollback in Stored Proc. ⊕   Yes
Bulk Collect and Binds ⊕   Yes
User defined object types ⊕   Yes
Nested Tables ⊕   Yes
User Defined Exceptions ⊕   Yes
User defined packages and functions ⊕   Yes
Associative Arrays ⊕   Yes
VARRAYs ⊕   Yes
edb_stmt_level_txn ⊕   Yes
EDB*Wrap ⊕   Yes
EDB*Plus ⊕   Yes
ECPGPlus   Yes
Enterprise DBA Features
Declarative Partitioning Syntax ⊕   Yes
EDB*Loader ⊕   Yes
SQL Session/System wait tuning diagnostics ⊕   Yes
Extended Catalog Views ⊕   Yes
DynaTune®   Yes
Oracle Compatibility
PL/SQL Support in Stored Procedures and Triggers ⊕   Yes
PL/SQL Debugger ⊕   Yes
EDB*OCI ⊕   Yes
Enterprise Tools included in a subscription for: Standard Edition Enterprise Edition
EDB Update Monitor Yes Yes
Postgres Enterprise Manager Yes Yes
EDB SQL/Protect Yes Yes
EDB xDB Replication Server (single-master) Yes Yes
EDB Migration Toolkit ⊕ Yes Yes
EDB Failover Manager Extra Option Yes
EDB Replication Server (multi-master) Extra Option Yes

 

  

Common Features

Go to: Different Features

Common Features PostgreSQL Postgres Plus Advanced Server
Full ACID Compliance Yes Yes
Multi-Version Concurrency Control (MVCC) Yes Yes
Strong conformance to ANSI-SQL:2008 standard Yes Yes
ANSI Constraints Yes Yes
SQL USAGE privilege on types Yes Yes
Column Level Permissions Yes Yes
Per-Column Collations Yes Yes
Column Trigger Yes Yes
Primary/Foreign keys support Yes Yes
Function based Indexes Yes Yes
Composite Indexes Yes Yes
K-Nearest-Neighbor Indexes Yes Yes
Index-only Scans Yes Yes
Triggers and Stored Procedures Yes Yes
Views Yes Yes
View Security Barriers Yes Yes
Materialized Views Yes Yes
Unlogged Tables Yes Yes
SQL/MED Support Yes Yes
Library interface support for libpq, JDBC, ODBC, .NET, Python, C/C++, Perl, Ruby PHP and more. Yes Yes
Full Text Search, XML and JSON support, HStore Key-Values support Yes Yes
Range Data Types Yes Yes
Writeable Common Table Expressions Yes Yes
Window Functions Yes Yes
Rules Engine Yes Yes
In-place version upgrades Yes Yes
Streaming Replication & Hot Standby Yes Yes
Online Backup and Point In Time Recovery Yes Yes
Online Index Reorganization Yes Yes
PostGIS spatial extensions support Yes Yes
Partitioning of Table and Indexes Yes Yes
Authentication support for LDAP, SSL, RADIUS, PAM, Kerberos, GSSAPI, SSPI, Trust, Password, Ident. Yes Yes

 

Function Package Descriptions for Postgres Plus Advanced Server

Return to Feature Differences - Packages

Package Name Package Description
DBMS_ALERT Allows asynchronous notification of database events via an Alert. Using this package and triggers, an application can notify itself whenever values of interest in the database are changed.
DBMS_CRYPTO Provides functions to encrypt and decrypt stored data.
DBMS_JOB Has been replaced by DBMS_SCHEDULER but included for compatibility with older Oracle applications.
DBMS_LOB Allows access to and manipulation of Large OBject values.
DBMS_LOCK Provides an interface to Lock Management services.
DBMS_OUTPUT Allows the sending of messages from stored procedures, packages, and triggers for application or debugging use.
DBMS_PIPE Functions that allow two or more sessions in the same database instance to communicate with one another.
DBMS_PROFILER Provides functions to profile SQL workloads and identify performance bottlenecks.
DBMS_SCHEDULER A job scheduler for creating and executing unattended repetitive tasks inside the database.
DBMS_SQL Permits the use of dynamic SQL in procedures to allow applications to run SQL statements with unknown parameters (such as table name) until runtime.
DBMS_RANDOM Useful functions to generate random text, numeric and date values.
DBMS_RLS Implements row level security in the database blocking users from seeing each other's data in the same application.
DBMS_UTLTITY A collection of functions for getting information about various runtime operations and meta data from the database.
UTL_ENCODE Functions to perform Base64 encoding and decoding of data intended for transport between hosts.
UTL_FILE Allows database procedures to read and write operating system text files in an I/O stream fashion.
UTL_HTTP Provides the ability to make HTTP calls to access information on the internet.
UTL_MAIL Provides functions to create,manage, and send email from the database including attachments, CC, and BCC.
UTL_SMTP Provides functions for sending mail via SMTP according to the RFC821 specification.
UTL_URL Provides functions for escaping and un-escaping URL strings.