EnterpriseDB Bidding For Customers With Oracle Compatibility - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Government // Enterprise Architecture
News
6/17/2009
07:00 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

EnterpriseDB Bidding For Customers With Oracle Compatibility

Postgres Plus Advanced Server's latest retooling could make it easier for existing Oracle users to migrate a reporting or transaction application.

At a time of slowing commercial database sales, EnterpriseDB this week announced it is adding features to its Postgres Plus Advanced Server and turning up the volume on its compatibility with Oracle's popular database system.

EnterpriseDB is the commercial firm formed to capitalize on PostgreSQL, an open source relational database project. It's maintained a lower profile than the highly successful MySQL, but PostgreSQL is distinguished by its high degree of ANSI standard SQL compliance and enterprise system features. EnterpriseDB has added Oracle compatibility, such as an ability to field PL/SQL queries, on top of the standard relational system and sells it as Postgres Plus Advanced Server.

Now it's going further on the Oracle compatibility front with Advanced Server 8.3, Release 2. "We're focused on broadening our offering to a wider swath of companies," said Ed Boyajian, CEO of the Westford, Mass., company, in an interview.

Part of that effort is making it easier for existing Oracle users to migrate a reporting or transaction application from Oracle to Postgres Plus.

"The LA Times moved an Oracle reporting application to Postgres. We've widened the on-ramp," said Boyajian.

The way it's doing so is to building into Postgres Plus an ability to duplicate the way Oracle handles transaction success or recovery from a transaction failure. Each database system handles the process a little differently, and Oracle-based applications understand how Oracle does it.

"We actually mimic the behavior of Oracle in how it handles transaction success or failure," said Jim Mlodgenski, Advanced Server's chief architect.

Postgres Plus Advanced Server's PL/SQL support already means it can run Oracle database triggers and stored procedures. In 8.3 Release 2, additional SQL extensions, such as DUAL Table, supported by Oracle are now supported by Advanced Server. DBLinks and Oracle Catalog Views are also supported by Advanced Server.

Boyajian said 300 customers had downloaded and tested the release prior to its becoming generally available June 16.

The release also includes additional built-in packages to make execute certain Oracle-compatible functions connected with database operations, including the ability to schedule a job, print out a screen or send displayed results as e-mail.

"We've added the top used 10% to 20%" of such functions; they number over 100 in Oracle, said Mlodgenski.

In previous releases, Postgres Plus included push-button migration, where a database administrator, after designating the target Oracle application, could convert schema, data packages, triggers, stored procedures, and functions into a Postgres application.

Postgres Plus Advanced Server is the high end of EnterpriseDB's commercial product line. A license is priced at $4,495 per socket on a four-way server, with a total price of $17,980.


InformationWeek has published an in-depth report on application development. Download the report here (registration required).

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Slideshows
IT Careers: Top 10 US Cities for Tech Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  1/14/2020
Commentary
Predictions for Cloud Computing in 2020
James Kobielus, Research Director, Futurum,  1/9/2020
News
What's Next: AI and Data Trends for 2020 and Beyond
Jessica Davis, Senior Editor, Enterprise Apps,  12/30/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Slideshows
Flash Poll