Postgres products and Oracle database compatibility company has announced two new extensions that bid to expand PostgreSQL’s ability to integrate information from big data and NoSQL-only solutions.
EnterpriseDB 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 autumn. The Foreign Data Wrappers take advantage of capabilities that were introduced in PostgreSQL v9.3.
The firm also 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 in silos residing in MongoDB deployments more useful by integrating it with the enterprise database management systems. This 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.
Postgres has Foreign Data Wrappers for MongoDB, CouchDB, Informix, MySQL, Neo4j, Oracle, Redis, and others. They can map to the JDBC, LDAP, and ODBC interfaces and work with such non-traditional data sources as files, HTTP, Amazon’s S3, and Twitter.