Jump to content

SQL/MED

From Wikipedia, the free encyclopedia

TheSQL/MED( "Management of External Data" ) extension to theSQLstandard is defined byISO/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 externaldata.External data is data that is accessible to, but not managed by, an SQL-basedDBMS.This standard can be used in the development offederated database systems.

Implementations

[edit]
  • PostgreSQLhas support for some SQL/MED since version 9.1.[1][2]
  • LucidDBhas support for SQL/MED.[3]
  • MariaDBhas support for SQL/MED with the CONNECT storage engine.[4]The implementation uses different syntax than the official standard.
  • Farragohas support for SQL/MED.[5]
  • IBM Db2has support for SQL/MED.[6]
  • Teiidhas support for SQL/MED.[7]
  • Microsoft SQL Serverhas 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
[edit]


Stub icon

Thisdatabase-related article is astub.You can help Wikipedia byexpanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL/MED&oldid=1218255960"