New Postgres Database Extends Oracle Compatibility
EnterpriseDB this week rolled out a new release of its Postgres Plus Advanced Server, augmenting its compatibility with Oracle databases.
Postgres Plus Advanced Server is a commercial offering based on the open source PostgreSQL database. The new version is its fifth. EnterpriseDB has pitched its flagship offering to companies looking to migrate applications written to Oracle databases.
"Our customer base has been growing rapidly and I think it's in direct response to the economic pressure IT shops have been feeling," said EnterpriseDB CEO Ed Boyajian.
The platform is suitable for developers experienced in writing stored procedures for Oracle databases, added Jim Mlodgenski, EnterpriseDB's chief architect.
"As you are developing your stored procedures using Oracle object types, they would develop in the same fashion as they would in Oracle as they would in Postgres Plus Advanced Server," Mlodgenski said.
It offers improved support for Oracle object types and packages, as well as tools that ease the migration of Oracle schema, data and stored procedures, Mlodgenski said
A feature called Explicit Transaction Control mimics the behavior of how Oracle handles writing rows to disk. "We've gone very deep and more subtle in the Oracle compatibility and really focusing on Oracle behaviors," he said.
Another new feature is the addition of a distributed in-memory cache with the aim of boosting scalability. Called Infinite Cache, it sits behind the database rather than in front of it.
"This way, you are able to leverage the simple SQL interface into the database in order to access the distributed memory cache," Mlodgenski said. "The database will handle the synchronization of the data on disk and what's in that cache and handle the management overhead."
The new database also offers improved security via support for LDAP and the pluggable authentication module (PAM), he said. "It allows for common log-ins, making it a lot easier," he said.
The database is offered on a subscription basis starting at $1,995 per socket, per year.
About the Author
Jeffrey Schwartz is editor of Redmond magazine and also covers cloud computing for Virtualization Review's Cloud Report. In addition, he writes the Channeling the Cloud column for Redmond Channel Partner. Follow him on Twitter @JeffreySchwartz.