Skip to main content

A Knowledge-Based Approach to Querying Heterogeneous Databases

Part of the Lecture Notes in Computer Science book series (LNAI,volume 2366)

Abstract

Query processing plays a fundamental role in current information systems that need to access independent and heterogeneous databases. This paper presents a new approach to querying heterogeneous databases that maps the semantics of query objects onto database schemas. The sematics is captured by the definitions of classes in an ontology, and a similarity function identifies not only equivalent but also semantically similar classes associated with a user’s request. These similar classes are then mapped onto a database schema, which is compared with schemas of heterogeneous databases to obtain entities in the databases that answer the query.

Keywords

  • Semantic Similarity
  • Semantic Relation
  • Relational Schema
  • Database Schema
  • Query Object

These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (Canada)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Guarino, N., Masolo, C., Verete, G.: OntoSeek: Content-Based Access to the Web. IEEE Intelligent Systems 14 (1999) 70–80.

    CrossRef  Google Scholar 

  2. Bergamaschi, B., Castano, S., de Vermercati, S., Montanari, S., Vicini, M.: An Intelligent Approach to Information Integration. In: N. Guarino (ed.): First International Conference on Formal Ontology in Information Systems. IOS Press, Trento Italy (1998) 253–268

    Google Scholar 

  3. Voorhees, E.: Using WordNet for Text Retrieval. In: Fellbaum C. (ed.): WordNet: An Electronic Lexical DatabaseCambridge. The MIT Press, MA (1998) 285–303

    Google Scholar 

  4. Mena, E., Illarramendi, A., Kashyap, V., Sheth, A.: OBSERVER: An Approach for Query Processing In Global Information Systems Based on Interoperation across Preexisting Ontologies. Distributed and Parallel Databases 8 (2000) 223–271

    CrossRef  Google Scholar 

  5. Bertino, E., Catania, B., Zarri, G.: Intelligent Database Systems. ACM Press, London UK (2001)

    Google Scholar 

  6. Guarino, N.: Formal Ontology in Information Systems. In: Guarino, N. (ed.): Formal Ontology in Information Systems. IOS Press, Trento, Italy (1998) 3–15

    Google Scholar 

  7. Bright, M., Hurson, A., Pakzad, S.: Automated Resolution of Semantic Heterogeneity in Multidatabases. ACM Transactions on Database Systems 19 (1994) 212–253

    CrossRef  Google Scholar 

  8. Fankhause, P., Neuhold, E.: Knowledge Based Integration of Heterogeneous Databases. In: Hsiao, H., Neuhold, E., Sacks-Davis, R. (eds.): Database Semantics Conference on Interoperable Database Systems IFIP WG2.6. Elsevier Science Publishers, North-Holland (1992)155–175

    Google Scholar 

  9. Codd, E.: A Relational Model of Data for Large Shared Data Banks. Communications of the ACM 13 (1970) 377–387

    CrossRef  MATH  Google Scholar 

  10. Rodríguez, A., Egenhofer, M.: Determining Semantic Similarity among Entity Classes from Different Ontologies. IEEE Transactions on Knowledge and Data Engineering (in press)

    Google Scholar 

  11. Rodríguez, A. Egenhofer, M.: Putting Similarity Assessment into Context: Matching Functions with the User’s Intended Operations. In: Sefarini, L., Brezillon, O., Castellano, F., Bouquet, P. (eds): Modeling and Using Context CONTEXT99. Lecture Notes in Computer Science Vol. 1688. Springer-Verlag, Berlin (1999) 310–323

    CrossRef  Google Scholar 

  12. Tversky, A.: Features of Similarity. Psychological Review 84 (1977) 327–352

    CrossRef  Google Scholar 

  13. Rosch, E.: Cognitive Representations of Semantic Categories. Journal of Experimental Psychology 104 (1975) 192–233

    Google Scholar 

  14. Rada, R., Mili, H., Bicknell, E., Blettner, M.: Development and Application of a Metric on Semantic Nets. IEEE Transactions on System, Man, and Cybernetics 19 (1989) 17–30

    CrossRef  Google Scholar 

  15. Sussna, M.: Word Sense Disambiguation for Free-text Indexing Using a Massive Semantic Network. In: Second International Conference on Information Knowledge Management, CIKM’93 (1993)

    Google Scholar 

  16. Resnik, O.: Semantic Similarity in a Taxonomy: An Information-Based Measure and its Application to Problems of Ambiguity and Natural Language. Journal of Artificial Intelligence Research 11 (1999) 95–130

    MATH  Google Scholar 

  17. Miller, G., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.: Introduction to WordNet: An On-Line Lexical Database. International Journal of Lexicography 3 (1990) 235–244.

    CrossRef  Google Scholar 

  18. USGS: View of the Spatial Data Transfer Standard (SDTS) Document (1998)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Rodríguez, M.A., Varas, M. (2002). A Knowledge-Based Approach to Querying Heterogeneous Databases. In: Hacid, MS., Raś, Z.W., Zighed, D.A., Kodratoff, Y. (eds) Foundations of Intelligent Systems. ISMIS 2002. Lecture Notes in Computer Science(), vol 2366. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48050-1_25

Download citation

  • DOI: https://doi.org/10.1007/3-540-48050-1_25

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-43785-7

  • Online ISBN: 978-3-540-48050-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics