Improving Database Retrieval on the Web through Query Relaxation

  • Markus Pfuhl
  • Paul Alpar
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 37)

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    He, B., Patel, M., Zhang, Z., Chang, K.: Accessing the Deep Web. Communications of the ACM (CACM) 50(5), 95–101 (2007)CrossRefGoogle Scholar
  2. 2.
    Shestakov, D.: Search interfaces on the Web: Querying and Characterizing, TUCS Dissertations 104 (2008)Google Scholar
  3. 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. 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)CrossRefGoogle Scholar
  5. 5.
    Wright, A.: Searching the Deep Web. Communications of the ACM (CACM) 51(10), 14–15 (2008)CrossRefGoogle Scholar
  6. 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. 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. 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. 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. 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. 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)CrossRefGoogle Scholar
  12. 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. 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. 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. 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)CrossRefGoogle Scholar
  16. 16.
    Bernardo, J.M., Smith, A.F.M.: Bayesian Theory. John Wiley and Sons, New York (1993)Google Scholar
  17. 17.
    Carlin, B.P., Louis, T.A.: Bayes and Empirical Bayes Methods for Data Analysis. Chapman and Hall, New York (1996)Google Scholar
  18. 18.
    Berger, J.O.: Statistical Decision Theory. Springer, Berlin (1980)Google Scholar
  19. 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. 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)CrossRefGoogle Scholar
  21. 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

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Markus Pfuhl
    • 1
  • Paul Alpar
    • 1
  1. 1.Institut für WirtschaftsinformatikPhilipps-Universität MarburgMarburg

Personalised recommendations