Skip to main content

sPLMap: A Probabilistic Approach to Schema Matching

  • Conference paper
Book cover Advances in Information Retrieval (ECIR 2005)

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

Included in the following conference series:

Abstract

This paper introduces the first formal framework for learning mappings between heterogeneous schemas which is based on logics and probability theory. This task, also called “schema matching”, is a crucial step in integrating heterogeneous collections. As schemas may have different granularities, and as schema attributes do not always match precisely, a general-purpose schema mapping approach requires support for uncertain mappings, and mappings have to be learned automatically. The framework combines different classifiers for finding suitable mapping candidates (together with their weights), and selects that set of mapping rules which is the most likely one. Finally, the framework with different variants has been evaluated on two different data sets.

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 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.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. Callan, J., Connell, M.: Query-based sampling of text databases. ACM Transactions on Information Systems 19(2), 97–130 (2001)

    Article  Google Scholar 

  2. Dhamankar, R., Lee, Y., Doan, A., Halevy, A., Domingos, P.: iMAP: Discovering complex semantic matches between database schemas. In: SIGMOD 2004 (2004)

    Google Scholar 

  3. Doan, A., Domingos, P., Halevy, A.Y.: Reconciling schemas of disparate data sources: A machine-learning approach. In: SIGMOD Conference (2001)

    Google Scholar 

  4. Doan, A., Madhavan, J., Dhamankar, R., Domingos, P., Halevy, A.: Learning to match ontologies on the semantic web. VLDB Journal (2004)

    Google Scholar 

  5. Fagin, R., Kolaitis, P.G., Tan, W.-C., Popa, L.: Composing schema mappings: Second-order dependencies to the rescue. In: Proceedings PODS 2004 (2004)

    Google Scholar 

  6. Friedman, M., Levy, A.Y., Millstein, T.D.: Navigational plans for data integration. In: Proceedings of 16th Natl Conf. on Artificial Intelligence, pp. 67–73 (1999)

    Google Scholar 

  7. Fuhr, N.: Towards data abstraction in networked information retrieval systems. Information Processing and Management 35(2), 101–119 (1999)

    Article  Google Scholar 

  8. Fuhr, N.: Probabilistic Datalog: Implementing logical information retrieval for advanced applications. Journal of the American Society for Information Science 51(2), 95–110 (2000)

    Article  MathSciNet  Google Scholar 

  9. He, B., Chang, K.C.-C.: Statistical schema matching across web query interfaces. In: Papakonstantinou, et al. (eds.) [13]

    Google Scholar 

  10. Kang, J., Naughton, J.F.: On schema matching with opaque column names and data values. In: Papakonstantinou, et al. (eds.) [13]

    Google Scholar 

  11. Lenzerini, M.: Data integration: a theoretical perspective. In: Proceedings of the 21st ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems (PODS 2002), pp. 233–246. ACM Press, New York (2002)

    Chapter  Google Scholar 

  12. Nottelmann, H., Fuhr, N.: Learning probabilistic Datalog rules for information classification and transformation. In: Paques, H., Liu, L., Grossman, D. (eds.) Proceedings of the 10th International Conference on Information and Knowledge Management, pp. 387–394. ACM, New York (2001)

    Google Scholar 

  13. Papakonstantinou, Y., Halevy, A., Ives, Z. (eds.): Proceedings SIGMOD 2003 (2003)

    Google Scholar 

  14. Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal 10(4), 334–350 (2001)

    Article  MATH  Google Scholar 

  15. Sebastiani, F.: Machine learning in automated text categorization. ACM Computing Surveys 34(1), 1–47 (2002)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Nottelmann, H., Straccia, U. (2005). sPLMap: A Probabilistic Approach to Schema Matching. In: Losada, D.E., Fernández-Luna, J.M. (eds) Advances in Information Retrieval. ECIR 2005. Lecture Notes in Computer Science, vol 3408. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-31865-1_7

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-31865-1_7

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-25295-5

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

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics