Software // Information Management
04:59 PM
Connect Directly
IoT & Insurance: How Big Data May Affect Your Privacy & Premiums
May 06, 2016
Gwenn Bezard is co-founder and research director at Aite Group, where he leads the insurance pract ...Read More>>

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.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
4 Trends Shaping Digital Transformation in Insurance
Insurers no longer have a choice about digital adoption if they want to remain relevant. A comprehensive enterprise-wide digital strategy is fundamental to doing business today.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of April 24, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week!
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.