Skip to main content
Erschienen in: World Wide Web 6/2016

01.11.2016

Efficient group-by reverse skyline computation

verfasst von: Zonghui Wang, Yunjun Gao, Qing Liu, Xiaoye Miao, Qing Li, Chuan Li

Erschienen in: World Wide Web | Ausgabe 6/2016

Einloggen

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

search-config
loading …

Abstract

The reverse skyline query is very useful in many decision making applications. Given a multi-dimensional dataset P and a query point q, the reverse skyline query returns all the points in P whose dynamic skyline contains q. Although the reverse skyline retrieval has been well-studied in the literature, there is, to the best of our knowledge, no prior work on one of the most intuitive and practical types of reverse skyline queries, namely, group-by reverse skyline (GRS) query, which retrieves the reverse skyline for each group in a specified dataset. We formalize the GRS query including monochromatic and bichromatic versions, and identify its properties, and then propose a set of efficient algorithms for computing the group-by reverse skyline. Extensive experimental evaluation using both real and synthetic datasets demonstrates the performance of our proposed algorithms in terms of effectiveness and efficiency under a variety of experimental settings.

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

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!

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!

Literatur
1.
Zurück zum Zitat Bartolini, I., Ciaccia, P., Patella, M.: Efficient sort-based skyline evaluation. ACM Trans. Database Syst. 33(4), 1–45 (2008)CrossRef Bartolini, I., Ciaccia, P., Patella, M.: Efficient sort-based skyline evaluation. ACM Trans. Database Syst. 33(4), 1–45 (2008)CrossRef
2.
Zurück zum Zitat Beckmann, N., Kriegel, H.P., Schneider, R., Seeger, B.: The R*-tree: An efficient and robust access method for points and rectangles. In: SIGMOD, pp. 322–331 (1990) Beckmann, N., Kriegel, H.P., Schneider, R., Seeger, B.: The R*-tree: An efficient and robust access method for points and rectangles. In: SIGMOD, pp. 322–331 (1990)
3.
Zurück zum Zitat Borzsonyi, S., Kossmann, D., Stocker, K.: The skyline operator. In: ICDE, pp. 421–430 (2001) Borzsonyi, S., Kossmann, D., Stocker, K.: The skyline operator. In: ICDE, pp. 421–430 (2001)
4.
Zurück zum Zitat Chen, L., Lian, X.: Dynamic skyline queries in metric spaces. In: EDBT, pp. 333–343 (2008) Chen, L., Lian, X.: Dynamic skyline queries in metric spaces. In: EDBT, pp. 333–343 (2008)
5.
Zurück zum Zitat Chomicki, J., Godfrey, P., Gryz, J., Liang, D.: Skyline with presorting. In: ICDE, pp. 717–719 (2003) Chomicki, J., Godfrey, P., Gryz, J., Liang, D.: Skyline with presorting. In: ICDE, pp. 717–719 (2003)
6.
Zurück zum Zitat Dellis, E., Seeger, B.: Efficient computation of reverse skyline queries. In: VLDB, pp. 291–302 (2007) Dellis, E., Seeger, B.: Efficient computation of reverse skyline queries. In: VLDB, pp. 291–302 (2007)
7.
Zurück zum Zitat Dellis, E., Vlachou, A., Vladimirskiy, I., Seeger, B., Theodoridis, Y.: Constrained subspace skyline computation. In: CIKM, pp. 415–424 (2006) Dellis, E., Vlachou, A., Vladimirskiy, I., Seeger, B., Theodoridis, Y.: Constrained subspace skyline computation. In: CIKM, pp. 415–424 (2006)
8.
Zurück zum Zitat Fuhry, D., Jin, R., Zhang, D.: Efficient skyline computation in metric space. In: EDBT, pp. 1042–1051 (2009) Fuhry, D., Jin, R., Zhang, D.: Efficient skyline computation in metric space. In: EDBT, pp. 1042–1051 (2009)
9.
Zurück zum Zitat Gao, Y., Liu, Q., Zheng, B., Chen, G.: On efficient reverse skyline query processing. Expert Syst. Appl. 41(7), 3237–3249 (2014)CrossRef Gao, Y., Liu, Q., Zheng, B., Chen, G.: On efficient reverse skyline query processing. Expert Syst. Appl. 41(7), 3237–3249 (2014)CrossRef
10.
Zurück zum Zitat Godfrey, P., Shipley, R., Gryz, J.: Maximal vector computation in large data sets. In: VLDB, pp. 229–240 (2005) Godfrey, P., Shipley, R., Gryz, J.: Maximal vector computation in large data sets. In: VLDB, pp. 229–240 (2005)
11.
Zurück zum Zitat Huang, Z., Lu, H., Ooi, B.C., Tung, A.K.H.: Continuous skyline queries for moving objects. TKDE 18(12), 1645–1658 (2006) Huang, Z., Lu, H., Ooi, B.C., Tung, A.K.H.: Continuous skyline queries for moving objects. TKDE 18(12), 1645–1658 (2006)
12.
Zurück zum Zitat Huang, Z., Wang, W.: A novel incremental maintenance algorithm of skycube. In: DEXA, pp. 781–790 (2006) Huang, Z., Wang, W.: A novel incremental maintenance algorithm of skycube. In: DEXA, pp. 781–790 (2006)
13.
Zurück zum Zitat Huang, Z., Xiang, Y., Zhang, B., Liu, X.: A clustering based approach for skyline diversity. Expert Syst. Appl. 38, 7984–7993 (2011)CrossRef Huang, Z., Xiang, Y., Zhang, B., Liu, X.: A clustering based approach for skyline diversity. Expert Syst. Appl. 38, 7984–7993 (2011)CrossRef
15.
Zurück zum Zitat Jiang, T., Gao, Y., Zhang, B., Lin, D., Li, Q.: Monochromatic and bichromatic mutual skyline queries. Expert Syst. Appl. 41(4), 1885–1900 (2014)CrossRef Jiang, T., Gao, Y., Zhang, B., Lin, D., Li, Q.: Monochromatic and bichromatic mutual skyline queries. Expert Syst. Appl. 41(4), 1885–1900 (2014)CrossRef
16.
Zurück zum Zitat Kossmann, D., Ramsak, F., Rost, S.: Shooting stars in the sky: An online algorithm for skyline queries. In: VLDB, pp. 275–286 (2002) Kossmann, D., Ramsak, F., Rost, S.: Shooting stars in the sky: An online algorithm for skyline queries. In: VLDB, pp. 275–286 (2002)
17.
18.
Zurück zum Zitat Lee, J., Hwang, S. Qskycube: Efficient skycube computation using point-based space partitioning. In: VLDB, 185–196 (2010) Lee, J., Hwang, S. Qskycube: Efficient skycube computation using point-based space partitioning. In: VLDB, 185–196 (2010)
19.
Zurück zum Zitat Lee, M.-W., Hwang, S.-W.: Continuous skylining on volatile moving data. In: ICDE, pp. 1568–1575 (2009) Lee, M.-W., Hwang, S.-W.: Continuous skylining on volatile moving data. In: ICDE, pp. 1568–1575 (2009)
20.
Zurück zum Zitat Lee, K.C.K., Zheng, B., Li, H., Lee, W.-C.: Approaching the skyline in z order. In: VLDB, pp. 279–290 (2007) Lee, K.C.K., Zheng, B., Li, H., Lee, W.-C.: Approaching the skyline in z order. In: VLDB, pp. 279–290 (2007)
21.
Zurück zum Zitat Lian, X., Chen, L.: Reverse skyline search in uncertain databases. ACM Trans. Database Syst. 35(1), 3 (2010)CrossRef Lian, X., Chen, L.: Reverse skyline search in uncertain databases. ACM Trans. Database Syst. 35(1), 3 (2010)CrossRef
22.
Zurück zum Zitat Lin, X., Yuan, Y., Wang, W., Lu, H.: Stabbing the sky: Efficient skyline computation over sliding windows. In: ICDE, pp. 502–513 (2005) Lin, X., Yuan, Y., Wang, W., Lu, H.: Stabbing the sky: Efficient skyline computation over sliding windows. In: ICDE, pp. 502–513 (2005)
23.
Zurück zum Zitat Liu, Q., Gao, Y., Chen, G., Li, Q., Jiang, T.: On efficient reverse k-skyband query processing. In: DASFAA, pp. 544–559 (2012) Liu, Q., Gao, Y., Chen, G., Li, Q., Jiang, T.: On efficient reverse k-skyband query processing. In: DASFAA, pp. 544–559 (2012)
24.
Zurück zum Zitat Lu, Y., Zhao, J., Chen, L., Cui, B., Yang, D.: Effective skyline cardinality estimation on data streams. In: DEXA, pp. 241–254 (2008) Lu, Y., Zhao, J., Chen, L., Cui, B., Yang, D.: Effective skyline cardinality estimation on data streams. In: DEXA, pp. 241–254 (2008)
25.
Zurück zum Zitat Luk, M., Yiu, M., Lo, E.: Group-by skyline query processing in relational engines. In: CIKM, pp. 1433–1436 (2009) Luk, M., Yiu, M., Lo, E.: Group-by skyline query processing in relational engines. In: CIKM, pp. 1433–1436 (2009)
26.
Zurück zum Zitat Morse, M., Patel, J.M., Grosky, W.I.: Efficient continuous skyline computation. Inform. Sci. 177(17), 3411–3437 (2007)MathSciNetCrossRef Morse, M., Patel, J.M., Grosky, W.I.: Efficient continuous skyline computation. Inform. Sci. 177(17), 3411–3437 (2007)MathSciNetCrossRef
27.
Zurück zum Zitat Papadias, D., Tao, Y., Fu, G., Seeger, B.: Progressive skyline computation in database systems. ACM Trans. Database Syst. 30(1), 41–82 (2005)CrossRef Papadias, D., Tao, Y., Fu, G., Seeger, B.: Progressive skyline computation in database systems. ACM Trans. Database Syst. 30(1), 41–82 (2005)CrossRef
28.
Zurück zum Zitat Pei, J., Jiang, B., Lin, X., Yuan, Y.: Probabilistic skylines on uncertain data. In: VLDB, pp. 15–26 (2007) Pei, J., Jiang, B., Lin, X., Yuan, Y.: Probabilistic skylines on uncertain data. In: VLDB, pp. 15–26 (2007)
29.
Zurück zum Zitat Pei, J., Jin, W., Ester, M., Tao, Y.: Catching the best views of skyline: A semantic approach based on decisive subspaces. In: VLDB, pp. 253–264 (2005) Pei, J., Jin, W., Ester, M., Tao, Y.: Catching the best views of skyline: A semantic approach based on decisive subspaces. In: VLDB, pp. 253–264 (2005)
30.
Zurück zum Zitat Pei, J., Yuan, Y., Lin, X., Jin, W., Ester, M., Liu, Q.: Towards multidimensional subspace skyline analysis. ACM Trans. Database Syst. 31(4), 1335–1381 (2006)CrossRef Pei, J., Yuan, Y., Lin, X., Jin, W., Ester, M., Liu, Q.: Towards multidimensional subspace skyline analysis. ACM Trans. Database Syst. 31(4), 1335–1381 (2006)CrossRef
31.
Zurück zum Zitat Prasad, M.D., Deepak, P.: Efficient reverse skyline retrieval with arbitrary non-metric similarity measures. In: EDBT, pp. 319–330 (2011) Prasad, M.D., Deepak, P.: Efficient reverse skyline retrieval with arbitrary non-metric similarity measures. In: EDBT, pp. 319–330 (2011)
32.
Zurück zum Zitat Raissi, C., Pei, J., Kister, T.: Computing closed skycubes. In: VLDB, pp. 838–847 (2010) Raissi, C., Pei, J., Kister, T.: Computing closed skycubes. In: VLDB, pp. 838–847 (2010)
33.
Zurück zum Zitat Sarkas, N., Das, G., Koudas, N., Tung, A.K.H.: Categorical skylines for streaming data. In: SIGMOD, pp. 239–250 (2008) Sarkas, N., Das, G., Koudas, N., Tung, A.K.H.: Categorical skylines for streaming data. In: SIGMOD, pp. 239–250 (2008)
34.
Zurück zum Zitat Tan, K.-L., Eng, P.-K., Ooi, B.C.: Efficient progressive skyline computation. In: VLDB, pp. 301–310 (2001) Tan, K.-L., Eng, P.-K., Ooi, B.C.: Efficient progressive skyline computation. In: VLDB, pp. 301–310 (2001)
35.
Zurück zum Zitat Tao, Y., Papadias, D.: Maintaining sliding window skylines data streams. IEEE Trans. Knowl. Data Eng. 18(3), 377–391 (2006)CrossRef Tao, Y., Papadias, D.: Maintaining sliding window skylines data streams. IEEE Trans. Knowl. Data Eng. 18(3), 377–391 (2006)CrossRef
36.
Zurück zum Zitat Tao, Y., Xiao, X., Pei, J.: Subsky: efficient computation of skylines in subspaces. In: ICDE, pp. 65 (2006) Tao, Y., Xiao, X., Pei, J.: Subsky: efficient computation of skylines in subspaces. In: ICDE, pp. 65 (2006)
37.
Zurück zum Zitat Vlachou, A., Doulkeridis, C., Kotidis, Y., Vazirgiannis, M.: SKYPEER: efficient subspace skyline computation over distributed data. In: ICDE, pp. 416–425 (2007) Vlachou, A., Doulkeridis, C., Kotidis, Y., Vazirgiannis, M.: SKYPEER: efficient subspace skyline computation over distributed data. In: ICDE, pp. 416–425 (2007)
38.
Zurück zum Zitat Wang, G., Xin, J., Chen, L., Liu, Y.: Energy-efficient reverse skyline queries processing over wireless sensor networks. IEEE Trans. Knowl. Data Eng. 24(7), 1259–1275 (2012)CrossRef Wang, G., Xin, J., Chen, L., Liu, Y.: Energy-efficient reverse skyline queries processing over wireless sensor networks. IEEE Trans. Knowl. Data Eng. 24(7), 1259–1275 (2012)CrossRef
39.
Zurück zum Zitat Wu, X., Tao, Y., Wong, R.C.-W., Ding, L., Yu, J.X.: Finding the influence set through skylines. In: EDBT, pp. 1030–1041 (2009) Wu, X., Tao, Y., Wong, R.C.-W., Ding, L., Yu, J.X.: Finding the influence set through skylines. In: EDBT, pp. 1030–1041 (2009)
40.
Zurück zum Zitat Xia, T., Zhang, D.: Refreshing the sky: the compressed skycube with efficient support for frequent updates. In: SIGMOD, pp. 491–502 (2006) Xia, T., Zhang, D.: Refreshing the sky: the compressed skycube with efficient support for frequent updates. In: SIGMOD, pp. 491–502 (2006)
41.
Zurück zum Zitat Yiu, M., Lo, E., Yung, D.: Measuring the sky: on computing data cubes via skylining the measures. IEEE Trans. Knowl. Data Eng. 24(3), 492–505 (2012)CrossRef Yiu, M., Lo, E., Yung, D.: Measuring the sky: on computing data cubes via skylining the measures. IEEE Trans. Knowl. Data Eng. 24(3), 492–505 (2012)CrossRef
42.
Zurück zum Zitat Yong, H., Kim, J., Hwang, S.: Skyline ranking for uncertain data with maybe confidence. In: ICDE, pp. 572–579 (2008) Yong, H., Kim, J., Hwang, S.: Skyline ranking for uncertain data with maybe confidence. In: ICDE, pp. 572–579 (2008)
43.
Zurück zum Zitat Yuan, Y., Lin, X., Liu, Q., Wang, W., Yu, J.X., Zhang, Q.: Efficient computation of the skyline cube. In: VLDB, pp. 241–252 (2005) Yuan, Y., Lin, X., Liu, Q., Wang, W., Yu, J.X., Zhang, Q.: Efficient computation of the skyline cube. In: VLDB, pp. 241–252 (2005)
44.
Zurück zum Zitat Zhang, Z., Cheng, R., Papadias, D., Tung, A.K.H.: Minimizing the communication cost for continuous skyline maintenance. In: SIGMOD, pp. 495–508 (2009) Zhang, Z., Cheng, R., Papadias, D., Tung, A.K.H.: Minimizing the communication cost for continuous skyline maintenance. In: SIGMOD, pp. 495–508 (2009)
45.
Zurück zum Zitat Zhang, W., Lin, X., Zhang, Y., Wang, W., Yu, J.X.: Probabilistic skyline operator over sliding windows. In: ICDE, pp. 1060–1071 (2009) Zhang, W., Lin, X., Zhang, Y., Wang, W., Yu, J.X.: Probabilistic skyline operator over sliding windows. In: ICDE, pp. 1060–1071 (2009)
46.
Zurück zum Zitat Zhang, S., Mamoulis, N., Cheung, D.W.: Scalable skyline computation using object-based space partitioning. In: SIGMOD, pp. 483–494 (2009) Zhang, S., Mamoulis, N., Cheung, D.W.: Scalable skyline computation using object-based space partitioning. In: SIGMOD, pp. 483–494 (2009)
47.
Zurück zum Zitat Zhu, L., Li, C., Chen, H.: Efficient computation of reverse skyline on data stream. In: CSO, pp. 735–739 (2009) Zhu, L., Li, C., Chen, H.: Efficient computation of reverse skyline on data stream. In: CSO, pp. 735–739 (2009)
Metadaten
Titel
Efficient group-by reverse skyline computation
verfasst von
Zonghui Wang
Yunjun Gao
Qing Liu
Xiaoye Miao
Qing Li
Chuan Li
Publikationsdatum
01.11.2016
Verlag
Springer US
Erschienen in
World Wide Web / Ausgabe 6/2016
Print ISSN: 1386-145X
Elektronische ISSN: 1573-1413
DOI
https://doi.org/10.1007/s11280-015-0372-y

Weitere Artikel der Ausgabe 6/2016

World Wide Web 6/2016 Zur Ausgabe

Premium Partner