SchemaSQL - An Extension to SQL for Multi-database Interoperability (0)
| Venue: | ACM Transactions on Database Systems |
| Citations: | 27 - 1 self |
BibTeX
@ARTICLE{Lakshmanan_schemasql-,
author = {Laks V.S. Lakshmanan and Fereidoon Sadri and Subbu N. Subramanian},
title = {SchemaSQL - An Extension to SQL for Multi-database Interoperability},
journal = {ACM Transactions on Database Systems},
year = {},
volume = {26},
pages = {2001}
}
Years of Citing Articles
Bookmark
 |
 |
 |
 |
 |
 |
OpenURL
Abstract
We provide a principled extension of SQL, called SchemaSQL, that offers the capability of uniform manipulation of data and schema in relational multi-database systems. We develop a precise syntax and semantics of SchemaSQL in a manner that extends traditional SQL syntax and semantics, and demonstrate the following. (1) SchemaSQL retains the flavor of SQL while supporting querying of both data and schema. (2) It can be used to transform data in a database in a structure substantially different from original database, in which data and schema may be interchanged. (3) It also permits the creation of views whose schema is dynamically dependent on the contents of the input instance. (4) While aggregation in SQL is restricted to values occurring in one column at a time, SchemaSQL permits "horizontal" aggregation and even aggregation over more general "blocks" of information. (5) SchemaSQL provides a useful facility for interoperability and data/schema manipulation in relational mul...
