Channels ▼
RSS

Database

EnterpriseDB Extends Postgres' Big Data Capacity


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.


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Video