Skip to main content
Top
Published in: Distributed and Parallel Databases 4/2021

18-03-2021

Finding the most profitable candidate product by dynamic skyline and parallel processing

Authors: Liang Kuang Tai, En Tzu Wang, Arbee L. P. Chen

Published in: Distributed and Parallel Databases | Issue 4/2021

Log in

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

search-config
loading …

Abstract

Given a set of existing products in the market and a set of customer preferences, we set a price for a specific product selected from a pool of candidate products to launch to market to gain the most profit. A customer preference represents his/her basic requirements. The dynamic skyline of a customer preference identifies the products that the customer may purchase. Each time the price of a candidate product is adjusted, it needs to compete with all of the existing products to determine whether it can be one of the dynamic skyline products of some customer preferences. To compute in parallel, we use a Voronoi-Diagram-based partitioning method to separate the set of existing products and that of customer preferences into cells. For these cells, a large number of combinations can be generated. For each price under consideration of a candidate product, we process all the combinations in parallel to determine whether this candidate product can be one of the dynamic skyline products of the customer preferences. We then integrate the results to decide the price for each candidate product to achieve the most profit. To further improve the performance, we design two efficient pruning strategies to avoid computing all combinations. A set of experiments using real and synthetic datasets are performed and the experiment results reveal that the pruning strategies are effective.

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 "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!

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!

