Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted June 30, 2011

EnterpriseDB Extends PostgreSQL for Itanium

By Sean Michael Kerner

Enterprise giant Oracle (NASDAQ: ORCL) has been warning its users this year that it plans to abandon the Intel Itanium architecture that powers HP's (NYSE: HPQ) Unix operating system. While Oracle isn't interested in supporting Itanium, others are.

EnterpriseDB today announced Postgres Plus Advanced Server 9.0, which provides Oracle compatibility and now supportS HP-UX on Itanium.

The Postgres Plus Advanced Server 9.0 builds on EnterpriseDB's Postgres Plus Standard 9.0 server release which debuted in January. Sitting at the core of EnterpriseDB's offerings is the open source PostgreSQL 9 release that was released to the community in September 2010.

"With 9.0 you can run Postgres Plus Advanced Server on HP Itanium," Robin Schumacher, director of product strategy at EnterpriseDB, told InternetNews.com. "We've talked to a number of HP customers that were not happy that Oracle is forcing them to switch out and they're looking for a database alternative and we can now give them that."

In addition to the new HP-UX support, Schumacher noted that EnterpriseDB is also adding support for Microsoft SQL Server replication as well. The SQL Server support is limited to replication and is not a compatibility layer, as is the case with Postgres Plus Advanced Server's support for Oracle databases.

"What our tool does is it goes into the databases that the user identifies to be replicated and it creates code objects that are responsible for the actual replication," Schumacher, said. "So it's not the same as our Oracle compatibility, we're just basically going in and when data objects change, we replicate them over to our system."

Schumacher added that the system provides for scheduling configuration so users can determine how often data is replicated.

Overall the new Postgres Plus Advanced Server 9.0 release also includes additional performance enhancements over its predecessors. One such improvement comes from the new parallel data loader.

"We've had a high speed load for a while that has mirrored what Oracle does but it has never done parallel operations," Schumacher said. "By adding this we're seeing an 800 to 1,200 percent performance gain depending on how people slice and dice their data."

There are also new utilities to help admins troubleshoot system performance. Schumacher noted that there is now an Index Advisor that is a smart utility that will recommend if new indexes are required on the underlying tables to improve performance. The Index Advisor can also provide forecasts on what the actual improvement will be as well as giving the admin the code required to implement the new index.

Additionally there is a new Code Profiler in the 9.0 release.

"This is for developers that are writing large stored procedures or functions with thousands of lines of code to help understand performance issues," Schumacher said. "It profiles the code and identifies the bottlenecks inside the stored procedures and highlight where time is being spent."

Sean Michael Kerner is a senior editor at InternetNews.com the news service of Internet.com, the network for technology professionals.



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM