Skip to main content

Schema-Matching with Data Dictionaries

  • Conference paper
Natural Language Processing and Information Systems (NLDB 2009)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 5723))

  • 843 Accesses

Abstract

We describe an algorithm for detecting semantically equivalent metadata across namespaces instantiated as database schema, an operation otherwise known as schema-matching. Assuming a metadata description discipline which imposes graph-theoretic constraints on data dictionaries, the algorithm employs analytical techniques used in information retrieval, information theory, and computational linguistics. It exploits the information inherent in textual metadata description and metadata dependency relations in order to match elements across schema boundaries.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • 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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Rahm, E., Bernstein, P.: A Survey of Approaches to Automatic Schema Matching. The VLDB Journal 10, 334–350 (2001)

    Article  MATH  Google Scholar 

  2. Coen, G.: Dictionaries and Lexical Graphs. In: Moreno, A., van de Ried, R.P. (eds.) Applications of Natural Language to Information Systems. Gesellschaft für Informatik, Bonn (2001)

    Google Scholar 

  3. Coen, G.: Database Lexicography. Data and Knowledge Engineering 42, 3 (2002)

    Article  Google Scholar 

  4. Lesk, M.: Automated Sense Disambiguation Using Machine-readable Dictionaries: How to Tell a Pine Cone from an Ice Cream Cone. In: Proceedings of the 5th Annual International Conference on Systems Documentation, Toronto, Ontario, Canada, pp. 24–26 (1986)

    Google Scholar 

  5. Salton, G.: Automatic Information Organization and Retrieval. McGraw-Hill, New York (1968)

    Google Scholar 

  6. Doyle, L.B.: The Microstatistics of Text. Information Storage and Retrieval 1, 189–214 (1963)

    Article  Google Scholar 

  7. Cormack, A.: Definitions: Implications for Syntax, Semantics, and the Language of Thought. Garland, New York (1998)

    Google Scholar 

  8. Fellbaum, C. (ed.): WordNet: An Electronic Lexical Database. MIT Press, Cambridge (1998)

    MATH  Google Scholar 

  9. Shannon, C., Weaver, W.: The Mathematical Theory of Communication. University of Illinois Press, Urbana (1949)

    MATH  Google Scholar 

  10. Robertson, S.E., et al.: Large test collection experiments on an operational, interactive system: Okapi at TREC. Information Processing and Management 31, 345–360 (1995)

    Article  Google Scholar 

  11. Manly, B.F.J.: Multivariate Statistical Methods: A Primer. Chapman & Hall, London (1986)

    Google Scholar 

  12. Sneath, P.H.A., Sokal, R.R.: Numerical Taxonomy. W.H. Freeman and Company, San Francisco (1973)

    MATH  Google Scholar 

  13. Kaplan, D.: Demonstratives. In: Almong, J., et al. (eds.) Themes from Kaplan. Oxford University Press, Oxford (1989)

    Google Scholar 

  14. Madhavan, J., Bernstein, P.A., Rahm, E.: Generic Schema matching with Cupid. In: Proceedings of the 27th VLDB Conference, Rome, Italy (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Coen, G., Xue, P. (2010). Schema-Matching with Data Dictionaries. In: Horacek, H., Métais, E., Muñoz, R., Wolska, M. (eds) Natural Language Processing and Information Systems. NLDB 2009. Lecture Notes in Computer Science, vol 5723. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-12550-8_6

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-12550-8_6

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-12549-2

  • Online ISBN: 978-3-642-12550-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics