Quire

SQL/MED

From Quire, the open reference·Structured Query Language standard·1 min read

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#edit

  • PostgreSQL has support for some SQL/MED since version 9.1.[1][2]
  • LucidDB has support for SQL/MED.[3]
  • MariaDB has support for SQL/MED with the CONNECT storage engine.[4] The implementation uses different syntax than the official standard.
  • Farrago has support for SQL/MED.[5]
  • IBM Db2 has support for SQL/MED.[6]
  • Teiid has support for SQL/MED.[7]
  • Microsoft SQL Server has internal support for SQL/MED. DATALINK is provided by the FILESTREAM[8] (SQL Server 2008) and FileTable (SQL Server 2012) functionnalities and external data wrapper by the EXTERNAL TABLEs and PolyBase.[9]

See also#edit

References#edit

  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


Categories SQLDatabase stubs

This article is mirrored from “SQL/MED” on English Wikipedia, revision 1371078351, written by Wikipedia's contributors and licensed CC BY-SA 4.0. Editing it here creates a Quire copy with its own history.

Synced with Wikipedia revision 1371078351 · just now