Database firm EnterpriseDB is expanding the ability of the open-source PostgreSQL database to integrate information from big data and NoSQL sources with foreign data wrappers for MongoDB and Hadoop. The move will provide a single view of data across multiple sources for users, the firm said.
EnterpriseDB, which offers enterprise-class products and services based on PostgreSQL, said it has today released the foreign data wrapper for MongoDB to the open source PostgreSQL community, and plans to release one for Hadoop in the autumn.
Foreign data wrappers are extensions that enable a PostgreSQL database to run queries and get data from external sources, made possible with the release of PostgreSQL 9.1 back in 2011. However, the two new wrappers take advantage of expanded capabilities that were introduced in PostgreSQL v9.3, according to EnterpriseDB.
The MongoDB support is an updated foreign data wrapper that implements these expanded capabilities, as well as optimisations for performance and long-term code stability.
Marc Linster, senior vice president of products and services at EnterpriseDB, said linking PostgreSQL with MongoDB and Hadoop in this way enabled these specialised data platforms to be accessed with the same governance controls.
"The new foreign data wrapper makes data siloes 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," he said.
EnterpriseDB is not the only data-management firm looking to unify unstructured data with existing database tools. Earlier this month, Oracle unveiled its Oracle Big Data SQL option for its Big Data Appliance platform, and in June big data specialist Actian unveiled its Actian Analytics Platform-Hadoop SQL Edition.
PostgreSQL now has foreign data wrappers for MongoDB, CouchDB, Informix, MySQL, Neo4j, Oracle, Redis and others, according to EnterpriseDB.
Dubbed Barnard's star B, newly discovered planet is believed to be rocky
Also, what's a USB stick?
Gravitational waves become extremely weak by the time they reach the Earth and require highly sensitive equipment for detection
The reactor topped out at 100 million° C