Follow Datanami:
July 24, 2014

EnterpriseDB Extends Postgres’ Big Data Capacity With New MongoDB, Hadoop Extensions

BEDFORD, Mass., July 24 — EnterpriseDB (EDB), the leading worldwide provider of enterprise-class Postgres products and Oracle database compatibility solutions, today announced the first release of two new extensions that expand PostgreSQL’s ability to seamlessly integrate information from big data and NoSQL-only solutions. Providing a single view of data across multiple sources breaks down barriers between the siloes created by big data and NoSQL-only solutions and deepens end user insight into their data.

EDB has released an updated Foreign Data Wrapper (FDW) for MongoDB to the open source PostgreSQL community and is planning to release one for Hadoop in fall. The Foreign Data Wrappers take advantage of expanded capabilities that were introduced in PostgreSQL v9.3. EDB further optimized the MongoDB FDW for performance and long-term code stability through the use of the new MongoDB Meta Driver.

“Specialized database technologies that target a single problem can be useful in some cases. But they introduce complexity into the enterprise data environment by creating data silos that erode corporate standards in application logic,” said Marc Linster, senior vice president, products and services, at EnterpriseDB. “The new Foreign Data Wrapper makes data silos residing in MongoDB deployments more useful by integrating the data with the enterprise database management systems. This provides a seamless experience for gaining deeper insight from a greater variety of data types and eases data governance problems.”

As new data technologies and solution sources emerged, developers in the open source community built capabilities for using Postgres to work with data from outside sources. Foreign Data Wrappers were made possible in 2011 with the release of PostgreSQL 9.1, which featured support for the ANSI SQL Standard implementation of SQL/MED (SQL Management of External Data). FDWs enable users to integrate structured and unstructured data within their Postgres databases, where they can read and write SQL queries to foreign data sources.

Datanami