SQL/MED
{{Short description|Structured Query Language standard}}
The SQL/MED ("Management of External Data") extension to the SQL standard is defined by ISO/IEC 9075-9:2008 (originally defined for SQL:2003). SQL/MED provides extensions to SQL that define foreign-data wrappers and datalink types to allow SQL to manage external data. External data is data that is accessible to, but not managed by, an SQL-based DBMS. This standard can be used in the development of federated database systems.
Implementations
- PostgreSQL has support for some SQL/MED since version 9.1.[http://wiki.postgresql.org/wiki/SQL/MED PostgreSQL Wiki: SQL/MED][https://www.postgresql.org/docs/current/ddl-foreign-data.html Chapter 5.12, "Foreign Data" of the PostgreSQL Guide].
- LucidDB has support for SQL/MED.[http://www.luciddb.org/html/arch.html LucidDB Architecture]
- MariaDB has support for SQL/MED with the CONNECT storage engine.[https://mariadb.com/kb/en/connect/ CONNECT storage engine] The implementation uses different syntax than the official standard.
- Farrago has support for SQL/MED.[http://farrago.sourceforge.net/design/sqlmed.html Farrago SQL/MED Support]
- IBM Db2 has support for SQL/MED.[http://www.ibm.com/developerworks/data/library/techarticle/0203haas/0203haas.html IBM federated database technology]
- Teiid has support for SQL/MED. [https://github.com/teiid/teiid-documents/blob/master/reference/ddl_deployment_mode.adoc Teiid Documentation]
- Microsoft SQL Server has internal support for SQL/MED. DATALINK is provided by the FILESTREAM[https://learn.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server FILESTREAM] (SQL Server 2008) and FileTable (SQL Server 2012) functionnalities and external data wrapper by the EXTERNAL TABLEs and PolyBase[https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql EXTERNAL TABLE / PolyBase]
See also
References
External links
- [https://sigmodrecord.org/publications/sigmodRecord/0209/jimmelton.pdf SQL/MED - A Status Report]
{{SQL}}
{{DEFAULTSORT:SQL MED}}
{{database-stub}}