Skip to main content

Uncovering the Deep Web: Transferring Relational Database Content and Metadata to OWL Ontologies

  • Conference paper
Knowledge-Based Intelligent Information and Engineering Systems (KES 2008)

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

Abstract

Organizing the publicly available Web content into highly systematized domain ontologies is a necessary step in the evolvement of the Semantic Web. A large portion of that content called the deep Web is stored in relational databases and it is not accessible to Web search engines. Incorporation of the deep Web data results in domain ontologies richer both in content and in semantic relations. In this paper we introduce a framework for an automatic mapping of relational database metadata and content to domain ontologies written in OWL. Relational constructs: relations, attributes and primary-foreign key associations are translated to OWL classes, datatype properties and object properties. Database tuples become ontology instances. In order to define reference points for integration with other ontologies the constructed ontologies are further enriched with additional semantics from the WordNet lexical database using word sense disambiguation mechanisms. A software implementation of the approach has been developed and evaluated on case study examples.

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. World Wide Web Consortium: W3C Semantic Web Activity (last visited: January 16, 2008) (2008), http://www.w3.org/2001/sw/

  2. World Wide Web Consortium: OWL Web Ontology Language Guide W3C Recommendation as of February 10 2004 (2004), http://www.w3.org/TR/2004/REC-owl-guide-20040210

  3. Bergman, M.K.: The Deep Web: Surfacing Hidden Value. White paper, Deep Content (2001), http://www.brightplanet.com/resources/details/deepweb.html

  4. WordNet. A lexical database for the English language (last visited May 5, 2008) (2008), http://wordnet.princeton.edu/

  5. Stojanovic, L., Stojanovic, N., Volz, R.: Migrating Data-Intensive Web Sites into the Semantic Web. In: 17th ACM Symposium on Applied Computing, pp. 1100–1107. ACM Press, New York (2002)

    Google Scholar 

  6. Astrova, I.: Reverse Engineering of Relational Databases to Ontologies. In: Bussler, C., Davies, J., Fensel, D., Studer, R. (eds.) ESWS 2004. LNCS, vol. 3053, pp. 327–341. Springer, Heidelberg (2004)

    Google Scholar 

  7. Dogan, G., Islamaj, R.: Importing Relational Databases into the Semantic Web(last visited: January 16, 2008) (2002), http://www.mindswap.org/webai/2002/fall/Importing_20Relational_20Databases_20into_20the_20Semantic_20Web.html

  8. Jurić, D., Skočir, Z.: Building OWL Ontologies by Analyzing Relational Database Schema Concepts and WordNet semantic relations. In: Car, Ž., Kušek, M. (eds.) 9th Int. Conf. on Telecommunications, FER, Zagreb, pp. 235–242 (2001)

    Google Scholar 

  9. Benslimane, S.M., Benslimane, D., Malki, M.: Acquiring OWL Ontologies from Data-Intensive Web Sites. In: Wolber, D., Calder, N., Brooks, C.H., Ginige, A. (eds.) Int. Conf. on Web Engineering, pp. 361–368. ACM Press, New York (2006)

    Google Scholar 

  10. Euzenat, J., Shvaiko, P.: Ontology Matching. Springer, New York (2007)

    MATH  Google Scholar 

  11. Giunchiglia, F., Shvaiko, P., Yatskevich, M.: S-Match: an Algorithm and an Implementation of Semantic Matching. In: Bussler, C., Davies, J., Fensel, D., Studer, R. (eds.) ESWS 2004. LNCS, vol. 3053, pp. 327–341. Springer, Heidelberg (2004)

    Google Scholar 

  12. Castano, S., Ferrara, A., Montanelli, S.: H-MATCH: an Algorithm for Dynamically Matching Ontologies in Peer-based Systems. In: Cruz, I.F., Kashyap, V., Decker, S., Eckstein, R. (eds.) Proc. Int. Workshop on Semantic Web & Databases, pp. 231–250 (2003)

    Google Scholar 

  13. Pan, R., Ding, Z., Yu, Y., Peng, Y.: A Bayesian Network Approach to Ontology Mapping. In: Gil, Y., Motta, E., Benjamins, V.R., Musen, M.A. (eds.) ISWC 2005. LNCS, vol. 3729, pp. 563–577. Springer, Heidelberg (2005)

    Chapter  Google Scholar 

  14. Yang, D., Powers, D.M.W.: Measuring Semantic Similarity in the Taxonomy of WordNet. In: Estivill-Castro, V. (ed.) 28th Australasian Computer Science Conference, pp. 315–322. Australian Computer Society (2005)

    Google Scholar 

  15. Liu, S., Yu, C.T., Meng, W.: Word Sense Disambiguation in Queries. In: Herzog, O., et al. (eds.) 2005 ACM International Conference on Information and Knowledge Management, pp. 525–532. ACM Press, New York (2005)

    Google Scholar 

  16. Java Database Connectivity - JDBC (last visited May 5, 2008) (2008), http://java.sun.com/products/jdbc/overview.html

  17. Java WordNet Library - JWNL (last visited May 5, 2008) (2008), http://jwordnet.sourceforge.net

  18. Jena Semantic Web Framework (last visited May 5, 2008) (2008), http://jena.sourceforge.net

Download references

Author information

Authors and Affiliations

Authors

Editor information

Ignac Lovrek Robert J. Howlett Lakhmi C. Jain

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Jurić, D., Banek, M., Skočir, Z. (2008). Uncovering the Deep Web: Transferring Relational Database Content and Metadata to OWL Ontologies. In: Lovrek, I., Howlett, R.J., Jain, L.C. (eds) Knowledge-Based Intelligent Information and Engineering Systems. KES 2008. Lecture Notes in Computer Science(), vol 5177. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85563-7_59

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-85563-7_59

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-85562-0

  • Online ISBN: 978-3-540-85563-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics