Skip to main content

2018 | OriginalPaper | Buchkapitel

Big Data Equi-Join Optimization Algorithms on Spark Cloud Computing Platform

verfasst von : Sihui Li, Wei Xu

Erschienen in: Cloud Computing and Security

Verlag: Springer International Publishing

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

search-config
loading …

Abstract

On Spark cloud computing platform, the conventional big data equi-join algorithms cannot meet the performance requirements well and the procedure of it is very time-consuming, so the efficiency of big data equi-join is a burning challenge. To overcome it, in this paper, we propose Compressed Bloom Filter Join algorithm, an efficient algorithm filters out most of invalid connections which cannot meet the criteria to reduce network overhead, and it constructs static one-dimensional bit array to improve join performance. Moreover, Compressed Bloom Filter Join Extension algorithm, an extended optimization based on Compressed Bloom Filter Join algorithm, produces a dynamic two-dimensional bit array to filter out invalid records, and it can further accelerate the process of data join when the data size is unknown. Experimental results show that the performance of two optimization algorithms which can reduce time consumption and the data size of Shuffle stage are better than Hash Join and Broadcast Join on Spark cloud computing platform.

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

Literatur
1.
Zurück zum Zitat Xin, R.: Spark and Scala (keynote). In: ACM SIGPLAN International Symposium on Scala, p. 1. ACM (2017) Xin, R.: Spark and Scala (keynote). In: ACM SIGPLAN International Symposium on Scala, p. 1. ACM (2017)
2.
Zurück zum Zitat Cui, Y., Li, G., Cheng, H., Wang, D.: Indexing for large scale data querying based on Spark SQL. In: IEEE International Conference on E-Business Engineering, pp. 103–108. IEEE (2017) Cui, Y., Li, G., Cheng, H., Wang, D.: Indexing for large scale data querying based on Spark SQL. In: IEEE International Conference on E-Business Engineering, pp. 103–108. IEEE (2017)
3.
Zurück zum Zitat Zhang, J., Yang, Q., Shang, H., Zhang, H., Lin, Y., Zhou, R.: Performance evaluation for distributed join based on MapReduce. In: International Conference on Cloud Computing and Big Data, pp. 295–301. IEEE (2017) Zhang, J., Yang, Q., Shang, H., Zhang, H., Lin, Y., Zhou, R.: Performance evaluation for distributed join based on MapReduce. In: International Conference on Cloud Computing and Big Data, pp. 295–301. IEEE (2017)
4.
Zurück zum Zitat Guo-Hua, L.I., Ren, Y.Q., Luo, C., Huang, J., Deng, Y.D.: Optimization of GPU-based main-memory hash join. In: IEEE International Conference on Computational Modeling, Simulation and Applied Mathematics (2017) Guo-Hua, L.I., Ren, Y.Q., Luo, C., Huang, J., Deng, Y.D.: Optimization of GPU-based main-memory hash join. In: IEEE International Conference on Computational Modeling, Simulation and Applied Mathematics (2017)
5.
Zurück zum Zitat Sun, H.: Join processing and optimizing on large datasets based on hadoop framework (in Chinese). Dissertation, Nanjing University of Posts and Telecommunications (2013) Sun, H.: Join processing and optimizing on large datasets based on hadoop framework (in Chinese). Dissertation, Nanjing University of Posts and Telecommunications (2013)
6.
Zurück zum Zitat Lin, Y., Agrawal, D., Chen, C., Ooi, B.C., Wu, S.: Llama: leveraging columnar storage for scalable join processing in the MapReduce framework. In: ACM SIGMOD International Conference on Management of Data, pp. 961–972. ACM (2011) Lin, Y., Agrawal, D., Chen, C., Ooi, B.C., Wu, S.: Llama: leveraging columnar storage for scalable join processing in the MapReduce framework. In: ACM SIGMOD International Conference on Management of Data, pp. 961–972. ACM (2011)
8.
Zurück zum Zitat Zhang, C.C.: Design and optimize big-data join algorithms using MapReduce (in Chinese). Dissertation, University of Science and Technology of China (2014) Zhang, C.C.: Design and optimize big-data join algorithms using MapReduce (in Chinese). Dissertation, University of Science and Technology of China (2014)
9.
Zurück zum Zitat Huang, L.: Research on join query processing and optimization techniques in cloud computing environment (in Chinese). Dissertation, Liaoning University (2014) Huang, L.: Research on join query processing and optimization techniques in cloud computing environment (in Chinese). Dissertation, Liaoning University (2014)
10.
Zurück zum Zitat Wei, L., Shen, Y., Su, C., Ooi, B.C.: Efficient processing of k nearest neighbor joins using MapReduce. Proc. VLDB Endow. 5(10), 1016–1027 (2012)CrossRef Wei, L., Shen, Y., Su, C., Ooi, B.C.: Efficient processing of k nearest neighbor joins using MapReduce. Proc. VLDB Endow. 5(10), 1016–1027 (2012)CrossRef
11.
Zurück zum Zitat Blanas, S., Patel, J.M., Ercegovac, V., Rao, J., Shekita, E.J., Tian, Y.: A comparison of join algorithms for log processing in MaPreduce. In: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data, pp. 975–986. ACM (2010) Blanas, S., Patel, J.M., Ercegovac, V., Rao, J., Shekita, E.J., Tian, Y.: A comparison of join algorithms for log processing in MaPreduce. In: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data, pp. 975–986. ACM (2010)
12.
Zurück zum Zitat Zhang, L.: Research on query analysis and optimization based on spark system (in Chinese). Dissertation, Beijing Jiaotong University (2016) Zhang, L.: Research on query analysis and optimization based on spark system (in Chinese). Dissertation, Beijing Jiaotong University (2016)
13.
Zurück zum Zitat Zhou, S.W.: Optimizing big data equi-join in spark and its application in analysis of network traffic data (in Chinese). Dissertation, South China University of Technology (2015) Zhou, S.W.: Optimizing big data equi-join in spark and its application in analysis of network traffic data (in Chinese). Dissertation, South China University of Technology (2015)
14.
Zurück zum Zitat Liu, R.C., Zhou, M.Q., Xing-Jie, P.I., Zhao, X.: Optimization of the equi-join problem based on big data in spark. Mod. Comput. 8, 3–6 (2017) Liu, R.C., Zhou, M.Q., Xing-Jie, P.I., Zhao, X.: Optimization of the equi-join problem based on big data in spark. Mod. Comput. 8, 3–6 (2017)
15.
Zurück zum Zitat Zhong-Kui, H.U., Bo, Q.U., Huang, B., Wen-Yang, L.I.: A load balanced equi-join algorithm based on virtual processor range partition. Mod. Comput. (2016) Zhong-Kui, H.U., Bo, Q.U., Huang, B., Wen-Yang, L.I.: A load balanced equi-join algorithm based on virtual processor range partition. Mod. Comput. (2016)
Metadaten
Titel
Big Data Equi-Join Optimization Algorithms on Spark Cloud Computing Platform
verfasst von
Sihui Li
Wei Xu
Copyright-Jahr
2018
DOI
https://doi.org/10.1007/978-3-030-00006-6_32