EnterpriseDB: The Enterprise Postgres Company

Postgres Plus^® Advanced Server v8.3 Rel. 2 Now Available!

Postgres Plus Advanced Server is an enterprise ready database renowned for its transaction processing capabilities and exceptional performance across a spectrum of query intensive and mixed load applications.

Built upon PostgreSQL, the world's most advanced open source database, Advanced Server v8.3 Release 2 offers deeper Oracle^® compatibility to more applications than ever before, as well as performance and scalability features like Infinite Cache that are not available in the community version of PostgreSQL. Together with Linux^® and JBoss^®, Postgres Plus Advanced Server is the perfect candidate for completing your open source infrastructure.

Alternative Database Strategies

Enterprises dependent on Oracle are looking for alternative ways to lower their overall spend and commitment for many reasons, the most common of which include:
- Lower Total Cost of Ownership (TCO). Oracle is expensive. Comparable or 'good enough' performing alternatives are available at significantly lower price / performance ratios.
  
  The graph below illustrates the economic advantages of Postgres Plus Advanced Server compared to Oracle. Based on currently published list prices, the TCO of a 16-CPU (four servers, four CPUs/server) Oracle configuration is $1,261,600 over a three year term. The TCO of a comparably configured Postgres Plus deployment is $215,760, a TCO savings of $1,045,840, or 83%.
- Complimentary Co-existence. You can lower your Oracle license costs with adjacent applications that simply need to dove-tail seamlessly with your mission critical applications. For instance, you can improve your transaction and reporting performance by offloading data from the main transaction database to a reporting database without purchasing additional Oracle licenses. This is a common replication application that fits perfectly with Postgres Plus Advanced Server's abilities.
- Database Flexibility. ISVs selling database agnostic applications can increase margins and/or lower prices by replacing their Oracle data store. This choice also gives them pricing flexibility and avoids vendor lock-in.
- Better Support and Services. Many Oracle customers are seeking superior technical support and a richer customer experience especially when it comes to the cost of consulting services.
Download the Advanced Server Oracle Compatibility data sheet.
Oracle Migration Experts

EnterpriseDB has made years of extensive investments enhancing Postgres Plus Advanced Server to run applications written for Oracle. The extent of the compatibility is proven in an almost push button conversion for many Oracle applications migrated to Postgres. The enhancements fall into the following broad categories:
- SQL Extensions Compatibility. Database vendors have unique SQL language extensions to differentiate their products. Postgres Plus Advanced Server understands Oracle's SQL extensions such as decode(), the DUAL table, and ROWNUM.
- Procedural Language Compatibility. Postgres Plus Advanced Server executes PL/SQL, Oracle's unique language for triggers, stored procedures, packages and functions. It even includes support for database internals like Wait Events. Developer re-training and application re-writing are non-existent to minimal, saving valuable time and conversion costs while reducing migration risk.
- Data Dictionary Views Oracle DBA's and developers will appreciate the 46 common Oracle dictionary views supported in Postgres Plus Advanced Server. These emulated features allow DBAs to avoid re-training and re-use their Oracle skill set.
- Programming Flexibility and Drivers. EnterpriseDB supports the most common programming languages used to create applications for Oracle. Also, Postgres Plus Advanced Server has built in support for the OCI, assuring you that applications written in C or C++ will still run.
- Migration Tools. Functional compatibility is great but not if the conversion effort is cost prohibitive. Postgres Plus Advanced Server provides automated tools to move Oracle schema, sequences, synomyms, data, indexes, partitions, database links, packages, triggers, stored procedures, functions, users, and roles to Postgres Plus Advanced Server in one step.
- Oracle Replication. Even without migration, you can still reduce your Oracle spend by replicating in near real time to offload reporting chores and improve OLTP response times using Postgres Plus Advanced Server's multi-threaded Oracle replication.
- Reliability and Scalability. Many large scale mission critical Oracle applications have been replaced and are running today using Postgres' renowned OLTP integrity and performance in sophisticated High Availability configurations. And the GridSQL distributed data solution and Infinite Cache distributed memory solution give you multiple options for cost effective horizontal scaling.
- Security Known for having the best security among open source databases, Postgres Plus Advanced Server supports Definer's Rights and Invoker's Rights as well as providing traditional role-based authentication and authorization. Advanced Server even obfuscates source code to hide sensitive, proprietary, or confidential information.
- Tools Compatibility. DBA tools like SQL*Plus, SQL*Loader, DBA Management Server, are all supported in Postgres Plus Advanced Server. These emulated features allow DBAs to avoid re-training and re-use their Oracle skill set. Postgres Studio is a sophisticated DBA and developer's workbench for creating and maintaining databases, browsing data, assigning privileges, debugging, executing SQL, and much more.
For an in depth look at Postgres Plus Advanced Server's Oracle compatibility features refer to the white paper: Delivering Oracle Compatibility , or download the Oracle Compatibility Developer's Guide .

Additional Oracle Resources and Proof

Are you serious about Oracle compatibility? We are! Check out these additional resources:

Oracle Compatibility Resources
	What is Oracle Compatibility? Watch this 10 minute video and discover exactly what Oracle compatibility means from your business, technical, and skills points of view. Created for DBAs, Developers, and IT Managers/Architects, this presentation looks at support for SQL extensions, various features, the PL/SQL language, and tools.
	Delivering Oracle Compatibility This white paper discusses in depth many of the issues that need to be addressed to attain compatibility with Oracle and how this is achieved in Postgres Plus Advanced Server.		Sony Uses Postgres Plus Advanced Server Read about Sony Online Entertainment's use of Postgres Plus Advanced Server to reduce their Oracle spend while supporting their online gaming operations.
	Vonage Reduces Oracle TCO Discover how Vonage lowered their database TCO while captializing on the Oracle compatibility in Postgres Plus Advanced Server.		Oracle Compatibility Developers Guide EnterpriseDB's technical documentation for developers interested in the technical details of Postgres Plus Advanced Server's Oracle compatibility.
	The Case for Lowering Your Oracle TCO Read more about some of the ways Postgres Plus Advanced Server in conjunction with your current Oracle systems can dramatically reduce your total database TCO.		EnterpriseDB the Definitive Reference This book provides an in-depth look at Postgres Plus Advanced Server from an Oracle user's perspective, written by Oracle Ace, Lewis Cunningham. ISBN: 9780977671571
	A Manager's Guide to Oracle Cost Containment This paper identifies popular Oracle cost containment strategies and provides helpful case studies that illustrate how Oracle costs are being managed in the field today.		Migrating Oracle to Postgres Plus Advanced Server This presentation will briefly identify popular Oracle compatibility strategies and database migration.