A holistic and principled approach for the empty-answer problem

We propose a principled optimization-based interactive query relaxation framework for queries that return no answers. Given an initial query that returns an empty-answer set, our framework dynamically computes and suggests alternative queries with fewer conditions than those the user has initially requested, in order to help the user arrive at a query with a non-empty-answer, or at a query for which no matter how many additional conditions are ignored, the answer will still be empty. Our proposed approach for suggesting query relaxations is driven by a novel probabilistic framework based on optimizing a wide variety of application-dependent objective functions. We describe optimal and approximate solutions of different optimization problems using the framework. Moreover, we discuss two important extensions to the base framework: the specification of a minimum size on the number of results returned by a relaxed query and the possibility of proposing multiple conditions at the same time. We analyze the proposed solutions, experimentally verify their efficiency and effectiveness, and illustrate their advantages over the existing approaches.

[1]  Nish Parikh,et al.  Rewriting null e-commerce queries to recommend products , 2012, WWW.

[2]  Gautam Das,et al.  Facetedpedia: dynamic generation of query-dependent faceted interfaces for wikipedia , 2010, WWW '10.

[3]  Anthony K. H. Tung,et al.  Relaxing join and selection queries , 2006, VLDB.

[4]  Parke Godfrey,et al.  Minimization in Cooperative Response to Failing Database Queries , 1994, Int. J. Cooperative Inf. Syst..

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

[6]  Ben Shneiderman,et al.  The alphaslider: a compact and rapid selector , 1994, CHI Conference Companion.

[7]  Vagelis Hristidis,et al.  FACeTOR: cost-driven exploration of faceted query results , 2010, CIKM.

[8]  Zbigniew W. Ras,et al.  Solving Failing Queries through Cooperation and Collaboration , 2006, World Wide Web.

[9]  Gang Luo Efficient detection of empty-result queries , 2006, VLDB.

[10]  Ben Shneiderman,et al.  Interface and data architecture for query preview in networked information systems , 1999, TOIS.

[11]  Nick Koudas,et al.  Interactive query refinement , 2009, EDBT '09.

[12]  Susan Gauch,et al.  An Expert System for Automatic Query Reformation , 1993, J. Am. Soc. Inf. Sci..

[13]  Adriane Chapman,et al.  Why Not? , 1965, SIGMOD Conference.

[14]  Qiming Chen,et al.  Neighborhood and associative query answering , 2004, Journal of Intelligent Information Systems.

[15]  Amihai Motro FLEX: A Tolerant and Cooperative User Interface to Databases , 1990, IEEE Trans. Knowl. Data Eng..

[16]  Gautam Das,et al.  IQR: an interactive query relaxation system for the empty-answer problem , 2014, SIGMOD Conference.

[17]  Quoc Trung Tran,et al.  How to ConQueR why-not questions , 2010, SIGMOD Conference.

[18]  Jian Pei,et al.  Catching the Best Views of Skyline: A Semantic Approach Based on Decisive Subspaces , 2005, VLDB.

[19]  Nick Koudas,et al.  Entropy based approximate querying and exploration of datacubes , 2001, Proceedings Thirteenth International Conference on Scientific and Statistical Database Management. SSDBM 2001.

[20]  Ulrich Junker,et al.  QUICKXPLAIN: Preferred Explanations and Relaxations for Over-Constrained Problems , 2004, AAAI.

[21]  Ricardo A. Baeza-Yates,et al.  Query Recommendation Using Query Logs in Search Engines , 2004, EDBT Workshops.

[22]  Luca Becchetti,et al.  An optimization framework for query recommendation , 2010, WSDM '10.

[23]  Terry Gaasterland Cooperative Answering through Controlled Query Relaxation , 1997, IEEE Expert.

[24]  Ben Shneiderman,et al.  The end of zero-hit queries: query previews for NASA’s Global Change Master Directory , 1999, International Journal on Digital Libraries.

[25]  Susan Gauch,et al.  Search improvement via automatic query reformulation , 1991, TOIS.

[26]  Panagiotis G. Ipeirotis,et al.  Ranked queries over sources with Boolean query interfaces without ranking support , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[27]  Leonard Pitt,et al.  Efficient Read-Restricted Monotone CNF/DNF Dualization by Learning with Membership Queries , 1999, Machine Learning.

[28]  Ion Muslea,et al.  Machine learning for online query relaxation , 2004, KDD.

[29]  V. Smith,et al.  Multivariate analysis: Theory and practice , 1974 .

[30]  Dietmar Jannach Techniques for Fast Query Relaxation in Content-Based Recommender Systems , 2006, KI.

[31]  Ji-Rong Wen,et al.  Query clustering using user logs , 2002, TOIS.

[32]  Filip Radlinski,et al.  Query chains: learning to rank from implicit feedback , 2005, KDD '05.

[33]  David S. Johnson,et al.  Computers and Intractability: A Guide to the Theory of NP-Completeness , 1978 .

[34]  Jan Chomicki,et al.  Skyline queries, front and back , 2013, SGMD.

[35]  Amihai Motro,et al.  VAGUE: a user interface to relational databases that permits vague queries , 1988, TOIS.

[36]  Xi Zhang,et al.  Preference queries over sets , 2011, 2011 IEEE 27th International Conference on Data Engineering.

[37]  Patrick Bosc,et al.  Incremental controlled relaxation of failing flexible queries , 2009, Journal of Intelligent Information Systems.

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

[39]  Thomas G. Dietterich What is machine learning? , 2020, Archives of Disease in Childhood.

[40]  Ion Muslea,et al.  Online Query Relaxation via Bayesian Causal Structures Discovery , 2005, AAAI.

[41]  Jürgen M. Janas On the Feasibility of Informative Answers , 1979, Advances in Data Base Theory.

[42]  Gerhard Weikum,et al.  Probabilistic information retrieval approach for ranking of database query results , 2006, TODS.

[43]  Iadh Ounis,et al.  Query reformulation using automatically generated query concepts from a document space , 2006, Inf. Process. Manag..

[44]  Gautam Das,et al.  A Probabilistic Optimization Framework for the Empty-Answer Problem , 2013, Proc. VLDB Endow..

[45]  Mukesh K. Mohania,et al.  Retrieval]: Query formulation, search process , 2022 .

[46]  Amihai Motro SEAVE: a mechanism for verifying user presuppositions in query systems , 1986, TOIS.

[47]  Dimitrios Gunopulos,et al.  Anytime measures for top-k algorithms on exact and fuzzy data sets , 2009, The VLDB Journal.

[48]  David McSherry,et al.  Incremental Relaxation of Unsuccessful Queries , 2004, ECCBR.

[49]  Dietmar Jannach,et al.  Conflict-Directed Relaxation of Constraints in Content-Based Recommender Systems , 2006, IEA/AIE.

[50]  Patrick Bosc,et al.  Empty versus overabundant answers to flexible relational queries , 2008, Fuzzy Sets Syst..

[51]  Surajit Chaudhuri Generalization and a framework for query modification , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[52]  Alberto O. Mendelzon,et al.  Using datacube aggregates for approximate querying and deviation detection , 2005, IEEE Transactions on Knowledge and Data Engineering.