Skip to main content
Erschienen in: The VLDB Journal 1/2020

14.09.2019 | Special Issue Paper

An experimental survey of regret minimization query and variants: bridging the best worlds between top-k query and skyline query

verfasst von: Min Xie, Raymond Chi-Wing Wong, Ashwin Lall

Erschienen in: The VLDB Journal | Ausgabe 1/2020

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

When faced with a database containing millions of tuples, a user may be only interested in a (typically much) smaller representative subset. Recently, a query called the regret minimization query was proposed toward this purpose to create such a subset for users. Specifically, this query finds a set of tuples that minimizes the user regret (measured by how far the user’s favorite tuple in the selected set is from his/her favorite tuple in the whole database). The regret minimization query was shown to be very useful in bridging the best worlds between two existing well-known queries, top-k queries and skyline queries: Like top-k queries, the total number of tuples returned in this new query is controllable, and like skyline queries, this new query does not require a user to specify any preference function. Thus, it has attracted a lot of attention from researchers in the database community. Various methods were proposed for regret minimization. However, despite the abundant research effort, there is no systematic comparison among the existing methods. This paper surveys this interesting and evolving research topic by broadly reviewing and comparing the state-of-the-art methods for regret minimization. Moreover, we study different variants of the regret minimization query that has garnered considerable attention in recent years and present some interesting problems that have not yet been addressed in the literature. We implemented 12 state-of-the-art methods published in top-tier venues such as SIGMOD and VLDB from 2010 to 2018 for obtaining regret minimization sets and give an experimental comparison under various parameter settings on both synthetic and real datasets. Our evaluation shows that the optimal choice of methods for regret minimization depends on the application demands. This paper provides an empirical guideline for making such a decision.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Fußnoten
1
We define the maximum regret ratio using the supremum instead of the maximum since the function class \(\mathsf {FC}\) can consist of an infinite number of utility functions and a maximum may not exist.
 
