Approximate query mapping: Accounting for translation closeness

Citation
Kcc. Chang et H. Garcia-molina, Approximate query mapping: Accounting for translation closeness, VLDB J, 10(2-3), 2001, pp. 155-181
Citations number
38
Categorie Soggetti
Computer Science & Engineering
Journal title
VLDB JOURNAL
ISSN journal
10668888 → ACNP
Volume
10
Issue
2-3
Year of publication
2001
Pages
155 - 181
Database
ISI
SICI code
1066-8888(200110)10:2-3<155:AQMAFT>2.0.ZU;2-Z
Abstract
In this paper we present a mechanism for approximately translating Boolean query constraints across heterogeneous information sources. Achieving the b est translation is challenging because sources support different constraint s for formulating queries, and often these constraints cannot be precisely translated. For instance, a query [score >8] might be "perfectly" translate d 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 customizab le "closeness" metric for the translation that combines both precision and recall. Our results show that for query translation we need to handle inter dependencies among both query conjuncts as well as disjuncts. As the basis, we identify the essential requirements of a rule system for users to encod e the mappings for atomic semantic units. Our algorithm then translates com plex 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 prese nt a case study to show how our technique may be applied in practice.