Providing Relevant Answers for Queries over E-Commerce Web Databases

Users often have vague or imprecise ideas when searching the e-commerce Web databases such as used cars databases, houses databases etc. and may not be able to formulate queries that accurately express their query intentions. They also would like to obtain the relevant information that meets their needs and preferences closely. In this paper, we present a new approach --- QRR (query relaxation and ranking), for relaxing the initial query over e-commerce Web databases in order to provide relevant answer to the user. QRR relaxes the query criteria by adding the most similar values into each query criterion range specified by the initial query, and then the relevant answers which satisfy the relaxed queries could be retrieved. For relevant query results, QRR speculates the importance of each attribute based on the user initial query and assigns the score of each attribute value according to its "desirableness" to the user, and then the relevant answers are ranked according to their satisfaction degree to the user's needs and preferences. Experimental results demonstrate that QRR can effectively recommend the relevant information to the user and have a high ranking quality as well.

[1]  Masahito Hirakawa,et al.  ARES: A relational database with the capability of performing flexible interpretation of queries , 1986, IEEE Transactions on Software Engineering.

[2]  Aristides Gionis,et al.  Automated Ranking of Database Query Results , 2003, CIDR.

[3]  Jaideep Srivastava,et al.  Web mining: information and pattern discovery on the World Wide Web , 1997, Proceedings Ninth IEEE International Conference on Tools with Artificial Intelligence.

[4]  Lotfi A. Zadeh,et al.  Fuzzy Sets , 1996, Inf. Control..

[5]  Gerhard Weikum,et al.  Probabilistic Ranking of Database Query Results , 2004, VLDB.

[6]  Zongmin Ma,et al.  Providing Flexible Queries over Web Databases , 2008, KES.

[7]  Lakhmi C. Jain,et al.  Knowledge-Based Intelligent Information and Engineering Systems , 2004, Lecture Notes in Computer Science.

[8]  Qiong Huang,et al.  Query result ranking over e-commerce web databases , 2006, CIKM '06.

[9]  Zongmin Ma,et al.  A Knowledge-Based Approach for Answering Fuzzy Queries over Relational Databases , 2008, KES.

[10]  Pasquale Savino,et al.  Retrieval of Multimedia Documents by Imprecise Query Specification , 1990, EDBT.

[11]  Dennis Tsichritzis,et al.  Advances in Database Technology — EDBT '90 , 1990, Lecture Notes in Computer Science.

[12]  Valiollah Tahani,et al.  A conceptual framework for fuzzy query processing - A step toward very intelligent database systems , 1977, Inf. Process. Manag..

[13]  Habib Ounelli,et al.  A Knowledge-Based Approach For Database Flexible Querying , 2006, 17th International Workshop on Database and Expert Systems Applications (DEXA'06).

[14]  Werner Kießling,et al.  Foundations of Preferences in Database Systems , 2002, VLDB.