Recent big data news showed finally there was some recognition by Oracle that enterprises might have more than one database vendor in their environments. And these organizations might need to use specialized, NoSQL niche solutions to address special problems. Voila, one version of Oracle’s pricey database can now interact with two—just two—open source solutions.
It was a day of Oracle playing catch-up with Postgres.
The Postgres community has long recognized the need for databases to integrate. EnterpriseDB’s introduction of connectors to Oracle databases came first, followed by the introduction in PostgreSQL v9.1 of support for the SQL standard SQL/MED (SQL Management of External Data). This made way for the development of Foreign Data Wrappers, which enables end users to integrate structured and unstructured data from external databases with Postgres. Postgres has Foreign Data Wrappers for CouchDB, Informix, MongoDB, 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 even Twitter.
Where There’s a Need, There’s a Wrapper
As new data sources emerged, developers in the community built capabilities for using Postgres to work with data from outside sources. Foreign Data Wrappers enable Postgres to read and write queries with foreign data sources so that end users can leverage the strength of an ACID-compliant (more…)Tweet