Skip to main content
Erschienen in: Soft Computing 20/2020

21.03.2020 | Methodologies and Application

Efficient column-oriented processing for mutual subspace skyline queries

verfasst von: Tao Jiang, Bin Zhang, Dan Lin, Yunjun Gao, Qing LI

Erschienen in: Soft Computing | Ausgabe 20/2020

Einloggen

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

search-config
loading …

Abstract

A mutual skyline query will enable some new applications, such as marketing analysis, task allocation, and personalized matching. Algorithms for efficient processing of this query have been recently proposed in the literature. Those approaches use the R-tree indexes and apply a series of pruning criteria toward efficient processing. However, they are characterized by several limitations: (1) they cannot process different interests on attributes for skyline and reverse skyline, (2) they require a multidimensional index, which suffers from performance degradation, especially in high-dimensional space, and (3) they do not support vertically decomposed data that is a natural and intuitive choice for the parallel queries. To this end, we address aforementioned these problems and propose three efficient algorithms, i.e., index-based mutual subspace skyline, optimized index-based MSS, and parallel mutual subspace skyline, using the column-oriented processing that is more suitable for subspace and parallel skyline. Extensive experimental results show that our proposed algorithms are effective and efficient.

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
Zurück zum Zitat Bai M, Xin J, Wang G (2013) Subspace global skyline query processing. In: Proceedings of the 16th ACM EDBT conference. pp 418–429 Bai M, Xin J, Wang G (2013) Subspace global skyline query processing. In: Proceedings of the 16th ACM EDBT conference. pp 418–429
Zurück zum Zitat Bartolini I, Ciaccia P, Patella M (2006) SaLSa: computing the skyline without scanning the whole sky. In: Proceedings of the 15th ACM CIKM conference. pp 405–414 Bartolini I, Ciaccia P, Patella M (2006) SaLSa: computing the skyline without scanning the whole sky. In: Proceedings of the 15th ACM CIKM conference. pp 405–414
Zurück zum Zitat Borzsonyi S, Kossmann D, Stocker K (2001) The skyline operator. In: Proceedings of the 17th IEEE ICDE conference. pp 421–430 Borzsonyi S, Kossmann D, Stocker K (2001) The skyline operator. In: Proceedings of the 17th IEEE ICDE conference. pp 421–430
Zurück zum Zitat Dagum L, Menon R (1998) OpenMP: an industry-standard API for shared memory programming. IEEE Comput Sci Eng 5(1):46–55CrossRef Dagum L, Menon R (1998) OpenMP: an industry-standard API for shared memory programming. IEEE Comput Sci Eng 5(1):46–55CrossRef
Zurück zum Zitat Dellis E, Seeger B (2007) Efficient computation of reverse skyline queries. In: Proceedings of the 33th VLDB conference. pp. 291–302 Dellis E, Seeger B (2007) Efficient computation of reverse skyline queries. In: Proceedings of the 33th VLDB conference. pp. 291–302
Zurück zum Zitat Islam MS, Liu C, Rahayu JW, Anwar T (2016) Q+Tree: an efficient quad tree based data indexing for parallelizing dynamic and reverse skylines. In: Proceedings of the 25th ACM CIKM conference. pp 1291–1300 Islam MS, Liu C, Rahayu JW, Anwar T (2016) Q+Tree: an efficient quad tree based data indexing for parallelizing dynamic and reverse skylines. In: Proceedings of the 25th ACM CIKM conference. pp 1291–1300
Zurück zum Zitat Jiang T, Gao Y, Zhang B, Lin D, Li Q (2014) Monochromatic and bichromatic mutual skyline queries. Expert Syst Appl 41(4):1885–1900CrossRef Jiang T, Gao Y, Zhang B, Lin D, Li Q (2014) Monochromatic and bichromatic mutual skyline queries. Expert Syst Appl 41(4):1885–1900CrossRef
Zurück zum Zitat Jiang T, Zhang B, Lin D, Gao Y, Li Q (2015) Incremental evaluation of top-k combinatorial metric skyline query. Knowl Based Syst 74:89–105CrossRef Jiang T, Zhang B, Lin D, Gao Y, Li Q (2015) Incremental evaluation of top-k combinatorial metric skyline query. Knowl Based Syst 74:89–105CrossRef
Zurück zum Zitat Lee J, Hwang SW (2014) Toward efficient multidimensional subspace skyline computation. VLDB J 23(1):129–145CrossRef Lee J, Hwang SW (2014) Toward efficient multidimensional subspace skyline computation. VLDB J 23(1):129–145CrossRef
Zurück zum Zitat Lee KCK, Lee WC, Zheng B, Li H, Tian Y (2010) Z-SKY: an efficient skyline query processing framework based on Z order. VLDB J 19(3):333–362CrossRef Lee KCK, Lee WC, Zheng B, Li H, Tian Y (2010) Z-SKY: an efficient skyline query processing framework based on Z order. VLDB J 19(3):333–362CrossRef
Zurück zum Zitat Li C, Ooi BC, Tung AKH, Wang S (2006) DADA: a data cube for dominant relationship analysis. In: Proceedings of the 25th ACM SIGMOD conference. pp 659–670 Li C, Ooi BC, Tung AKH, Wang S (2006) DADA: a data cube for dominant relationship analysis. In: Proceedings of the 25th ACM SIGMOD conference. pp 659–670
Zurück zum Zitat Li R, Qin L, Ye F, Yu X J, Xiao X et al (2018) Skyline community search in multi-valued networks. In: Proceedings of the 2018 ACM SIGMOD conference. pp 457–472 Li R, Qin L, Ye F, Yu X J, Xiao X et al (2018) Skyline community search in multi-valued networks. In: Proceedings of the 2018 ACM SIGMOD conference. pp 457–472
Zurück zum Zitat Lian X, Chen L (2010) Reverse skyline search in uncertain databases. ACM Trans Database Syst 35(1):3CrossRef Lian X, Chen L (2010) Reverse skyline search in uncertain databases. ACM Trans Database Syst 35(1):3CrossRef
Zurück zum Zitat Lian X, Chen L (2013) Efficient processing of probabilistic group subspace skyline queries in uncertain databases. Inf Syst 38(3):265–285CrossRef Lian X, Chen L (2013) Efficient processing of probabilistic group subspace skyline queries in uncertain databases. Inf Syst 38(3):265–285CrossRef
Zurück zum Zitat Lin X, Yuan Y, Zhang Q, Zhang Y (2007) Selecting stars: the k most representative skyline operator. In: Proceedings of the 23th IEEE ICDE conference. pp 86–95 Lin X, Yuan Y, Zhang Q, Zhang Y (2007) Selecting stars: the k most representative skyline operator. In: Proceedings of the 23th IEEE ICDE conference. pp 86–95
Zurück zum Zitat Liu J, Xiong L, Pei P, Luo J, Zhang H (2015) Finding pareto optimal groups: group-based skyline. PVLDB 8(13):2086–2097 Liu J, Xiong L, Pei P, Luo J, Zhang H (2015) Finding pareto optimal groups: group-based skyline. PVLDB 8(13):2086–2097
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
Zurück zum Zitat Pei J, Jin W, Ester M, Tao Y (2005) Catching the best views of skyline: a semantic approach based on decisive subspaces. In: Proceedings of the 31th VLDB conference. pp 253–264 Pei J, Jin W, Ester M, Tao Y (2005) Catching the best views of skyline: a semantic approach based on decisive subspaces. In: Proceedings of the 31th VLDB conference. pp 253–264
Zurück zum Zitat Pei J, Yuan Y, Lin X et al (2006) Towards multidimensional subspace skyline analysis. ACM Trans Database Syst 31(4):1335–1381CrossRef Pei J, Yuan Y, Lin X et al (2006) Towards multidimensional subspace skyline analysis. ACM Trans Database Syst 31(4):1335–1381CrossRef
Zurück zum Zitat Rahman MF, Asudeh A, Koudas N, Das G (2017) Efficient computation of subspace skyline over categorical domains. In: Proceedings of the 26th ACM CIKM conference. pp 407–416 Rahman MF, Asudeh A, Koudas N, Das G (2017) Efficient computation of subspace skyline over categorical domains. In: Proceedings of the 26th ACM CIKM conference. pp 407–416
Zurück zum Zitat Tao Y, Papadias D, Lian X, Xiao X (2007a) Multidimensional reverse kNN search. VLDB J 16(3):293–316CrossRef Tao Y, Papadias D, Lian X, Xiao X (2007a) Multidimensional reverse kNN search. VLDB J 16(3):293–316CrossRef
Zurück zum Zitat Tao Y, Xiao X, Pei J (2007b) Efficient skyline and top-k retrieval in subspaces. IEEE Trans Knowl Data Eng 19(8):1072–1088CrossRef Tao Y, Xiao X, Pei J (2007b) Efficient skyline and top-k retrieval in subspaces. IEEE Trans Knowl Data Eng 19(8):1072–1088CrossRef
Zurück zum Zitat Tiakas E, Papadopoulos AN, Manolopoulos Y (2011) Progressive processing of subspace dominating queries. VLDB J 20:921–948CrossRef Tiakas E, Papadopoulos AN, Manolopoulos Y (2011) Progressive processing of subspace dominating queries. VLDB J 20:921–948CrossRef
Zurück zum Zitat Vlachou A, Doulkeridis C, Kotidis Y, Vazirgiannis M (2010) Efficient routing of subspace skyline queries over highly distributed data. IEEE Trans Knowl Data Eng 22(12):1694–1708CrossRef Vlachou A, Doulkeridis C, Kotidis Y, Vazirgiannis M (2010) Efficient routing of subspace skyline queries over highly distributed data. IEEE Trans Knowl Data Eng 22(12):1694–1708CrossRef
Zurück zum Zitat Xia T, Zhang D, Fang Z et al (2012) Online subspace skyline query processing using the compressed skycube. ACM Trans Database Syst 37(2):15CrossRef Xia T, Zhang D, Fang Z et al (2012) Online subspace skyline query processing using the compressed skycube. ACM Trans Database Syst 37(2):15CrossRef
Zurück zum Zitat Yang Z, Li K, Zhou X, Mei J, Gao Y (2018) Top k probabilistic skyline queries on uncertain data. Neurocomputing 317:1–14CrossRef Yang Z, Li K, Zhou X, Mei J, Gao Y (2018) Top k probabilistic skyline queries on uncertain data. Neurocomputing 317:1–14CrossRef
Zurück zum Zitat Yuan Y, Lin X, Liu Q, Wang W, Yu J X, Zhang Q (2005) Efficient computation of the skyline cube,” In: Proceedings of the 31th VLDB conference. pp 241–252 Yuan Y, Lin X, Liu Q, Wang W, Yu J X, Zhang Q (2005) Efficient computation of the skyline cube,” In: Proceedings of the 31th VLDB conference. pp 241–252
Metadaten
Titel
Efficient column-oriented processing for mutual subspace skyline queries
verfasst von
Tao Jiang
Bin Zhang
Dan Lin
Yunjun Gao
Qing LI
Publikationsdatum
21.03.2020
Verlag
Springer Berlin Heidelberg
Erschienen in
Soft Computing / Ausgabe 20/2020
Print ISSN: 1432-7643
Elektronische ISSN: 1433-7479
DOI
https://doi.org/10.1007/s00500-020-04875-y

Weitere Artikel der Ausgabe 20/2020

Soft Computing 20/2020 Zur Ausgabe

Premium Partner