Postgres Plus Advanced Server®
Advance Server Tab
A Gartner Magic Quadrant Leader
The news is out! EnterpriseDB is recognized as a leader in Gartner's 2014 Magic Quadrant for Operational Database Management Systems report. Our recognition comes as Postgres gathers greater momentum and global brands embrace its growing technical prowess. Postgres Plus Advanced Server enables enterprises to divert investment from the high license and maintenance fees paid to traditional databases, to more strategic IT objectives instead. Read Gartner's latest Magic Quadrant report.
Proven performance in enterprises and government
A relentless focus on performance, security, and special tools over multiple releases continues to expand the range of solutions possible with Postgres Plus. Resource Manager prioritizes CPU and I/O, protecting important processes. This allows DBAs to limit resource consumption, preventing any single Postgres Plus process from monopolizing resources to the detriment of other processes. Recent partitioning improvements, linear read performance scaling up to 64 cores, optimized locking techniques, and multiple performance boosting features handle the largest OLTP loads for many commercial, U.S. government, and non-profit organizations of all sizes and missions. View a cross section of our customers.
NoSQL for the enterprise
Advanced Server’s powerful combination of unstructured and relational database technologies in a single enterprise database management system provides the freedom, flexibility and performance of handling unstructured and semi-structured data while preserving its long-term viability as enterprise information.
The document and key-value store features in Advanced server provide the advantages of new NoSQL technologies plus the ability to integrate them into traditional corporate data infrastructures without data silos, operational complexity, loss of data integrity, and risk. Read more about NoSQL for the Enterprise.
Every data center has a sweet spot for Postgres Plus Advanced Server®
Organizations of all sizes and types are cutting database costs wherever possible by deploying a capable low cost alternative to costly proprietary databases. This strategy reduces lock-in to a single vendor and gives IT managers more leverage when negotiating for lower costs. Controlling costs with expensive proprietary vendors has been proven with Linux for operating systems, Xen and KVM for virtualization and JBoss and Apache for middleware and is now being applied to databases. Compare costs with our online TCO calculator.
Database compatibility creates a larger sweet spot for savings!
EDB's compatibility technology helps cap, reduce, or eliminate Oracle® fees using multiple strategies, while preserving your investment in Oracle volume licensing, infrastructure, skills and practices. For over 9 years, EnterpriseDB has built a solid practice around helping customers just like you save money for their applications built around PL/SQL, OCI, and Pro*C.
Oracle migration tools convert your schema and many applications run with few changes. Customer conversions of their easy to migrate applications take days or a few weeks. EDB services like the Oracle Migration Assessment quickly identify high-payback applications and the Migration Factory can take 100% of the burden off your staff and realize savings sooner. Re-training is minimal because of the Oracle-like tools provided by Postgres Plus Advanced Server, so you staff can continue leveraging their Oracle knowledge and skills against a low cost open source based alternative. See the Ease of Migration tab to learn more.
Use EnterpriseDB's best practices to optimize your database mix for cost savings
There are many paths to finding and applying costs savings in your database portfolio including how you manage your existing volume license agreements. One method is moving existing and easy to migrate applications off their authorized volume licenses to Postgres Plus Advanced Server at a much lower cost. Then recycle the volume licenses to account for growth or hardware upgrades in your difficult to migrate or unqualified to migrate applications. A smart re-balancing of your database mix can result in you paying less in total fees with Postgres Plus Advanced Server than your current proprietary maintenance fees alone. Other strategies used by customers to deploy Postgres Plus Advanced Server include:
- Building new OLTP and operational applications
- Applying it to a class of applications based on specific criteria (SLAs, data size, concurrent users, etc.)
- Addressing archival or read-only applications that don't justify expensive licenses
- Building non-mission critical applications
- Assigning it to particular business units or departments
- Offloading reporting tasks from a master database as an inexpensive replication server
We can help you create a path forward
Our free Enterprise Enablement consultation will inventory your database portfolio and help you identify likely candidates for implementing Postgres Plus Advanced Server at a cost savings in the context of your business goals and current constraints. An inexpensive followup Migration Assessment service can then identify technical issues (if any) for each candidate application, map out a technical strategy for implementation, and estimate your costs savings allowing you to make informed decisions. Contact us for a consultation now.
Postgres Plus Advanced Server® has a proven track record supporting large transactional systems for thousands of users world-wide and around the clock. It is built upon and integrates every release of the world's most advanced open source database, PostgreSQL. EDB engineers then work continuously with our enterprise users to add features, tools and solutions to meet our customers demanding standards.
Recent partitioning improvements, linear read performance scaling up to 64 cores, modern locking techniques, and multiple performance boosting features handle the largest OLTP loads produced by commercial, government, and non-profit organizations of all sizes and missions.
No other open source based RDBMS protects your data as well as Advanced Server which provides integrated row level security, a module to guard against SQL injection attacks, enhanced auditing to meet compliance obligations, and protection of important server side code from unauthorized viewing.
EDB's compatibility technology helps cap, reduce, or eliminate Oracle® fees while preserving your investment in Oracle infrastructure, skills and practices using multiple strategies including new deployments, replication for reporting, and migrating mission and non-mission critical applications.
Enterprise Developer Features
Developers are more productive using 19 proven function packages, complex data types that map cleanly to object oriented applications, nested tables, hierarchical queries, explicit transaction control in stored procedures and all in the language of their choice (e.g. Java, Python, C/C++ and more).
Enterprise DBA Features
DBAs get more control over their data with a CPU and I/O Resource Manager, centrally managed SQL injection guard utility, extensive catalog views, a high speed bulk loader, low level session and system wait diagnostics, and Postgres Enterprise Manager to monitor, manage and tune multiple databases efficiently across the enterprise.
Tools for Scalability, HA, Performance, and more
A suite of professional grade tools all developed and supported by EnterpriseDB, provides your staff with solutions to address critical issues related to data protection, tuning SQL workloads, backup and disaster recovery, read and write scalability, high availability, monitoring, data migration, and software updates.
Postgres Plus Advanced Server is available on a variety of platforms including multiple Linux 64 bit operating systems and Windows 64 bit systems.
A savings sweet spot
For over 9 years, EnterpriseDB has built a solid practice around reducing, capping or eliminating high Oracle costs with Postgres Plus Advanced Server's database compatibility, and simultaneously preserving your investment in Oracle volume licensing, infrastructure, skills and practices. We have helped customers just like you save money for their applications built around PL/SQL, OCI, and Pro*C. In spite of attractive licensing deals during a company’s database growth phase, many organizations regret the loss of control to manage costs that inevitably occurs a few years later. EnterpriseDB’s Postgres Plus Advanced Server with database compatibility for Oracle gives you cost savings options.
If you can't replace Oracle, you can control costs
For many customer applications Oracle simply cannot be replaced for various reasons including volume licensing, migration risk, and COTS applications certified to work with Oracle. However, you can still gain control over ever increasing expenses with various cost containment strategies.
One method is moving existing and easy to migrate applications off their authorized volume licenses to Postgres Plus Advanced Server at a much lower cost. Then recycle the volume licenses to account for growth or hardware upgrades in your difficult to migrate or unqualified to migrate applications. A smart re-balancing of your database mix can result in you paying less in total fees with Postgres Plus Advanced Server than your current proprietary maintenance fees alone.
When it comes to choosing which applications to migrate, you have many options. A sample of strategies used by our customers includes:
- build new OLTP and operational applications
- use Advanced Server based on criteria specific to your needs (SLAs, database size, concurrent users, etc.)
- service archival or read-only applications that don't justify expensive licenses
- build non-mission critical applications
- assign Advanced Server to particular business units or departments
- use it to offload reporting tasks from a master database as an inexpensive replication server
Database compatibility explained
Advanced Server's database compatibility focus's on five critical areas of technology. A schema migration toolkit converts Oracle objects (data types, tables, partitions, database links, users, roles, triggers, stored procedures) to Advanced Server.
The second focus is on procedure processing; in additional to processing native PostgreSQL's PL/pgSQL, it also has a native parser for Oracle's PL/SQL. This includes Oracle syntax, function packages (e.g. DBMS_UTL, DBMS_RLS, and DBMS_PROFILER), user defined exceptions, named parameter notation, private synonyms, partitioning syntax, GOTO, Bulk Collect/Fetch/Bind, VARRAY, table() expressions, and more.
The next focus is on Oracle SQL extensions that are popular with users such as: decode(), the DUAL table, ROWNUM, Object Types and sub-types.
Application compatibility is the next focus with support for OCI and Pro*C as well as multiple library interfaces.
Finally, Advanced Server comes with tools critical to Oracle users with similar look and feel to minimize re-training. Examples of these tools include: EDB*Plus, EDB*Loader, EDB*Wrap and a stats pack like toolset for DBAs.
We make managing change easy
EDB understands that a technology change in your databases is far from trivial. That’s why we provide a comprehensive set of strategies, features, tools, and services to make a change as smooth as possible. EDB’s database compatibility addresses the software for schema, data, and code compatibility, as well as the people who use it by providing the same objects, syntax, extensions and tools they use today for an environment that feels very familiar. You can even replicate data bi-directionally from Postgres Plus Advanced Server making it extremely easy to integrate our low cost platform into your existing environment.
Customer conversions of their easy to migrate applications take only days or a few weeks. EDB services like the Migration Assessment for Oracle quickly identify high-payback applications to help you realize savings sooner.
Additional database compatibility resources
- DOCUMENTATION: Database Compatibility Developers Guide
- VIDEO: What is Database Compatibility?
- WHITE PAPER: Optimizing Open Source for Greater Database Savings and Control
PostgreSQL vs Postgres Plus Advanced Server
Feature Differences (Hold pointer over features for details)
Go to: Common Features
|Feature Differences||PostgreSQL||Postgres Plus
|Includes all PostgreSQL features and updates, plus additional:
- Security features
- Performance features
- Developer features
- DBA features
- Compatibility with Oracle
|Enterprise Security Features|
|Row Level Security (VPD) ⊕|
|Server Procedural Language Protection (EDB*Wrap) ⊕|
|Enterprise Performance Features|
|Query Optimizer Hints ⊕|
|Enterprise Developer Features|
|SQL Aggregates with CUBE, ROLLUP and GROUPING SETS|
|Hierarchical Queries ⊕|
|19 pre-defined re-usable Function Packages ⊕|
|Synonyms (public and private) ⊕|
|Extended Functions and Operators ⊕|
|Explicit Commit/Rollback in Stored Proc. ⊕|
|Bulk Collect and Binds ⊕|
|User defined object types ⊕|
|Nested Tables ⊕|
|User Defined Exceptions ⊕|
|User defined packages and functions ⊕|
|Associative Arrays ⊕|
|Enterprise DBA Features|
|Declarative Partitioning Syntax ⊕|
|SQL Session/System wait tuning diagnostics ⊕|
|Extended Catalog Views ⊕|
|Database Compatibility for Oracle (also includes all features in table with the ⊕ symbol)|
|PL/SQL Support in Stored Procedures and Triggers ⊕|
|PL/SQL Debugger ⊕|
Go to: Different Features
|Common Database Features||PostgreSQL||Postgres Plus Advanced Server|
|Seamless integration with EDB mission critical tools:
Postgres Enterprise Manager
xDB Replication Server
Backup & Recovery Tool
|Full ACID Compliance|
|Multi-Version Concurrency Control (MVCC)|
|Strong conformance to ANSI-SQL:2008 standard|
|Primary/Foreign keys support|
|GIN & GiST Indexes|
|Function based Indexes|
|Full Text Search|
|Triggers and Stored Procedures|
|Materialized Views (with concurrent refresh)|
|View Security Barriers|
|SQL USAGE privilege on types|
|ANSI Standard SQL GRANT/REVOKE|
|Column Level Permissions|
|Programming language support for database Stored Procedures, Triggers and Functions.||pgSQL
|Application Client Library interface support||libpq
|Foreign Data Wrappers||HDFS (Hadoop)
|Unstructured Data Types||XML
|Range Data Types|
|Writeable Common Table Expressions|
|In-place version upgrades|
|Streaming Replication & Hot Standby|
|Online Backup and Point In Time Recovery|
|Online Index Reorganization|
|Hot restart with pg_prewarm|
|PostGIS spatial extensions support|
|Partitioning of Table and Indexes|
|DB Connection Encryption||SSL||SSL|
|DB Connection White Lists|
|DB Connection Black Lists|
Function Package Descriptions for Postgres Plus Advanced Server
|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 web servers.|
|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.|
What's New in 9.4
• Resource Manager prioritizes CPU and I/O to protect important processes.
• Partitioning enhancements including Hash syntax
• Developer function packages including UTL_HTTP for communications with web servers
Read more about what's new...
Postgres Plus Advanced Server Datasheet
How to Buy
Video: Ensure Success
Learn about the EnterpriseDB software, tools and services that can ensure your successful Postgres deployment in this 3-minute video.