Advanced Server - Oracle Support

Lower Database Costs

Check out the savings available to you with an open source database strategy from EnterpriseDB:

• Lower Total Cost of Ownership (TCO). Oracle is expensive. Comparable or 'good enough' performing alternatives are available at significantly lower price / performance ratios.
  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%.

Oracle Compatible Database Strategies

Enterprises dependent on Oracle are looking for alternative products and strategies to reduce their dependency and give them clear paths towards a more flexible and cost effective database infrastructure.

• Complimentary Applications.

  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 both your transaction and reporting performance by offloading reporting data from the main transaction database to a replicated reporting database without purchasing additional Oracle licenses. This is a common replication application that fits perfectly with Postgres Plus Advanced Server's capabilities.

• Two tier database strategy.

  Many companies employ a multi-tier database infrastrucutre. By deploying new departmental applications on Advanced Server, you can use existing Oracle skills and assets across the infrastructure including tools, code and objects while reducing costs and utilizing open source.

• Migrate secondary applications.

  There are simply some applications that don't warrrant paying for an Oracle license. Using the Postgres Plus Migration Studio combined with Advanced Server's extensive support for Oracle SQL syntax, PL/SQL for triggers, stored procedures, packages, and functions, you can easily move many applications to a less expensive but equally functional database with little to no re-training.

• Database Flexibility.

  ISVs selling database agnostic applications can increase margins and/or lower prices by replacing their Oracle data store with Postgres Plus Advanced Server. This choice also gives you pricing flexibility and avoids vendor lock-in.

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 categorie

• 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.