Skip to main content

Mining Query Log to Assist Ontology Learning from Relational Database

  • Conference paper
Frontiers of WWW Research and Development - APWeb 2006 (APWeb 2006)

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

Included in the following conference series:

Abstract

Ontology learning plays a significant role in migrating legacy knowledge base into the Semantic Web. Relational database is the vital source that stores the structured knowledge today. Some prior work has contributed to the learning process from relational database to ontology. However, a majority of the existing methods focus on the schema dimension, leaving the data dimension not well exploited. In this paper we present a novel approach that exploits the data dimension by mining user query log to glorify the ontology learning process. In addition, we propose a set of rules for schema extraction which serves as the basis of our theme. The presented approach can be applied to a broad range of today’s relational data warehouse.

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 189.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

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. O’Leary, D.E.: Using ai in knowledge management: Knowledge bases and ontologies. IEEE Intelligent Systems, 34–39 (1998)

    Google Scholar 

  2. Chandrasekaran, B., Josephson, J.R., Benjamins, V.R.: The ontology of tasks and methods. In: 11th Workshop on Knowledge Acquisition, Modeling and Management (1998)

    Google Scholar 

  3. Dogan, G., Islamaj, R.: Importing relational databases into the semantic web (2002)

    Google Scholar 

  4. Beckett, D., Grant, J.: Swad-europe deliverable 10.2: Mapping semantic web data with rdbmses

    Google Scholar 

  5. Stojanovic, L., Stojanovic, N., Volz, R.: Migrating data-intensive web sites into the semantic web. In: Proceedings of the 17th ACM Symposium on Applied Computing (SAC) (2002)

    Google Scholar 

  6. Kashyap, V.: Design and creation of ontologies for environmental information retrieval. In: Proceedings of the 12th Workshop on Knowledge Acquisition, Modeling and Manage-ment (KAW) (1999)

    Google Scholar 

  7. Astrova, I.: Reverse engineering of relational databases to ontologies. In: Bussler, C.J., Davies, J., Fensel, D., Studer, R. (eds.) ESWS 2004. LNCS, vol. 3053, pp. 327–341. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  8. Phillips, J., Buchanan, B.: Ontology-guided knowledge discovery in databases. In: Proceedings of the First International Conference on Knowledge Capture (2001)

    Google Scholar 

  9. Pérez, J., et al.: Data reverse engineering of legacy databases to object oriented conceptual schemas. Electronic Notes in Theoretical Computer Science 72, 11–23 (2003)

    Google Scholar 

  10. Johannesson, P.: A method for transforming relational schemas into conceptual schemas. In. In: 10th International Conference on Data Engineering (ICDE) (1994)

    Google Scholar 

  11. Petit, J.M., Toumani, F., Boulicaut, J.F., Kouloumdjian, J.: Towards the reverse engineering of denormalized relational databases. In: Proceedings of the Twelfth International Conference on Data Engineering (ICDE 1996), pp. 218–227 (1996)

    Google Scholar 

  12. Shen, W., Zhang, W., Wang, X., Arens, Y.: Discovering conceptual object models from instances of large relational databases. International Journal on Data Mining and Knowledge Discovery (1999)

    Google Scholar 

  13. Shekar, R., Julia, H.: Extraction of object-oriented structures from existing relational databases. SIGMOD Record (ACM Special Interest Group on Management of Data) 26, 59–64 (1997)

    Google Scholar 

  14. Lammari, N.: An algorithm to extract is-a inheritance hierarchies from a relational database. In: Proceedings of International Conference on Conceptual Modeling, Paris, France, pp. 218–232 (1999)

    Google Scholar 

  15. Wille, R.: Restructuring lattice theory: An approach based on hierarchies of concepts, Reidel, Dordrecht, Boston, pp. 445–470 (1982)

    Google Scholar 

  16. Ganter, B., Wille, R.: Formal Concept Analysis: mathematical foundations. Springer, Heidelberg (1999)

    MATH  Google Scholar 

  17. Ganter, B.: two basic algorithms in conceptual analysis. Technical report, Darmstadt University (1984)

    Google Scholar 

  18. TOSCANA - A graphical tool for analyzing and exploring data. In: Tamassia, R., Tollis, I.G. (eds.) GD 1994. LNCS, vol. 894. Springer, Heidelberg (1995)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Zhang, J., Xiong, M., Yu, Y. (2006). Mining Query Log to Assist Ontology Learning from Relational Database. In: Zhou, X., Li, J., Shen, H.T., Kitsuregawa, M., Zhang, Y. (eds) Frontiers of WWW Research and Development - APWeb 2006. APWeb 2006. Lecture Notes in Computer Science, vol 3841. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11610113_39

Download citation

  • DOI: https://doi.org/10.1007/11610113_39

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-31142-3

  • Online ISBN: 978-3-540-32437-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics