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.
Cotton seedling freezes to death as Chang'e-4 shuts down for the Moon's 14-day lunar night
Fortnite easily out-earns PUBG, Assassin's Creed Odyssey and Red Dead Redemption 2 in 2018
Meteor showers as a service will be visible for about 100 kilometres in all directions
Saturn's rings only formed in the past 100 million years, suggests analysis of Cassini space probe data
New findings contradict conventional belief that Saturn's rings were formed along with the planet about 4.5 billion years ago