Skip to main content
Log in

Approximate query mapping: Accounting for translation closeness

  • Special section
  • Published:
The VLDB Journal Aims and scope Submit manuscript

Abstract.

In this paper we present a mechanism for approximately translating Boolean query constraints across heterogeneous information sources. Achieving the best translation is challenging because sources support different constraints for formulating queries, and often these constraints cannot be precisely translated. For instance, a query [score>8] might be “perfectly” translated as [rating>0.8] at some site, but can only be approximated as [grade=A] at another. Unlike other work, our general framework adopts a customizable “closeness” metric for the translation that combines both precision and recall. Our results show that for query translation we need to handle interdependencies among both query conjuncts as well as disjuncts. As the basis, we identify the essential requirements of a rule system for users to encode the mappings for atomic semantic units. Our algorithm then translates complex queries by rewriting them in terms of the semantic units. We show that, under practical assumptions, our algorithm generates the best approximate translations with respect to the closeness metric of choice. We also present a case study to show how our technique may be applied in practice.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Similar content being viewed by others

Author information

Authors and Affiliations

Authors

Additional information

Received: 15 October 2000 / Accepted: 15 April 2001 Published online: 28 June 2001

Rights and permissions

Reprints and permissions

About this article

Cite this article

Chang, KC., García-Molina, H. Approximate query mapping: Accounting for translation closeness. The VLDB Journal 10, 155–181 (2001). https://doi.org/10.1007/s007780100042

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/s007780100042

Navigation