Efficient Approximate Algorithms for k-Regret Queries with Binary Constraints

  • Qi Dong
  • Jiping ZhengEmail author
  • Xianhong Qiu
  • Xingnan Huang
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 11242)


Extracting interesting points from a large dataset is an important problem for multi-criteria decision making. Recently, k-regret query was proposed and received attentions from the database community because it does not require any utility function from users and the output size is controllable. In this paper, we consider k-regret queries with binary constraints which doesn’t be addressed before. Given a collection of binary constraints, we study the problem of extracting the k representative points with small regret ratio while satisfying the binary constraints. To express the satisfaction of data points by the binary constraints, we propose two models named NBC and LBC in quantitative and qualitative ways respectively. In quantitative way, the satisfaction is expressed by a real number between 0 and 1 which quaNtifies the satisfaction of a point by the Binary Constraints. While in qualitative way, the satisfaction is modeled quaLitatively by a set of Binary Constraints which are satisfied by the point. Further, two efficient approximate algorithms called \(NBC_P\)-Greedy and \(NBC_{DN}\)-Greedy are developed based on NBC while \(LBC_{DN}\)-Greedy algorithm is proposed based on LBC. Extensive experiments on synthetic and real datasets confirm the efficiency and effectiveness of our proposed algorithms.


k-Regret query Binary constraints Multi-criteria decision making Top-k query Skyline query 



This work is partially supported by the National Natural Science Foundation of China under grants U1733112,61702260, the Natural Science Foundation of Jiangsu Province of China under grant BK20140826, the Fundamental Research Funds for the Central Universities under grant NS2015095, Funding of Graduate Innovation Center in NUAA under grant KFJJ20171605.


  1. 1.
    Agarwal, P.K., Kumar, N., Sintos, S., Suri, S.: Efficient algorithms for k-regret minimizing sets. In: International Symposium on Experimental Algorithms, pp. 7:1–7:23 (2017)Google Scholar
  2. 2.
    Asudeh, A., Nazi, A., Zhang, N., Das, G.: Efficient computation of regret-ratio minimizing set: a compact maxima representative. In: SIGMOD, pp. 821–834 (2017)Google Scholar
  3. 3.
    Borzsony, S., Kossmann, D., Stocker, K.: The skyline operator. In: ICDE, pp. 421–430 (2001)Google Scholar
  4. 4.
    Cao, W., et al.: k-regret minimizing set: efficient algorithms and hardness. In: ICDT, pp. 11:1–11:19 (2017)Google Scholar
  5. 5.
    Chan, C.-Y., Jagadish, H.V., Tan, K.-L., Tung, A.K.H., Zhang, Z.: Finding k-dominant skylines in high dimensional space. In: SIGMOD, pp. 503–514 (2006)Google Scholar
  6. 6.
    Chester, S., Thomo, A., Venkatesh, S., Whitesides, S.: Computing k-regret minimizing sets. In: VLDB, pp. 389–400 (2014)CrossRefGoogle Scholar
  7. 7.
    Faulkner, T.K., Brackenbury, W., Lall, A.: k-regret queries with nonlinear utilities. In: VLDB, pp. 2098–2109 (2015)Google Scholar
  8. 8.
    Guha, S., Gunopoulos, D., Vlachos, M., Koudas, N., Srivastava, D.: Efficient approximation of optimization queries under parametric aggregation constraints. In: VLDB, pp. 778–789 (2003)CrossRefGoogle Scholar
  9. 9.
    Ilyas, I.F., Beskales, G., Soliman, M.A.: A survey of top-k query processing techniques in relational database systems. ACM Comput. Surv. 40(4), 11:1–11:58 (2008)CrossRefGoogle Scholar
  10. 10.
    Khan, A., Singh, V.: Top-k representative queries with binary constraints. In: SSDBM, pp. 13:1–13:10 (2015)Google Scholar
  11. 11.
    Lee, J., won You, G., won Hwang, S.: Personalized top-k skyline queries in high-dimensional space. Inf. Syst. 34(1), 45–61 (2009)CrossRefGoogle Scholar
  12. 12.
    Lin, X., Yuan, Y., Zhang, Q., Zhang, Y.: Selecting stars: the k most representative skyline operator. In: ICDE, pp. 86–95 (2007)Google Scholar
  13. 13.
    Mindolin, D., Chomicki, J.: Discovering relative importance of skyline attributes. In: VLDB, pp. 610–621 (2009)CrossRefGoogle Scholar
  14. 14.
    Nanongkai, D., Lall, A., Das Sarma, A., Makino, K.: Interactive regret minimization. In: SIGMOD, pp. 109–120 (2012)Google Scholar
  15. 15.
    Nanongkai, D., Sarma, A.D., Lall, A., Lipton, R.J., Xu, J.: Regret-minimizing representative databases. VLDB 3(1–2), 1114–1124 (2010)Google Scholar
  16. 16.
    Papadias, D., Tao, Y., Fu, G., Seeger, B.: Progressive skyline computation in database systems. TODS 30(1), 41–82 (2005)CrossRefGoogle Scholar
  17. 17.
    Papadimitriou, C.H., Yannakakis, M.: On the approximability of trade-offs and optimal access of web sources. In: FOCS, pp. 86–92 (2000)Google Scholar
  18. 18.
    Peng, P., Wong, R.C.W.: Geometry approach for k-regret query. In: ICDE, pp. 772–783 (2014)Google Scholar
  19. 19.
    Tao, Y., Ding, L., Lin, X., Pei, J.: Distance-based representative skyline. In: ICDE, pp. 892–903 (2009)Google Scholar
  20. 20.
    Xie, M., Wong, R.C.-W., Li, J., Long, C., Lall, A.: Efficient k-regret query algorithm with restriction-free bound for any dimensionality. In: Proceedings of the 2018 International Conference on Management of Data, pp. 959–974 (2018)Google Scholar
  21. 21.
    Zhang, Z., Hwang, S.W., Chang, C.C., Wang, M., Lang, C.A., Chang, Y.C.: Boolean + ranking: querying a database by k-constrained optimization. In: SIGMOD, pp. 359–370 (2006)Google Scholar

Copyright information

© Springer Nature Switzerland AG 2018

Authors and Affiliations

  • Qi Dong
    • 1
  • Jiping Zheng
    • 1
    • 2
    Email author
  • Xianhong Qiu
    • 1
  • Xingnan Huang
    • 1
  1. 1.College of Computer Science and TechnologyNanjing University of Aeronautics and AstronauticsNanjingChina
  2. 2.Collaborative Innovation Center of Novel Software Technology and IndustrializationNanjingChina

Personalised recommendations