Skip to main content
Top
Published in: Soft Computing 20/2020

21-03-2020 | Methodologies and Application

Efficient column-oriented processing for mutual subspace skyline queries

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

Published in: Soft Computing | Issue 20/2020

Log in

Activate our intelligent search to find suitable subject content or patents.

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

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!

Literature
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
go back to reference 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
Metadata
Title
Efficient column-oriented processing for mutual subspace skyline queries
Authors
Tao Jiang
Bin Zhang
Dan Lin
Yunjun Gao
Qing LI
Publication date
21-03-2020
Publisher
Springer Berlin Heidelberg
Published in
Soft Computing / Issue 20/2020
Print ISSN: 1432-7643
Electronic ISSN: 1433-7479
DOI
https://doi.org/10.1007/s00500-020-04875-y

Other articles of this Issue 20/2020

Soft Computing 20/2020 Go to the issue

Premium Partner