The SQL/MED ("Management of External Data") extension to the
SQL standard is defined by
ISO
ISO is the most common abbreviation for the International Organization for Standardization.
ISO or Iso may also refer to: Business and finance
* Iso (supermarket), a chain of Danish supermarkets incorporated into the SuperBest chain in 2007
* 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
In the pursuit of knowledge, data (; ) is a collection of discrete Value_(semiotics), values that convey information, describing quantity, qualitative property, quality, fact, statistics, other basic units of meaning, or simply sequences of sy ...
. External data is data that is accessible to, but not managed by, an SQL-based
DBMS
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...
. This standard can be used in the development of
federated database system A federated database system (FDBS) is a type of meta- database management system (DBMS), which transparently maps multiple autonomous database systems into a single federated database. The constituent databases are interconnected via a computer netw ...
s.
Implementations
*
PostgreSQL has support for some SQL/MED since version 9.1.
*
LucidDB has support for SQL/MED.
*
MariaDB
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the ori ...
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.
Teiid Documentation
/ref>
See also
* SQL
* SQL:2008
* SQL:2003
References
External links
SQL/MED - A Status Report
SQL
{{database-stub