SQL/MED

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.
LucidDB has support for SQL/MED.
MariaDB has support for SQL/MED with the CONNECT storage engine. The implementation uses different syntax than the official standard.
Farrago has support for SQL/MED.
IBM Db2 has support for SQL/MED.
Teiid has support for SQL/MED.
Microsoft SQL Server has internal support for SQL/MED. DATALINK is provided by the FILESTREAM (SQL Server 2008) and FileTable (SQL Server 2012) functionnalities and external data wrapper by the EXTERNAL TABLEs and PolyBase.

References

External links

SQL/MED - A Status Report

This database-related article is a stub. You can help Wikipedia by adding missing information.

[1] PostgreSQL Wiki: SQL/MED

[2] Chapter 5.12, "Foreign Data" of the PostgreSQL Guide.

[3] LucidDB Architecture

[4] CONNECT storage engine

[5] Farrago SQL/MED Support

[6] IBM federated database technology

[7] Teiid Documentation

[8] FILESTREAM

[9] EXTERNAL TABLE / PolyBase

v t e SQL
Versions	SEQUEL SQL-86 SQL-89 SQL-92 SQL:1999 SQL:2003 SQL:2006 SQL:2008 SQL:2011 SQL:2016 SQL:2023
Keywords	As Case Create Delete From Group by Having Insert Join Merge Null Order by Over Prepare Select Truncate Union Update With
Related	Edgar Codd Relational database
ISO/IEC SQL parts	Framework Foundation Call-Level Interface Persistent Stored Modules Management of External Data Object Language Bindings Information and Definition Schemas SQL Routines and Types for the Java Programming Language XML-Related Specifications

SQL/MED

Implementations

See also

References

External links