SQL open heterogeneous data access

We describe the open, extensible architecture of SQL for accessing data stored in external data sources not managed by the SQL engine. In this scenario, SQL engines act as middleware servers providing access to external data using SQL DML statements and joining external data with SQL tables in heter...

Full description

Bibliographic Details
Published in:ACM SIGMOD Record
Main Authors: Reinwald, Berthold, Pirahesh, Hamid
Format: Article in Journal/Newspaper
Language:English
Published: Association for Computing Machinery (ACM) 1998
Subjects:
DML
Online Access:http://dx.doi.org/10.1145/276305.276356
https://dl.acm.org/doi/pdf/10.1145/276305.276356
Description
Summary:We describe the open, extensible architecture of SQL for accessing data stored in external data sources not managed by the SQL engine. In this scenario, SQL engines act as middleware servers providing access to external data using SQL DML statements and joining external data with SQL tables in heterogeneous queries. We describe the state-of-the art in object-relational systems and their companion products, and provide an outlook on future directions.