Literature
1.
go back to reference Afrati, F.N., Koutris, P., Suciu, D., Ullman, J.D.: Parallel skyline queries. In: Proceedings of the 15th International Conference on Database Theory (ICDT), pp. 274–284 (2012) Afrati, F.N., Koutris, P., Suciu, D., Ullman, J.D.: Parallel skyline queries. In: Proceedings of the 15th International Conference on Database Theory (ICDT), pp. 274–284 (2012)
2.
go back to reference Börzsönyi, S., Kossmann, D., Stocker, K.: The Skyline operator. In: Proceedings of the 17th International Conference on Data Engineering (ICDE), pp. 421–430 (2001) Börzsönyi, S., Kossmann, D., Stocker, K.: The Skyline operator. In: Proceedings of the 17th International Conference on Data Engineering (ICDE), pp. 421–430 (2001)
3.
go back to reference Chester, S., Sidlauskas, D., Assent, I., Bpgh, K.S.: Scalable parallelization of skyline computation for multi-core processors. In: Proceedings of the International Conference on Data Engineering, pp. 1083–1094 (2015) Chester, S., Sidlauskas, D., Assent, I., Bpgh, K.S.: Scalable parallelization of skyline computation for multi-core processors. In: Proceedings of the International Conference on Data Engineering, pp. 1083–1094 (2015)
4.
go back to reference Chomicki, J., Godfrey, P., Gryz, J., Liang, D.: Skyline with presorting: theory and optimizations. In: Proceedings of the IEEE International Conference on Data Engineering (ICDE), pp. 717–719 (2003) Chomicki, J., Godfrey, P., Gryz, J., Liang, D.: Skyline with presorting: theory and optimizations. In: Proceedings of the IEEE International Conference on Data Engineering (ICDE), pp. 717–719 (2003)
5.
go back to reference Dellis, E., Seeger, B.: Efficient computation of reverse skyline queries. In: Proceedings of the 33rd International Conference on Very large Data Bases Conference (VLDB), pp. 291–302 (2007) Dellis, E., Seeger, B.: Efficient computation of reverse skyline queries. In: Proceedings of the 33rd International Conference on Very large Data Bases Conference (VLDB), pp. 291–302 (2007)
6.
go back to reference Deshpande, P.M., Deepak, P: Efficient reverse skyline retrieval with arbitrary non-metric similarity measures. In: Proceedings of the 14th International Conference on Extending Database Technology (EDBT), pp. 319–330 (2011) Deshpande, P.M., Deepak, P: Efficient reverse skyline retrieval with arbitrary non-metric similarity measures. In: Proceedings of the 14th International Conference on Extending Database Technology (EDBT), pp. 319–330 (2011)
7.
go back to reference Islam, M.S., Liu, C.: Know your customer: computing k-most promising products for targeted marketing. VLDB J. 25(4), 545–570 (2016)CrossRef Islam, M.S., Liu, C.: Know your customer: computing k-most promising products for targeted marketing. VLDB J. 25(4), 545–570 (2016)CrossRef
8.
go back to reference Koh, J.-L., Lin, C.-Y., Chen, A.L.P.: Finding k most favorite products based on reverse top-t queries. VLDB J. 23, 541–564 (2014)CrossRef Koh, J.-L., Lin, C.-Y., Chen, A.L.P.: Finding k most favorite products based on reverse top-t queries. VLDB J. 23, 541–564 (2014)CrossRef
9.
go back to reference Kossmann, D., Ramsak, F., Rost, S.: Shooting stars in the sky: an online algorithm for skyline queries. In: Proceedings of the Very Large Data Bases Conference (VLDB), pp. 175–286 (2002) Kossmann, D., Ramsak, F., Rost, S.: Shooting stars in the sky: an online algorithm for skyline queries. In: Proceedings of the Very Large Data Bases Conference (VLDB), pp. 175–286 (2002)
10.
go back to reference Lee, J., Hwang, S.: Scalable skyline computation using a balanced pivot selection technique. Inf. Syst. 39, 1–21 (2014)CrossRef Lee, J., Hwang, S.: Scalable skyline computation using a balanced pivot selection technique. Inf. Syst. 39, 1–21 (2014)CrossRef
11.
go back to reference Li, C., Ooi, B.C., Tung, A.K.H., Wang, S.: DADA: a data cube for dominant relationship analysis. In: Proceedings of the 25th ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 659–670 (2006) Li, C., Ooi, B.C., Tung, A.K.H., Wang, S.: DADA: a data cube for dominant relationship analysis. In: Proceedings of the 25th ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 659–670 (2006)
12.
go back to reference Lian, X., Chen, L.: Monochromatic and bichromatic reverse skyline search over uncertain databases. In: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 213–226 (2008) Lian, X., Chen, L.: Monochromatic and bichromatic reverse skyline search over uncertain databases. In: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 213–226 (2008)
13.
go back to reference Lin, C.-Y., Koh, J.-L., Chen, A.L.P.: Determining (k)-most demanding products with maximum expected number of total customers. IEEE Trans. Knowl. Data Eng. (TKDE) 25(8), 1732–1747 (2013)CrossRef Lin, C.-Y., Koh, J.-L., Chen, A.L.P.: Determining (k)-most demanding products with maximum expected number of total customers. IEEE Trans. Knowl. Data Eng. (TKDE) 25(8), 1732–1747 (2013)CrossRef
14.
go back to reference Lu, W., Shen, Y., Chen, S., Ooi, B.C.: Efficient processing of k nearest neighbor joins using MapReduce. VLDB J. 5(10), 1016–1027 (2012) Lu, W., Shen, Y., Chen, S., Ooi, B.C.: Efficient processing of k nearest neighbor joins using MapReduce. VLDB J. 5(10), 1016–1027 (2012)
15.
go back to reference Mullesgaard, K., Pederseny, J.L., Lu, H., Zhou, Y.: Efficient skyline computation in MapReduce. In: Proceedings of the 17th International Conference on Extending Database Technology (EDBT), pp. 37–48 (2014) Mullesgaard, K., Pederseny, J.L., Lu, H., Zhou, Y.: Efficient skyline computation in MapReduce. In: Proceedings of the 17th International Conference on Extending Database Technology (EDBT), pp. 37–48 (2014)
16.
go back to reference Papadias, D., Tao, Y., Fu, G., Seeger, B.: An optimal and progressive algorithm for skyline queries. In: Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 467–478 (2003) Papadias, D., Tao, Y., Fu, G., Seeger, B.: An optimal and progressive algorithm for skyline queries. In: Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 467–478 (2003)
17.
go back to reference Papadias, D., Tao, Y., Greg, F., Seeger, B.: Progressive skyline computation in database systems. ACM Trans. Database Syst. (TODS) 30(1), 41–82 (2005)CrossRef Papadias, D., Tao, Y., Greg, F., Seeger, B.: Progressive skyline computation in database systems. ACM Trans. Database Syst. (TODS) 30(1), 41–82 (2005)CrossRef
18.
go back to reference Park, Y., Min, J.-K., Shim, K.: Parallel computation of skyline and reverse skyline queries using MapReduce. VLDB J. 6(14), 2002–2013 (2013) Park, Y., Min, J.-K., Shim, K.: Parallel computation of skyline and reverse skyline queries using MapReduce. VLDB J. 6(14), 2002–2013 (2013)
19.
go back to reference Peng, Y., Wong, R.C.-W.: Finding competitive price. In: Proceedings of the 21st ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems (SIGSPATIAL), pp. 144–153 (2013) Peng, Y., Wong, R.C.-W.: Finding competitive price. In: Proceedings of the 21st ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems (SIGSPATIAL), pp. 144–153 (2013)
20.
go back to reference Peng, Y., Wong, R.C.-W., Wan, Q.: Finding top-k preferable products. IEEE Trans. Knowl. Data Eng. (TKDE) 24(10), 1774–1788 (2012)CrossRef Peng, Y., Wong, R.C.-W., Wan, Q.: Finding top-k preferable products. IEEE Trans. Knowl. Data Eng. (TKDE) 24(10), 1774–1788 (2012)CrossRef
22.
go back to reference Sacharidis, D., Bouros, P., Sellis, T.: Caching dynamic skyline queries. In: Proceedings of the 20th International Conference on Scientific and Statistical Database Management (SSDBM), pp. 55–472 (2008) Sacharidis, D., Bouros, P., Sellis, T.: Caching dynamic skyline queries. In: Proceedings of the 20th International Conference on Scientific and Statistical Database Management (SSDBM), pp. 55–472 (2008)
23.
go back to reference Tan, K.-L., Eng, P.-K., Ooi, B.C.: Efficient progressive skyline computation. In Proceedings of the 27th International Conference on Very Large Data Bases Conference (VLDB), pp. 301–310 (2001) Tan, K.-L., Eng, P.-K., Ooi, B.C.: Efficient progressive skyline computation. In Proceedings of the 27th International Conference on Very Large Data Bases Conference (VLDB), pp. 301–310 (2001)
24.
go back to reference Vlachou, A., Doulkeridis, C., Kotidis, Y.: Angle-based space partitioning for efficient parallel skyline computation. In: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 227–238 (2008) Vlachou, A., Doulkeridis, C., Kotidis, Y.: Angle-based space partitioning for efficient parallel skyline computation. In: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 227–238 (2008)
25.
go back to reference Wang, W.-C., Wang, E.T., Chen, A.L.P.: Dynamic skylines considering range queries. In: Proceedings of the 16th International Conference on Database Systems for Advanced Applications: Part II (DASFAA), pp. 235–250 (2011) Wang, W.-C., Wang, E.T., Chen, A.L.P.: Dynamic skylines considering range queries. In: Proceedings of the 16th International Conference on Database Systems for Advanced Applications: Part II (DASFAA), pp. 235–250 (2011)
26.
go back to reference Xu, S., Lui, J.C.S.: Product selection problem: improve market share by learning consumer behavior. In: Proceedings of the 20th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (KDD), pp. 851–860 (2014) Xu, S., Lui, J.C.S.: Product selection problem: improve market share by learning consumer behavior. In: Proceedings of the 20th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (KDD), pp. 851–860 (2014)
27.
go back to reference Zhang, S., Mamoulis, N., Cheung, D.W.: Scalable skyline computation using object-based space partitioning. In: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 483–494 (2009) Zhang, S., Mamoulis, N., Cheung, D.W.: Scalable skyline computation using object-based space partitioning. In: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 483–494 (2009)
28.
go back to reference Zhang, B., Zhou, S., Guan, J.: Adapting skyline computation to the MapReduce framework: algorithms and experiments. In: Proceedings of the 16th International Conference on Database Systems for Advanced Applications (DASFAA), pp. 403–414 (2011) Zhang, B., Zhou, S., Guan, J.: Adapting skyline computation to the MapReduce framework: algorithms and experiments. In: Proceedings of the 16th International Conference on Database Systems for Advanced Applications (DASFAA), pp. 403–414 (2011)
Metadata
Title
Finding the most profitable candidate product by dynamic skyline and parallel processing
Authors
Liang Kuang Tai
En Tzu Wang
Arbee L. P. Chen
Publication date
18-03-2021
Publisher
Springer US
Published in
Distributed and Parallel Databases / Issue 4/2021
Print ISSN: 0926-8782
Electronic ISSN: 1573-7578
DOI
https://doi.org/10.1007/s10619-021-07323-4

Other articles of this Issue 4/2021

Distributed and Parallel Databases 4/2021 Go to the issue

Premium Partner