Producing Interoperable Queries for Relational and Object-OrientedDatabases

  • Authors:
  • Ya-Hui Chang;Louiqa Raschid

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

  • Venue:
  • Journal of Intelligent Information Systems
  • Year:
  • 2000

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper, we develop techniques to produce interoperable querieswith object and relational databases. A user poses a local query ina local query language, against a local object or relational schema.We transparently produce appropriate queries with respect to a remotetarget object or relational schema, corresponding to some remotedatabase which contains data relevant to the user's query. Mappingknowledge to resolve representational heterogeneities in local andremote schemas is expressed in a canonical representation, CRmapping,and is independent of the particular data model. A canonicalrepresentation CRquery is also used to resolve heterogeneities ofquery languages. A set of heterogeneous transformation algorithmsdefine the appropriate transformations from the local queries to theremote queries. The use of canonical representations (CR) allows usto represent queries independent of the particular query language,and to resolve representational conflicts in a uniform manner,independent of models and query languages.