除Postgres之外，数据库是否具有可与外部数据包装器媲美的功能？ [英] Do databases besides Postgres have features comparable to foreign data wrappers?

问题描述

我对最新添加的Postgres功能（例如外部数据包装程序）感到非常兴奋。我不知道其他任何具有此功能的RDBMS，但是在尝试向我的主要客户提出理由之前，他们应该开始偏爱Postgres，而不是当前的RDBMS，并且在我的情况下，包括其他任何数据库都不能做到这一点，我想验证一下。

I'm very excited by several of the more recently-added Postgres features, such as foreign data wrappers. I'm not aware of any other RDBMS having this feature, but before I try to make the case to my main client that they should begin preferring Postgres over their current cocktail of RDBMSs, and include in my case that no other database can do this, I'd like to verify that.

我无法找到其他任何支持SQL / MED的数据库的证据，像这样的简短注释指出< a href = http://docs.oracle.com/cd/E11882_01/server.112/e26088/ap_standard_sql007.htm#SQLRF55527 rel = noreferrer> Oracle不支持SQL / MED 。

I've been unable to find evidence of any other database supporting SQL/MED, and things like this short note stating that Oracle does not support SQL/MED.

让我怀疑的主要是关于 http://wiki.postgresql.org/wiki/SQL/MED ：

The main thing that gives me doubt is a statement on http://wiki.postgresql.org/wiki/SQL/MED:

SQL / MED是外部管理数据，SQL标准的一部分，涉及数据库管理系统如何集成数据库外部存储的数据。

SQL/MED is Management of External Data, a part of the SQL standard that deals with how a database management system can integrate data stored outside the database.

如果FDW基于SQL / MED，并且SQL / MED是开放式标准，则其他RDBMS似乎也已实现它也。

If FDWs are based on SQL/MED, and SQL/MED is an open standard, then it seems likely that other RDBMSs have implemented it too.

除Postgres之外，是否还有其他数据库支持SQL / MED？

Does any database besides Postgres support SQL/MED?

推荐答案

• IBM DB2 声称符合SQL / MED（包括完整的FDW API）；


• MySQL 的FEDERATED存储引擎可以连接到另一个MySQL数据库，但 不 RDBMS ；


• MariaDB 的CONNECT引擎允许访问各种文件格式（CSV，XML，Excel等），可以访问任何 ODBC数据源（Oracle，DB2，SQLServer等），并且可以访问存储引擎MyIsam和InnoDB。


• 法拉果也有一些；


• PostgreSQL 实现了它的一部分（特别是它不实现常规映射，并且具有简化的FDW API）。从PG 9.1开始，它就可以读取，而从9.3版本开始，它就可以写入。在此之前， DBI-Link 。


• IBM DB2 claims compliance with SQL/MED (including full FDW API);
• MySQL's FEDERATED storage engine can connect to another MySQL database, but NOT to other RDBMSs;
• MariaDB's CONNECT engine allows access to various file formats (CSV, XML, Excel, etc), gives access to "any" ODBC data sources (Oracle, DB2, SQLServer, etc) and can access data on the storage engines MyIsam and InnoDB.
• Farrago has some of it too;
• PostgreSQL implements parts of it (notably it does not implement routine mappings, and has a simplified FDW API). It is usable as readeable since PG 9.1 and writeable since 9.3, and prior to that there was the DBI-Link.

PostgreSQL社区有很多不错的 FDW ，例如noSQL FDW（couchdb_fdw，mongo_fdw，redis_fdw），Multicorn（用于使用Python输出本身而不是C作为包装器本身）或螺母 PGStrom （使用GPU进行某些操作！）

PostgreSQL communities have a plenty of nice FDW like noSQL FDW (couchdb_fdw, mongo_fdw, redis_fdw), Multicorn (for using Python output instead of C for the wrapper per se), or the nuts PGStrom (which uses GPU for some operations!)

这篇关于除Postgres之外，数据库是否具有可与外部数据包装器媲美的功能？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！