Skip to main content
Top

2019 | OriginalPaper | Chapter

Experimental Evaluation of Big Data Analytical Tools

Authors : Mário Rodrigues, Maribel Yasmina Santos, Jorge Bernardino

Published in: Information Systems

Publisher: Springer International Publishing

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

search-config
loading …

Abstract

Due to the extensive use of SQL, the number of SQL-on-Hadoop systems has significantly increased, transforming Big Data Analytics in a more accessible practice and allowing users to perform ad-hoc querying and interactive analysis. Therefore, it is of upmost importance to understand these querying tools and the specific contexts in which each one of them can be used to accomplish specific analytical needs. Due to the high number of available tools, this work performs a performance evaluation, using the well-known TPC-DS benchmark, of some of the most popular Big Data Analytical tools, analyzing in more detail the behavior of Drill, Hive, HAWQ, Impala, Presto, and Spark.

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 Transaction Processing Performance Council: TPC BenchmarkTM H Standard Specification Revision 2.17.2 (2017) Transaction Processing Performance Council: TPC BenchmarkTM H Standard Specification Revision 2.17.2 (2017)
2.
go back to reference Floratou, A., Minhas, U.F., Ozcan, F.: SQL-on-Hadoop: full circle back to shared-nothing database architectures. Proc. VLDB Endow. 7(12), 1295–1306 (2014)CrossRef Floratou, A., Minhas, U.F., Ozcan, F.: SQL-on-Hadoop: full circle back to shared-nothing database architectures. Proc. VLDB Endow. 7(12), 1295–1306 (2014)CrossRef
6.
go back to reference Sakr, S.: A brief comparative perspective on SQL access for Hadoop. In: Recent Advances in Information Systems and Technologies, vol. 1, pp. 1–9 (2014) Sakr, S.: A brief comparative perspective on SQL access for Hadoop. In: Recent Advances in Information Systems and Technologies, vol. 1, pp. 1–9 (2014)
7.
go back to reference Kornacker, M., et al.: Impala: A Modern, Open-Source SQL Engine for Hadoop. In: CIDR(Conference on Innovative Data Systems Research) (2015) Kornacker, M., et al.: Impala: A Modern, Open-Source SQL Engine for Hadoop. In: CIDR(Conference on Innovative Data Systems Research) (2015)
8.
go back to reference Grover, A., et al.: SQL-like big data environments: case study in clinical trial analytics. In: 2015 IEEE International Conference on Big Data (Big Data), pp. 2680–2689 (2015) Grover, A., et al.: SQL-like big data environments: case study in clinical trial analytics. In: 2015 IEEE International Conference on Big Data (Big Data), pp. 2680–2689 (2015)
10.
go back to reference Santos, M.Y., et al.: Evaluating SQL-on-Hadoop for big data warehousing on not-so-good hardware. In: Proceedings of the 21st International Database Engineering and Applications Symposium - IDEAS 2017, pp. 242–252 (2017) Santos, M.Y., et al.: Evaluating SQL-on-Hadoop for big data warehousing on not-so-good hardware. In: Proceedings of the 21st International Database Engineering and Applications Symposium - IDEAS 2017, pp. 242–252 (2017)
Metadata
Title
Experimental Evaluation of Big Data Analytical Tools
Authors
Mário Rodrigues
Maribel Yasmina Santos
Jorge Bernardino
Copyright Year
2019
DOI
https://doi.org/10.1007/978-3-030-11395-7_12

Premium Partner