Skip to main content

Improving Database Retrieval on the Web through Query Relaxation

  • Conference paper
Business Information Systems Workshops (BIS 2009)

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 37))

Included in the following conference series:

Abstract

Offering database content to unknown Web users creates two problems. First, users need to know about its existence. Second, once they know that it exists, they need to be able to retrieve it. We concentrate on the latter task. The same problem occurs also within an organization but there at least the skilled users can use powerful tools like SQL to find any content within the database. Web interfaces to databases are relatively simple and restricted. Even a skilled user could not define complicated queries due to their limitations. Therefore, especially databases that should be accessed via the Web should offer more “intelligence”. We propose two features towards this goal. First, taxonomies should be built for selected attributes. Second, better query results should be offered by relaxing user queries based on the knowledge captured in the taxonomies. In this paper, we derive a method for query relaxation guided by the ideas of Bayesian inference. It helps to select the best attribute to relax the query in a retrieval step. The approach is applied to taxonomy-based attributes although it can be generalized to other types of attributes as well. The quality of the method is tested with data from an actual database offered on the Web.

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. He, B., Patel, M., Zhang, Z., Chang, K.: Accessing the Deep Web. Communications of the ACM (CACM) 50(5), 95–101 (2007)

    Article  Google Scholar 

  2. Shestakov, D.: Search interfaces on the Web: Querying and Characterizing, TUCS Dissertations 104 (2008)

    Google Scholar 

  3. Shestakov, D.: Deep Web: Databases on the Web. In: Entry in Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends (2009)

    Google Scholar 

  4. Spink, A., Wolfram, D., Jansen, M.B.J., Saracevic, T.: Searching the Web: The Public and Their Queries. J. of the American Society for Information Science and Technology 52(3), 226–234 (2001)

    Article  Google Scholar 

  5. Wright, A.: Searching the Deep Web. Communications of the ACM (CACM) 51(10), 14–15 (2008)

    Article  Google Scholar 

  6. Chu, W.W., Chen, Q., Lee, R.-C.: Cooperative Query Answering Via Type Abstraction Hierarchy. Technical Report CSD-900032, Computer Science Department, University of California (1990)

    Google Scholar 

  7. Chu, W.W., Yang, H., Chow, G.: A Cooperative Database System (CoBase) for Query Relaxation. In: Proceedings of the 3rd International Conference on Artificial Intelligence Planning Systems, AIPS 1996, Edinburgh (1996)

    Google Scholar 

  8. Gaasterland, T., Godfrey, P., Minker, J.: Relaxation as a Platform for Cooperative Answering. Technical Report CS-TR-2818, Institute for Advanced Computer Studies and Department of Computer Science, University of Maryland (1991)

    Google Scholar 

  9. Kumaran, G., Allan, J.: Selective User Interaction. In: Proceedings of the 16th Conference on Information and Knowledge Management, CIKM 2007, pp. 923–926 (2007)

    Google Scholar 

  10. Carpio, G.V.G., Abrouk, L., Cullot, N.: A Query Expansion Methodology in a Cooperation of Information Systems Based on Ontologies. In: Proceedings of the 5th International Conference on Web Information Systems and Technologies, WEBIST 2009, pp. 256–261 (2009)

    Google Scholar 

  11. Tomassen, S.L., Gulla, J.A., Strasunskas, D.: Document Space Adapted Ontology: Application in Query Enrichment. In: Kop, C., Fliedl, G., Mayr, H.C., Métais, E. (eds.) NLDB 2006. LNCS, vol. 3999, pp. 46–57. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  12. Schweighofer, E., Geist, A.: Legal Query Expansion using Ontologies and Relevance Feedback. In: Proceedings of the 11th Conference on Legal Ontologies and Artificial Intelligence Techniques, LOAIT 2007, pp. 149–160 (2007)

    Google Scholar 

  13. Shimazu, H., Kitano, H., Shibata, A.: Retrieving Cases from Relational Data-Bases: Another Strike Towards Corporate-Wide Case-Base Systems. In: Proceedings of the 13th International Joint Conference in Artificial Intelligence, IJCAI 1993 (1993)

    Google Scholar 

  14. Watson, I.: A Case-Based Reasoning Application for Engineering Sales Support Using Introspective Reasoning. In: Proceedings of the 17th National Conference on Artificial Intelligence (AAAI 2000) and the 12th Innovative Applications of Artificial Intelligence Conference (IAAI 2000), vol. 1, pp. 1054–1059. AAAI Press, Menlo Park (2000)

    Google Scholar 

  15. Schumacher, J., Bergmann, R.: An Efficient Approach to Similarity-Based Retrieval on Top of Relational Databases. In: Blanzieri, E., Portinale, L. (eds.) EWCBR 2000. LNCS, vol. 1898, pp. 273–284. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  16. Bernardo, J.M., Smith, A.F.M.: Bayesian Theory. John Wiley and Sons, New York (1993)

    Google Scholar 

  17. Carlin, B.P., Louis, T.A.: Bayes and Empirical Bayes Methods for Data Analysis. Chapman and Hall, New York (1996)

    Google Scholar 

  18. Berger, J.O.: Statistical Decision Theory. Springer, Berlin (1980)

    Google Scholar 

  19. Bergmann, R.: On the Use of Taxonomies for Representing Case Features and Local Similarity Measures. In: Proceedings of the 6th German Workshop on Case-Based Reasoning (1998)

    Google Scholar 

  20. Bergmann, R., Stahl, A.: Similarity Measures for Object-Oriented Case Representations. In: Smyth, B., Cunningham, P. (eds.) EWCBR 1998. LNCS, vol. 1488, p. 25. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  21. Silverstein, C., Henzinger, M., Marais, H., Moricz, M.: Analysis of a Very Large Web Search Engine Query Log. ACM SIGIR Forum 33 (1), online version, 7 p. (Fall 1999)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pfuhl, M., Alpar, P. (2009). Improving Database Retrieval on the Web through Query Relaxation. In: Abramowicz, W., Flejter, D. (eds) Business Information Systems Workshops. BIS 2009. Lecture Notes in Business Information Processing, vol 37. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03424-4_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-03424-4_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-03423-7

  • Online ISBN: 978-3-642-03424-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics