EnterpriseDB (EDB), a leading provider of enterprise-class Postgres products and Oracle database compatibility solutions, has 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 in silos residing in MongoDB deployments more useful by integrating it 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.
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.
Sign up for the free insideAI News newsletter.