Producing Interoperable Queries for Relational and Object-Oriented Databases

Authors: Chang Y-H.¹; Raschid L.²

Source: Journal of Intelligent Information Systems, Volume 14, Number 1, March 2000 , pp. 51-75(25)

Publisher: Springer

Buy & download fulltext article:

Price: $47.00 plus tax (Refund Policy)

Abstract:

In this paper, we develop techniques to produce interoperable queries with object and relational databases. A user poses a local query in a local query language, against a local object or relational schema. We transparently produce appropriate queries with respect to a remote target object or relational schema, corresponding to some remote database which contains data relevant to the user's query. Mapping knowledge to resolve representational heterogeneities in local and remote schemas is expressed in a canonical representation, CRmapping, and is independent of the particular data model. A canonical representation CRquery is also used to resolve heterogeneities of query languages. A set of heterogeneous transformation algorithms define the appropriate transformations from the local queries to the remote queries. The use of canonical representations (CR) allows us to represent queries independent of the particular query language, and to resolve representational conflicts in a uniform manner, independent of models and query languages.

Keywords: heterogeneous databases; interoperable query processing; canonical representations; representational conflicts; wrappers

Language: English

Document Type: Regular paper

Affiliations: 1: Department of Computer Science, National Taiwan Ocean University, Taiwan, Republic of China. yahui@cs.ntou.edu.tw 2: Smith School of Business and UMIACS, University of Maryland, USA. louiqa@umiacs.umd.edu

Publication date: 2000-03-01