Literatur
1.
Zurück zum Zitat Agarwal, P., Peled, S., Varadarajan, K.: Approximating extent measures of points. J. ACM 51, 606–635 (2004)MathSciNetCrossRef Agarwal, P., Peled, S., Varadarajan, K.: Approximating extent measures of points. J. ACM 51, 606–635 (2004)MathSciNetCrossRef
2.
Zurück zum Zitat Agarwal, P.K., Kumar, N., Sintos, S., Suri, S.: Efficient algorithms for k-regret minimizing sets. In: International Symposium on Experimental Algorithms (SEA) (2017) Agarwal, P.K., Kumar, N., Sintos, S., Suri, S.: Efficient algorithms for k-regret minimizing sets. In: International Symposium on Experimental Algorithms (SEA) (2017)
3.
Zurück zum Zitat Alhenshiri, A.: Web information retrieval and search engines techniques. Al-Satil J. (2010) Alhenshiri, A.: Web information retrieval and search engines techniques. Al-Satil J. (2010)
4.
Zurück zum Zitat Asudeh, A., Nazi, A., Zhang, N., Das, G.: Efficient computation of regret-ratio minimizing set: a compact maxima representative. In: Proceedings of the ACM International Conference on Management of Data (2017) Asudeh, A., Nazi, A., Zhang, N., Das, G.: Efficient computation of regret-ratio minimizing set: a compact maxima representative. In: Proceedings of the ACM International Conference on Management of Data (2017)
5.
Zurück zum Zitat Asudeh, A., Nazi, A., Zhang, N., Dasm, G., Jagadish, H.: Rrr: rank-regret representative. In: Proceedings of the 2019 ACM International Conference on Management of Data (2019) Asudeh, A., Nazi, A., Zhang, N., Dasm, G., Jagadish, H.: Rrr: rank-regret representative. In: Proceedings of the 2019 ACM International Conference on Management of Data (2019)
6.
Zurück zum Zitat Borzsony, S., Kossmann, D., Stocker, K.: The skyline operator. In: Proceedings of the 17th International Conference on Data Engineering (2001) Borzsony, S., Kossmann, D., Stocker, K.: The skyline operator. In: Proceedings of the 17th International Conference on Data Engineering (2001)
7.
Zurück zum Zitat Cao, W., Li, J., Wang, H., Wang, K., Wang, R., Wong, R., Zhan, W.: k-regret minimizing set: efficient algorithms and hardness. In: ICDT (2017) Cao, W., Li, J., Wang, H., Wang, K., Wang, R., Wong, R., Zhan, W.: k-regret minimizing set: efficient algorithms and hardness. In: ICDT (2017)
8.
Zurück zum Zitat Chan, C., Jagadish, H., Tan, K., Tung, A., Zhang, Z.: Finding k-dominant skylines in high dimensional space. In: Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data (2006) Chan, C., Jagadish, H., Tan, K., Tung, A., Zhang, Z.: Finding k-dominant skylines in high dimensional space. In: Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data (2006)
9.
Zurück zum Zitat Chan, C., Jagadish, H., Tan, K., Tung, A., Zhang, Z.: On high dimensional skylines. In: Advances in Database Technology-EDBT 2006 (2006) Chan, C., Jagadish, H., Tan, K., Tung, A., Zhang, Z.: On high dimensional skylines. In: Advances in Database Technology-EDBT 2006 (2006)
10.
Zurück zum Zitat Chang, Y., Bergman, L., Castelli, V., Li, C., Lo, M., Smith, J.: The onion technique: Indexing for linear optimization queries. In: Proceedings of the 2000 SIGMOD International Conference on Management of Data (2000)CrossRef Chang, Y., Bergman, L., Castelli, V., Li, C., Lo, M., Smith, J.: The onion technique: Indexing for linear optimization queries. In: Proceedings of the 2000 SIGMOD International Conference on Management of Data (2000)CrossRef
11.
Zurück zum Zitat Chester, S., Thomo, A., Venkatesh, S., Whitesides, S.: Computing k-regret minimizing sets. In: Proceedings of the VLDB Endowment (2014) Chester, S., Thomo, A., Venkatesh, S., Whitesides, S.: Computing k-regret minimizing sets. In: Proceedings of the VLDB Endowment (2014)
12.
Zurück zum Zitat Dong, Q., Zheng, J., Qiu, X., Huang, X.: Efficient approximate algorithms for k-regret queries with binary constraints. In: International Conference on Web Information Systems and Applications (2018) Dong, Q., Zheng, J., Qiu, X., Huang, X.: Efficient approximate algorithms for k-regret queries with binary constraints. In: International Conference on Web Information Systems and Applications (2018)
13.
Zurück zum Zitat Faulkner, T.K., Brackenbury, W., Lall, A.: K-regret queries with nonlinear utilities. In: Proceedings of the VLDB Endowment (2015) Faulkner, T.K., Brackenbury, W., Lall, A.: K-regret queries with nonlinear utilities. In: Proceedings of the VLDB Endowment (2015)
14.
Zurück zum Zitat Goncalves, M., Yidal, M.: Top-k skyline: a unified approach. In: On the Move to Meaningful Internet System 2005: OTM 2005 workshops (2005)CrossRef Goncalves, M., Yidal, M.: Top-k skyline: a unified approach. In: On the Move to Meaningful Internet System 2005: OTM 2005 workshops (2005)CrossRef
15.
Zurück zum Zitat Han, S., Zheng, H., Dong, Q.: Efficient processing of k-regret queries via skyline priority. In: International Conference on Web Information Systems and Applications (2018) Han, S., Zheng, H., Dong, Q.: Efficient processing of k-regret queries via skyline priority. In: International Conference on Web Information Systems and Applications (2018)
16.
Zurück zum Zitat Han, S., Zheng, J., Dong, Q.: Efficient processing of k-regret queries via skyline frequency. In: International Conference on Web Information Systems and Applications (2018) Han, S., Zheng, J., Dong, Q.: Efficient processing of k-regret queries via skyline frequency. In: International Conference on Web Information Systems and Applications (2018)
17.
Zurück zum Zitat Hussain, Z., Khan, H., Sharaf, M.: Diversifying with few regrets, but too few to mention. In: Proceedings of the Second International Workshop on Exploratory Search in Databases and the Web (2015) Hussain, Z., Khan, H., Sharaf, M.: Diversifying with few regrets, but too few to mention. In: Proceedings of the Second International Workshop on Exploratory Search in Databases and the Web (2015)
18.
Zurück zum Zitat Il’ev, V.: An approximation guarantee of the greedy descent algorithm for minimizing a supermodular set function. Discrete Appl. Math. 114, 131–146 (2001)MathSciNetCrossRef Il’ev, V.: An approximation guarantee of the greedy descent algorithm for minimizing a supermodular set function. Discrete Appl. Math. 114, 131–146 (2001)MathSciNetCrossRef
19.
Zurück zum Zitat Kenthapadi, K., Le, B., Venkataraman, G.: Personalized job recommendation system at LinkedIn: practical challenges and lessons learned. In: Proceedings of the 11th ACM Conference on Recommender Systems (2017) Kenthapadi, K., Le, B., Venkataraman, G.: Personalized job recommendation system at LinkedIn: practical challenges and lessons learned. In: Proceedings of the 11th ACM Conference on Recommender Systems (2017)
20.
Zurück zum Zitat Kleinberg, J., Tardos, E.: Algorithm Design. Addison Wesley, Boston (2006) Kleinberg, J., Tardos, E.: Algorithm Design. Addison Wesley, Boston (2006)
21.
Zurück zum Zitat Kumar, N., Sintos, S.: Faster approximation algorithm for the k-regret minimizing set and related problems. In: 2018 Proceedings of the Twentieth Workshop on Algorithm Engineering and Experiments (ALENEX) (2018)CrossRef Kumar, N., Sintos, S.: Faster approximation algorithm for the k-regret minimizing set and related problems. In: 2018 Proceedings of the Twentieth Workshop on Algorithm Engineering and Experiments (ALENEX) (2018)CrossRef
22.
Zurück zum Zitat Lee, J., You, G., Hwang, S.: Personalized top-k skyline queries in high-dimensional space. Inf. Syst. 34, 45–61 (2009)CrossRef Lee, J., You, G., Hwang, S.: Personalized top-k skyline queries in high-dimensional space. Inf. Syst. 34, 45–61 (2009)CrossRef
23.
Zurück zum Zitat Lian, X., Chen, L.: Top-k dominating queries in uncertain databases. In: Proceedings of International Conference on Extending Database Technology: Advances in Database Technology (2009) Lian, X., Chen, L.: Top-k dominating queries in uncertain databases. In: Proceedings of International Conference on Extending Database Technology: Advances in Database Technology (2009)
24.
Zurück zum Zitat Lin, X., Yuan, Y., Zhang, Q., Zhang, Y.: Selecting stars: The k most representative skyline operator. In: Proceedings of International Conference on Data Engineering (2007) Lin, X., Yuan, Y., Zhang, Q., Zhang, Y.: Selecting stars: The k most representative skyline operator. In: Proceedings of International Conference on Data Engineering (2007)
25.
Zurück zum Zitat McDonald, D., Ackerman, M.: Expertise recommender: a flexible recommendation system and architecture. In: Proceedings of the 2000 ACM conference on Computer supported cooperative work (2000) McDonald, D., Ackerman, M.: Expertise recommender: a flexible recommendation system and architecture. In: Proceedings of the 2000 ACM conference on Computer supported cooperative work (2000)
26.
Zurück zum Zitat Mindolin, D., Chomicki, J.: Discovering relative importance of skyline attributes. In: Proceedings of the VLDB Endowment (2009)CrossRef Mindolin, D., Chomicki, J.: Discovering relative importance of skyline attributes. In: Proceedings of the VLDB Endowment (2009)CrossRef
27.
Zurück zum Zitat Nanongkai, D., Lall, A., Sarma, A.D., Makino, K.: Interactive regret minimization. In: Proceedings of the 2012 ACM International Conference on Management of Data (2012) Nanongkai, D., Lall, A., Sarma, A.D., Makino, K.: Interactive regret minimization. In: Proceedings of the 2012 ACM International Conference on Management of Data (2012)
28.
Zurück zum Zitat Nanongkai, D., Sarma, A., Lall, A., Lipton, R., Xu, J.: Regret-minimizing representative databases. In: Proceedings of the VLDB Endowment (2010) Nanongkai, D., Sarma, A., Lall, A., Lipton, R., Xu, J.: Regret-minimizing representative databases. In: Proceedings of the VLDB Endowment (2010)
29.
Zurück zum Zitat Papadias, D., Tao, Y., Fu, G., Seeger, B.: Progressive skyline computation in database systems. ACM Trans. Database Syst. (TODS) 30, 41–82 (2005)CrossRef Papadias, D., Tao, Y., Fu, G., Seeger, B.: Progressive skyline computation in database systems. ACM Trans. Database Syst. (TODS) 30, 41–82 (2005)CrossRef
30.
Zurück zum Zitat Papadopoulos, A.N., Lyritsis, A., Nanopoulos, A., Manolopoulos, Y.: Domination mining and querying. In: DaWaK (2007) Papadopoulos, A.N., Lyritsis, A., Nanopoulos, A., Manolopoulos, Y.: Domination mining and querying. In: DaWaK (2007)
31.
Zurück zum Zitat Peng, P., Wong, R.: Geometry approach for k regret query. In: Proceedings of International Conference on Data Engineering (2014) Peng, P., Wong, R.: Geometry approach for k regret query. In: Proceedings of International Conference on Data Engineering (2014)
32.
Zurück zum Zitat Qi, J., Zuo, F., Samet, H., Yao, J.: K-regret queries using multiplicative utility functions. ACM Trans. Database Syst. TODS 43, 10 (2018)MathSciNet Qi, J., Zuo, F., Samet, H., Yao, J.: K-regret queries using multiplicative utility functions. ACM Trans. Database Syst. TODS 43, 10 (2018)MathSciNet
33.
Zurück zum Zitat Qiu, X., Zheng, J.: An efficient algorithm for computing k-average-regret minimizing sets in databases. In: International Conference on Web Information Systems and Applications (2018) Qiu, X., Zheng, J.: An efficient algorithm for computing k-average-regret minimizing sets in databases. In: International Conference on Web Information Systems and Applications (2018)
34.
Zurück zum Zitat Qiu, X., Zheng, J., Dong, Q., Huang, X.: Speed-up algorithms for happiness-maximizing representative databases. In: Asia-Pacific Web (APWeb) and Web-Age Information Management (WAIM) Joint International Conference on Web and Big Data (2018)CrossRef Qiu, X., Zheng, J., Dong, Q., Huang, X.: Speed-up algorithms for happiness-maximizing representative databases. In: Asia-Pacific Web (APWeb) and Web-Age Information Management (WAIM) Joint International Conference on Web and Big Data (2018)CrossRef
35.
Zurück zum Zitat Roshdi, A., Roohparvar, A.: Information retrieval techniques and applications. Int. J. Comput. Netw. Commun. Secur. 3, 373–377 (2015) Roshdi, A., Roohparvar, A.: Information retrieval techniques and applications. Int. J. Comput. Netw. Commun. Secur. 3, 373–377 (2015)
36.
Zurück zum Zitat Russell, S., Norvig, P.: Artificial Intelligence: A Modern Approach. Pearson Education Limited, Malaysia (2016)MATH Russell, S., Norvig, P.: Artificial Intelligence: A Modern Approach. Pearson Education Limited, Malaysia (2016)MATH
37.
Zurück zum Zitat Salton, G., McGill, M.: Introduction to Modern Information Retrieval. McGraw-Hill, New York (1986)MATH Salton, G., McGill, M.: Introduction to Modern Information Retrieval. McGraw-Hill, New York (1986)MATH
38.
Zurück zum Zitat Soliman, M., Ilyas, I., Chang, K.C.C.: Top-k query processing in uncertain databases. In: Proceedings of International Conference on Data Engineering (2007) Soliman, M., Ilyas, I., Chang, K.C.C.: Top-k query processing in uncertain databases. In: Proceedings of International Conference on Data Engineering (2007)
39.
Zurück zum Zitat Soma, T., Yoshida, Y.: Regret ratio minimization in multi-objective submodular function maximization. In: AAAI (2017) Soma, T., Yoshida, Y.: Regret ratio minimization in multi-objective submodular function maximization. In: AAAI (2017)
40.
Zurück zum Zitat Tao, Y., Ding, L., Pei, J.: Distance-based representative skyline. In: Proceedings of International Conference on Data Engineering (2009) Tao, Y., Ding, L., Pei, J.: Distance-based representative skyline. In: Proceedings of International Conference on Data Engineering (2009)
41.
Zurück zum Zitat Varian, H.: Microeconomic Analysis. Norton and Company, New York (1992) Varian, H.: Microeconomic Analysis. Norton and Company, New York (1992)
42.
Zurück zum Zitat Walter, F., Battiston, S., Schweitzer, F.: A model of a trust-based recommendation system on a social network. Auton. Agents Multi-Agent Syst. 16, 57–74 (2008)CrossRef Walter, F., Battiston, S., Schweitzer, F.: A model of a trust-based recommendation system on a social network. Auton. Agents Multi-Agent Syst. 16, 57–74 (2008)CrossRef
43.
Zurück zum Zitat Xie, M., Wong, R., Lall, A.: Strongly truthful interactive regret minimization. In: Proceedings of the 2019 ACM International Conference on Management of Data (2019) Xie, M., Wong, R., Lall, A.: Strongly truthful interactive regret minimization. In: Proceedings of the 2019 ACM International Conference on Management of Data (2019)
44.
Zurück zum Zitat Xie, M., Wong, R., Li, J., Long, C., Lall, A.: Efficient k-regret query algorithm with restriction-free bound for any dimensionality. In: Proceedings of the 2018 ACM International Conference on Management of Data (2018) Xie, M., Wong, R., Li, J., Long, C., Lall, A.: Efficient k-regret query algorithm with restriction-free bound for any dimensionality. In: Proceedings of the 2018 ACM International Conference on Management of Data (2018)
45.
Zurück zum Zitat Yu, H., Agarwal, P., Varadarajan, R.P.K.: Practical methods for shape fitting and kinetic data structures using coresets. Algorithmica 52(3), 378–402 (2008)MathSciNetCrossRef Yu, H., Agarwal, P., Varadarajan, R.P.K.: Practical methods for shape fitting and kinetic data structures using coresets. Algorithmica 52(3), 378–402 (2008)MathSciNetCrossRef
46.
Zurück zum Zitat Zeighami, S., Wong, R.: Minimizing average regret ratio in database. In: Proceedings of the 2016 International Conference on Management of Data (2016) Zeighami, S., Wong, R.: Minimizing average regret ratio in database. In: Proceedings of the 2016 International Conference on Management of Data (2016)
47.
Zurück zum Zitat Zeighami, S., Wong, R.: Finding average regret ratio minimizing set in database. In: Proceedings of 35th International Conference on Data Engineering (2019) Zeighami, S., Wong, R.: Finding average regret ratio minimizing set in database. In: Proceedings of 35th International Conference on Data Engineering (2019)
Metadaten
Titel
An experimental survey of regret minimization query and variants: bridging the best worlds between top-k query and skyline query
verfasst von
Min Xie
Raymond Chi-Wing Wong
Ashwin Lall
Publikationsdatum
14.09.2019
Verlag
Springer Berlin Heidelberg
Erschienen in
The VLDB Journal / Ausgabe 1/2020
Print ISSN: 1066-8888
Elektronische ISSN: 0949-877X
DOI
https://doi.org/10.1007/s00778-019-00570-z

Weitere Artikel der Ausgabe 1/2020

The VLDB Journal 1/2020 Zur Ausgabe