A query mediation approach to interoperability of heterogeneous databases

Huang, Ho-Chuan; Kerridge, J.; Chen, Shang-Liang

Abstract

The need to transform queries between heterogeneous databases arises in many circumstances, including query transformation between a global and a local query. This paper describes a query mediation approach to the interoperability of heterogeneous databases. We develop a query mediation architecture that facilitates automated query transformation, which is applicable in many circumstances, such as query transformation in a federated database environment. Different application languages are transformed into intermediate representations that can be processed by the query mediator. The main characteristic of our system is that the query transformation agent, which acts as a mediator, is used to support automated query transformation which protects users from the troublesome task of semantic and representational discrepancies. Two query languages, ODMG-OQL and SQL, have been used to investigate the query mediation architecture.

• Presentation Conference Type: Conference Paper (Published)
• Conference Name: 11th Australasian Database Conference (ADC) 2000
• Start Date: Jan 31, 2000
• End Date: Feb 3, 2000
• Online Publication Date: Aug 6, 2002
• Publication Date: 2000
• Deposit Date: Jul 19, 2019
• Publisher: Institute of Electrical and Electronics Engineers
• Book Title: Proceedings 11th Australasian Database Conference. ADC 2000 (Cat. No.PR00528)
• ISBN: 0769505287
• DOI: https://doi.org/10.1109/adc.2000.819812
• Keywords: query transformation; query mediation; ODMG-OQL; SQL
• Public URL: http://researchrepository.napier.ac.uk/Output/1979685