SQL/MED

The SQL/MED, or 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. 9.2 supports more.^[1]
LucidDB has support for SQL/MED.^[2]
MariaDB has support for SQL/MED with the CONNECT storage engine.^[3] The implementation uses different syntax than the official standard.
Farrago has support for SQL/MED.^[4]
IBM DB2 has support for SQL/MED.^[5]

References

External links

SQL/MED - A Status Report

SQL

Versions	SQL-86 SQL-89 SQL-92 SQL:1999 SQL:2003 SQL:2006 SQL:2008 SQL:2011

Keywords	As Case Create Delete From Having Insert Join Merge Null Order by Prepare Select Truncate Union Update Where 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

This article is issued from Wikipedia - version of the 7/21/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.

SQL/MED

Implementations

See also

References

External links