EnterpriseDB Upgrades Postgres Plus Advanced Server - 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
Software // Information Management
News
7/28/2010
04:59 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

EnterpriseDB Upgrades Postgres Plus Advanced Server

The 8.4 version includes protection against SQL injection attacks and compatibility features to make it easier to migrate Oracle applications.

EnterpriseDB has issued the 8.4 version of Postgres Plus Advanced Server, the commercial relational database system based on the open source PostgreSQL project.

It includes new protection against SQL injection attacks, enhanced Oracle compatibility characteristics and other features.

Postgres Plus is in its sixth iteration of Oracle compatibility, which allows it to run applications written for the Oracle database with few changes. It includes the ability to recognize the Oracle developers' version of the data access language, PL/SQL, and the triggers and stored procedures used by the application.

In Release 8.4, the system's compatibility with Oracle applications has moved, on a scale of 1-10, from 8.4 in the previous Postgres Plus edition to 9.5 compatibility rating with the 8.4 release, said Ed Boyajian, CEO of EnterpriseDB, in the announcement. EnterpriseDB created the scale as a measurement of five areas of database operation.

In response to an email query seeking examples, Postgres Plus technicians said one compatibility addition is support for PL/SQL's User Defined Exceptions and the RAISE command, which raises a User Defined Exception to make it explicitly stated in a logic sequence. Adding the support eliminates what was previously a manual rewriting step in migrating an application to Postgres Plus, the spokesmen said.

The release also supports the Oracle GoTo statement, Reverse for Loop statement, and Public Synonyms for Functions, Stored Procedures, along with other additions, the spokesmen said.

The injection attack protection, called SQL/Protect, provides query learning and enforcement modes that give the database administrator new powers to guard against malicious queries. DBAs can identify the nature of an attack query and apply a ban on its use. Protecting against SQL injection attacks is usually a responsibility of application programmers.

Release 8.4 also includes StackBuilder Plus, an installation management tool that allows users to add new features to Postgres Plus. StackBuilder ensures that additions are integrated with existing modules and tests the installation. EnterpriseDB used StackBuilder to add PostgresPlus HQ, a database infrastructure monitoring tool that can check 160 throughput, performance, availability and utilization metrics for Postgres databases. It can alert DBAs on out-of-bounds conditions that it finds.

StackBuilder was also used to add xDB Replication Server, which allows an organization to offload Oracle reporting tasks from a transaction server, create a warm standby server or use xDB Replication Server to migrate data to new Postgres Plus system.

Boyajian said EnterpriseDB is aiming to supply "an enterprise class alternative to expensive proprietary databases." The changes in the 8.4 release "are designed to simplify the deployment, integration, usability and management" of Postgres Plus databases, he said. An annual developer subscription for Postgres Plus Standard edition is $4,995; one for production systems is $2,995 per socket. No pricing is listed on the Web site for Postgres Plus Advanced Server; visitors are advised to contact the sales staff.

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
What Digital Transformation Is (And Isn't)
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/4/2019
Commentary
Watch Out for New Barriers to Faster Software Development
Lisa Morgan, Freelance Writer,  12/3/2019
Commentary
If DevOps Is So Awesome, Why Is Your Initiative Failing?
Guest Commentary, Guest Commentary,  12/2/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