Skip to main content
Erschienen in: Knowledge and Information Systems 6/2021

09.04.2021 | Regular Paper

Progressive approaches to flexible group skyline queries

verfasst von: Zhibang Yang, Xu Zhou, Kenli Li, Yunjun Gao, Keqin Li

Erschienen in: Knowledge and Information Systems | Ausgabe 6/2021

Einloggen

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

search-config
loading …

Abstract

The G-Skyline (GSky) query is formulated to report optimal groups that are not dominated by any other group of the same size. Particularly, a given group \(G_1\) dominates another group \(G_2\) if for any point \(p\in G_1\), p dominates or equals to points \(p{'}\in G_2\); at the same time, there is at least one point p dominating \(p{'}\). Most existing group skyline queries need to calculate an aggregate point for each group. Compared to these queries, the GSky query is more practical because it avoids specifying an aggregate function which leads to miss important results containing non-skyline points. This means the GSky query can get much more comprehensive query results which not only contain the G-Skylines consisting of skyline points but also the G-Skylines including non-skyline points. Here, a non-skyline point is dominated by another point in a given data set. However, the GSky query usually returns too many results, making it a big burden for users to pick out their expected results. To address these issues, we investigate a flexible group skyline query, namely Flexible G-Skyline (FGSky) query, which is flexible and practical for directly computing the optimal groups on the basis of user preferences. In this paper, we formulate the FGSky query, identify its properties, and present effective pruning strategies. Besides, we propose progressive algorithms for the FGSky query where a grouping strategy and a layered strategy are utilized to get better query performance. Through extensive experiments on both synthetic and real data sets, we demonstrate the efficiency, effectiveness, and progressiveness of the proposed algorithms.

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 "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 "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 Borzsony S, Kossmann D, Stocker K (2001) The skyline operator. In: Proceedings of the international conference on data engineering, pp 421–430 Borzsony S, Kossmann D, Stocker K (2001) The skyline operator. In: Proceedings of the international conference on data engineering, pp 421–430
2.
Zurück zum Zitat Chung Y-C, Su I-F, Lee C (2013) Efficient computation of combinatorial skyline queries. Inf Syst 38(3):369–387CrossRef Chung Y-C, Su I-F, Lee C (2013) Efficient computation of combinatorial skyline queries. Inf Syst 38(3):369–387CrossRef
4.
Zurück zum Zitat Magnani M, Assent I (2013) From stars to galaxies: skyline queries on aggregate data. In: Proceedings of the international conference on extending database technology. ACM, pp 477–488 Magnani M, Assent I (2013) From stars to galaxies: skyline queries on aggregate data. In: Proceedings of the international conference on extending database technology. ACM, pp 477–488
5.
Zurück zum Zitat Zhang N, Li C, Hassan N, Rajasekaran S, Das G (2014) On skyline groups. IEEE Trans Knowl Data Eng 26(4):942–956CrossRef Zhang N, Li C, Hassan N, Rajasekaran S, Das G (2014) On skyline groups. IEEE Trans Knowl Data Eng 26(4):942–956CrossRef
6.
Zurück zum Zitat Liu J, Xiong L, Pei J, Luo J, Zhang H (2015) Finding pareto optimal groups: group-based skyline. In: Proceedings of the international conference on very large data bases, vol 8, no 13 Liu J, Xiong L, Pei J, Luo J, Zhang H (2015) Finding pareto optimal groups: group-based skyline. In: Proceedings of the international conference on very large data bases, vol 8, no 13
7.
Zurück zum Zitat Xu Z, Li K, Yang Z, Xiao G, Li K (2018) Progressive approaches for pareto optimal groups computation. IEEE Trans Knowl Data Eng 99:1CrossRef Xu Z, Li K, Yang Z, Xiao G, Li K (2018) Progressive approaches for pareto optimal groups computation. IEEE Trans Knowl Data Eng 99:1CrossRef
8.
Zurück zum Zitat Wang C, Wang C, Guo G, Ye X, Yu PS (2018) Efficient computation of g-skyline groups. IEEE Trans Knowl Data Eng 30(4):674–688CrossRef Wang C, Wang C, Guo G, Ye X, Yu PS (2018) Efficient computation of g-skyline groups. IEEE Trans Knowl Data Eng 30(4):674–688CrossRef
9.
Zurück zum Zitat He Z, Lo E (2012) Answering why-not questions on top \(k\) queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 750–761 He Z, Lo E (2012) Answering why-not questions on top \(k\) queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 750–761
10.
Zurück zum Zitat Islam MS, Zhou R, Liu C (2013) On answering why-not questions in reverse skyline queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 973–984 Islam MS, Zhou R, Liu C (2013) On answering why-not questions in reverse skyline queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 973–984
11.
Zurück zum Zitat Gao Y, Liu Q, Chen G, Zheng B, Zhou L (2015) Answering why-not questions on reverse top \(k\) queries. In: Proceedings of the international conference on very large data bases (VLDB), vol 8(7), pp 738–749 Gao Y, Liu Q, Chen G, Zheng B, Zhou L (2015) Answering why-not questions on reverse top \(k\) queries. In: Proceedings of the international conference on very large data bases (VLDB), vol 8(7), pp 738–749
12.
Zurück zum Zitat Chen L, Lin X, Hu H, Jensen CS, Xu J (2015) Answering why-not questions on spatial keyword top \(k\) queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 279–290 Chen L, Lin X, Hu H, Jensen CS, Xu J (2015) Answering why-not questions on spatial keyword top \(k\) queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 279–290
13.
Zurück zum Zitat Liu Q, Gao Y, Zheng B, Zhou L (2016) Answering why-not and why questions on reverse top \(k\) queries. VLDB J 25(6):867–892CrossRef Liu Q, Gao Y, Zheng B, Zhou L (2016) Answering why-not and why questions on reverse top \(k\) queries. VLDB J 25(6):867–892CrossRef
14.
Zurück zum Zitat Islam MS, Liu C, Li J (2016) Efficient answering of why-not questions in similar graph matching. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 2672–2686 Islam MS, Liu C, Li J (2016) Efficient answering of why-not questions in similar graph matching. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 2672–2686
15.
Zurück zum Zitat Chen L, Xu J, Jensen CS, Li Y (2016) Yask: a why-not question answering engine for spatial keyword query services. In: Proceedings of the international conference on very large data bases (VLDB), vol 9(13), pp 1501–1504 Chen L, Xu J, Jensen CS, Li Y (2016) Yask: a why-not question answering engine for spatial keyword query services. In: Proceedings of the international conference on very large data bases (VLDB), vol 9(13), pp 1501–1504
16.
Zurück zum Zitat Tran QT, Chan CY (2010) How to conquer why-not questions. In: Proceedings of the ACM SIGMOD international conference on management of data (SIGMOD) Tran QT, Chan CY (2010) How to conquer why-not questions. In: Proceedings of the ACM SIGMOD international conference on management of data (SIGMOD)
17.
Zurück zum Zitat Wan Q, Wong RC-W, Ilyas IF, Özsu MT, Peng Y (2009) Creating competitive products. Proc VLDB Endow 2(1):898–909CrossRef Wan Q, Wong RC-W, Ilyas IF, Özsu MT, Peng Y (2009) Creating competitive products. Proc VLDB Endow 2(1):898–909CrossRef
18.
Zurück zum Zitat Su I-F, Chung Y-C, Lee C (2010) Top-k combinatorial skyline queries. In: Database systems for advanced applications. Springer, pp 79–93 Su I-F, Chung Y-C, Lee C (2010) Top-k combinatorial skyline queries. In: Database systems for advanced applications. Springer, pp 79–93
19.
Zurück zum Zitat Zhou X, Li K, Yang Z, Xiao G, Li K (2018) Progressive approaches for pareto optimal groups computation. IEEE Trans Knowl Data Eng 31(3):521–534CrossRef Zhou X, Li K, Yang Z, Xiao G, Li K (2018) Progressive approaches for pareto optimal groups computation. IEEE Trans Knowl Data Eng 31(3):521–534CrossRef
20.
Zurück zum Zitat Zhu H, Zhu P, Li X, Liu Q, Xun P (2017) Parallelization of group-based skyline computation for multi-core processors. Concurr Comput Pract Exp 29(3):e4195CrossRef Zhu H, Zhu P, Li X, Liu Q, Xun P (2017) Parallelization of group-based skyline computation for multi-core processors. Concurr Comput Pract Exp 29(3):e4195CrossRef
21.
Zurück zum Zitat Zhu H, Zhu P, Li X, Liu Q (2017) Top \(k\) skyline groups queries. In: Proceedings of the ninth international conference on extending database technology (EDBT) Zhu H, Zhu P, Li X, Liu Q (2017) Top \(k\) skyline groups queries. In: Proceedings of the ninth international conference on extending database technology (EDBT)
22.
Zurück zum Zitat Zhu H, Li X, Liu Q, Xu Z (2019) Top-k dominating queries on skyline groups. IEEE Trans Knowl Data Eng 32:1431–1444CrossRef Zhu H, Li X, Liu Q, Xu Z (2019) Top-k dominating queries on skyline groups. IEEE Trans Knowl Data Eng 32:1431–1444CrossRef
23.
Zurück zum Zitat Yu W, Liu J, Pei J, Xiong L, Chen X, Qin Z (2019) Efficient contour computation of group-based skyline. IEEE Trans Knowl Data Eng 32:1317–1332CrossRef Yu W, Liu J, Pei J, Xiong L, Chen X, Qin Z (2019) Efficient contour computation of group-based skyline. IEEE Trans Knowl Data Eng 32:1317–1332CrossRef
24.
Zurück zum Zitat Miao X, Gao Y, Guo S, Chen G (2018) On efficiently answering why-not range-based skyline queries in road networks. IEEE Trans Knowl Data Eng 30(99):1 Miao X, Gao Y, Guo S, Chen G (2018) On efficiently answering why-not range-based skyline queries in road networks. IEEE Trans Knowl Data Eng 30(99):1
25.
Zurück zum Zitat He Z, Lo E (2014) Answering why-not questions on top \(k\) queries. IEEE Trans Knowl Data Eng 26(6):1300–1315CrossRef He Z, Lo E (2014) Answering why-not questions on top \(k\) queries. IEEE Trans Knowl Data Eng 26(6):1300–1315CrossRef
26.
Zurück zum Zitat Chen L, Gao Y, Wang K, Jensen CS, Chen G (2016) Answering why-not questions on metric probabilistic range queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 767–778 Chen L, Gao Y, Wang K, Jensen CS, Chen G (2016) Answering why-not questions on metric probabilistic range queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 767–778
27.
Zurück zum Zitat Chen L, Li Y, Xu J, Jensen CS (2017) Direction-aware why-not spatial keyword top-k queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 107–110 Chen L, Li Y, Xu J, Jensen CS (2017) Direction-aware why-not spatial keyword top-k queries. In: Proceedings of the IEEE international conference on data engineering (ICDE), pp 107–110
28.
Zurück zum Zitat Chen L, Li Y, Xu J, Jensen CS (2018) Towards why-not spatial keyword top \(k\) queries: a direction-aware approach. IEEE Trans Knowl Data Eng 30(99):796–809CrossRef Chen L, Li Y, Xu J, Jensen CS (2018) Towards why-not spatial keyword top \(k\) queries: a direction-aware approach. IEEE Trans Knowl Data Eng 30(99):796–809CrossRef
29.
Zurück zum Zitat Ding X, Jin H (2012) Efficient and progressive algorithms for distributed skyline queries over uncertain data. IEEE Trans Knowl Data Eng 24(8):1448–1462CrossRef Ding X, Jin H (2012) Efficient and progressive algorithms for distributed skyline queries over uncertain data. IEEE Trans Knowl Data Eng 24(8):1448–1462CrossRef
30.
Zurück zum Zitat Zhou X, Li K, Zhou Y, Li K (2016) Adaptive processing for distributed skyline queries over uncertain data. IEEE Trans Knowl Data Eng 28:371–384CrossRef Zhou X, Li K, Zhou Y, Li K (2016) Adaptive processing for distributed skyline queries over uncertain data. IEEE Trans Knowl Data Eng 28:371–384CrossRef
31.
Zurück zum Zitat Ren W, Lian X, Ghazinour K (2019) Skyline queries over incomplete data streams. VLDB J 28:961–985CrossRef Ren W, Lian X, Ghazinour K (2019) Skyline queries over incomplete data streams. VLDB J 28:961–985CrossRef
32.
Zurück zum Zitat Papadias D, Tao Y, Fu G, Seeger B (2005) Progressive skyline computation in database systems. ACM Trans Database Syst 30(1):41–82CrossRef Papadias D, Tao Y, Fu G, Seeger B (2005) Progressive skyline computation in database systems. ACM Trans Database Syst 30(1):41–82CrossRef
Metadaten
Titel
Progressive approaches to flexible group skyline queries
verfasst von
Zhibang Yang
Xu Zhou
Kenli Li
Yunjun Gao
Keqin Li
Publikationsdatum
09.04.2021
Verlag
Springer London
Erschienen in
Knowledge and Information Systems / Ausgabe 6/2021
Print ISSN: 0219-1377
Elektronische ISSN: 0219-3116
DOI
https://doi.org/10.1007/s10115-021-01562-8

Weitere Artikel der Ausgabe 6/2021

Knowledge and Information Systems 6/2021 Zur Ausgabe