Jump to content

SQL/MED

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Dveeden (talk | contribs) at 12:16, 8 May 2014 (→Implementations). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The SQL/MED, or Management of External Data, extension to the SQL standard is defined by ISO/IEC 9075-9: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]

See also

References

  1. ^ PostgreSQL Wiki: SQL/MED
  2. ^ LucidDB Architecture
  3. ^ CONNECT storage engine
  4. ^ SQL/MED Support


Stub icon

This database-related article is a stub. You can help Wikipedia by expanding it.

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