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
Commentary
AI Regulation: Has the Time Arrived?
John Edwards, Technology Journalist & Author,  2/24/2020
News
Fighting the Coronavirus with Analytics and GIS
Jessica Davis, Senior Editor, Enterprise Apps,  2/3/2020
Slideshows
IT Careers: 10 Job Skills in High Demand This Year
Cynthia Harvey, Freelance Journalist, InformationWeek,  2/3/2020
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
IT Careers: Tech Drives Constant Change
Advances in information technology and management concepts mean that IT professionals must update their skill sets, even their career goals on an almost yearly basis. In this IT Trend Report, experts share advice on how IT pros can keep up with this every-changing job market. Read it today!
Slideshows
Flash Poll