EnterpriseDB: Oracle Compatibility and Enterprise Performance on a PostgreSQL Foundation
Novell Cool Solutions: Feature
By Derek Rodner
Digg This -
Posted: 24 Apr 2006
Many enterprises interested in the benefits of open source software find relational databases to be a particularly appealing starting point for their open source deployments. This is largely because the most popular proprietary alternatives are stratospherically overpriced, especially for large deployments, and they are unnecessarily complex to deploy, run, and maintain. In addition, the best open source databases have stable and mature code bases and, in the case of truly enterprise-class products, offer easy migration paths from existing proprietary installations.
Of the available open source database offerings, PostgreSQL has long been considered to offer the most comprehensive feature set and to be the most suitable for high-volume, mission-critical enterprise applications. The speed and scalability of PostgreSQL make it a natural choice for transactional applications of all kinds, and its implementation of advanced database features, such as triggers, views, and stored procedures, is mature and stable.
EnterpriseDB amplifies the benefits of PostgreSQL by adding to it four features that are critically important to enterprise users, but not available from the PostgreSQL community. First, EnterpriseDB is a reliable, accountable company - not a loosely organized community of developers - from which customers can acquire the database and associated services. Second, EnterpriseDB has extended PostgreSQL to enable it to run database applications written for Oracle. Next, EnterpriseDB has significantly increased PostgreSQL's run-time performance. Finally, EnterpriseDB provides professional-quality tools for use with the database.
A Company, Backed by a Powerful Community
An enterprise that obtains open source software directly from the open source community suddenly has a lot of responsibility. For example, the enterprise must proactively retrieve upgrades and patches from the public source code repository and install them itself, often without the benefit of convenient installation packages. The enterprise must also attempt, via online discussion forums and otherwise, to establish relationships with the many individual developers to whom the enterprise will likely turn for advice, fixes, and new features.
EnterpriseDB provides organizations seeking the benefits of PostgreSQL backed by a commercial vendor relationship, relieving them of these and other burdensome responsibilities. EnterpriseDB provides:
- Automatic software upgrades
- Maintenance patches with convenient install packages
- 24x7 commercial-grade technical support via phone, email, and forums
- Professional QoS specifications, SLAs, and escalation procedures
- On-demand training and other professional services
A database that is compatible with other popular database products and with industry standards lowers cost by leveraging existing applications and existing skill sets, reduces risk by avoiding vendor lock-in, and eliminates migration difficulties.
EnterpriseDB runs most applications written for Oracle unchanged, virtually eliminating the great expense and the risk of failure typically associated with technology migration. Enterprise-class features, including PL/SQL syntax, cursors, data types, triggers, stored procedures, and views are the same in EnterpriseDB as they are in Oracle. Any Oracle developer or DBA can work with EnterpriseDB without retraining, and EnterpriseDB's tools will be immediately familiar to them. Of course, applications written for EnterpriseDB can also be run on an Oracle database at any time.
EnterpriseDB is also compatible with all PostgreSQL applications and with the ANSI-SQL standard. There are versions of EnterpriseDB for Windows, Linux (Red Hat and SUSE, both 32-bit and 64-bit), Solaris (SPARC and x86) and Mac OS/X, and there are connectors to the most popular programming environments, including Java JDBC, .NET+MONO, ODBC +unixODBC, native C/C++ (libpq), C/C++ interpreter (Ch), Perl5 DBI, Python and PHP.
A database that is suitable for enterprise applications must be highly scalable: simply put, it needs to be really fast, both in high-volume transactional environments and when working with massive amounts of data.
EnterpriseDB is a combination of PostgreSQL - widely regarded as the open source database most suitable for on-line transaction processing (OLTP) - and significant enhancements, including installation-specific dynamic optimization, that provide performance that is generally at least 50% faster than native PostgreSQL.
When EnterpriseDB is installed, it automatically optimizes itself, yielding performance that competes with expensive commercial databases and far exceeds popular open source databases in typical transactional scenarios.
EnterpriseDB also includes integrated database replication capabilities - based on the open source SLONY-I project - that provide workload distribution, enable failover protection, and allow sophisticated reporting, decision support, and remote access, all without compromising performance.
EnterpriseDB provides a comprehensive set of tools to assist EnterpriseDB developers and DBAs. They include:
- DBA Management Server - Monitoring, performance profiling, and reporting
- Developer Studio - Graphical console for developers and DBAs
- Procedural Language Debugger - Interactive debugger for stored procedures
- Client Connectors - Access from various programming environments
- Oracle Migration Toolkit - Transfer schemas, logic, and data to EnterpriseDB
- Reporting Tools - JasperReports engine and graphical report designerEnterpriseDB DBA Management Server, which is a powerful database monitoring, profiling, reporting, and querying tool that enables DBAs and developers to analyze, manage, and tune any number of EnterpriseDB or PostgreSQL databases from a single Web browser. DBA Management Server also delivers richly formatted reports in both HTML and PDF formats.
- EnterpriseDB Procedural Language (PL) Debugger, which can be used to develop and analyze stored procedures, functions, and triggers in applications written for EnterpriseDB, Oracle, and PostgreSQL databases. The EnterpriseDB Procedural Language Debugger allows developers to step through code one line at a time as it executes, to set and remove conditional breakpoints, to watch and modify variables, to view the execution stack, and more.
- EnterpriseDB Developer Studio, which is a commercial-quality, cross-platform developer and DBA console. EnterpriseDB Developer Studio looks and behaves like the tools enterprise database professionals use today, so little or no training is required.
- A migration toolkit, which makes the transition from Oracle to EnterpriseDB even easier.
Learn More About EnterpriseDB
More information and free downloads of EnterpriseDB's flagship product, EnterpriseDB Advanced Server, are available at www.enterprisedb.com.
33 Wood Avenue South
Iselin, NJ 08830
Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com