Skip to main content
SpringerLink
Log in

Describing and Comparing Big Data Querying Tools

  • Conference paper
  • First Online:
Book cover Recent Advances in Information Systems and Technologies (WorldCIST 2017)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 569))

Included in the following conference series:

Abstract

In the past years, Big Data has become a hot topic across several business areas. One of the main concerns regarding this concept is how to handle the massive volume and variety of data efficiently. Due to the notorious complexity of the data associated to the Big Data concept, usually motivated by data volume, efficient querying analysis mechanisms are mandatory for data analysis purposes. Motivated by the rapidly development of tools and frameworks for Big Data, there is much discussion about querying tools and, specifically, those more appropriated for specific analytical needs. This paper explores some of the available querying tools, describing and comparing their main characteristics and architectures, crucial knowledge for selecting the more appropriate ones for inclusion in a specific Big Data analytical architecture.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Floratou, A., Minhas, U.F., Ozcan, F.: SQL-on-Hadoop: full circle back to shared-nothing database architectures. Proc. VLDB Endowment 7(12), 1295–1306 (2014)

    Article  Google Scholar 

  2. Bernardino, J., Neves, P.: Decision-making with big data using open source business intelligence systems. In: Human Development and Interaction in the Age of Ubiquitous Technology, IGI Global, pp. 120–147 (2016)

    Google Scholar 

  3. Sakr, S.: A brief comparative perspective on SQL access for Hadoop, pp. 1–9 (2014)

    Google Scholar 

  4. Kornacker, M., et al.: Impala: a modern, open-source SQL engine for Hadoop. In: CIDR (Conference on Innovative Data Systems Research) (2015)

    Google Scholar 

  5. Bernardino, J., Abramova, V.: No experimental evaluation of NoSQL databases. Int. J. Database Manage. Syst. 6, 1–16 (2014)

    Google Scholar 

  6. Prasad, B.R., Agarwal, S.: Comparative study of big data computing and storage tools: a review. Int. J. Database Theory Appl. 9(1), 45–66 (2016)

    Article  Google Scholar 

  7. Landset, S., Khoshgoftaar, T.M., Richter, A.N., Hasanin, T.: A survey of open source tools for machine learning with big data in the Hadoop ecosystem. J. Big Data 2(1), 24 (2015)

    Article  Google Scholar 

  8. Bobade, V.B.: Survey paper on big data and Hadoop. Int. Res. J. Eng. Technol. 3(1), 861–863 (2016)

    Google Scholar 

  9. 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)

    Google Scholar 

  10. Jethro, Hadoop Hive and 11 SQL-on-Hadoop Alternatives (2016). https://jethro.io/hadoop-hive

  11. The SQL on Hadoop landscape: An overview (Part I) (2015). http://cleverowl.uk/2015/11/19/the-sql-on-hadoop-landscape-an-overview-part-i/

  12. The SQL on Hadoop landscape: An overview (Part II) (2015). http://cleverowl.uk/2015/12/25/the-sql-on-hadoop-landscape-an-overview-part-ii/

  13. MapR, SQL on Hadoop: Landscape and Considerations (2016)

    Google Scholar 

  14. Devadutta Ghat, D.K., Rorke, D.: New SQL Benchmarks: Apache Impala (incubating) Uniquely Delivers Analytic Database Performance 2016

    Google Scholar 

  15. The SQL on Hadoop landscape: An overview (Part I) 2015

    Google Scholar 

  16. Silva, Y.N., Almeida, I., Queiroz, M.: SQL: From traditional databases to big data. In: Proceedings of SIGCSE - ACM Technical Symposium on Computer Science Education, p. 6 (2016)

    Google Scholar 

  17. Shinde, S.: Apache hive or cloudera impala? what is best for me? (2013)

    Google Scholar 

  18. Sakaki, T., Okazaki, M., Matsuo, Y.: Earthquake shakes twitter users: real-time event detection by social sensors. In: Proceedings of the 19th International Conference World Wide Web, pp. 851–860 (2010)

    Google Scholar 

  19. SQL Engines for Hadoop: Hive vs Impala vs Spark (2016). http://bigdata.black/architecture/hadoop/sql-engines-hadoop-hive-spark-impala/

  20. Morgan, T.P.: EMC morphs Hadoop elephant into SQL database Hawq (2013). http://www.theregister.co.uk/2013/02/25/emc_pivotal_hd_hadoop_hawq_database/

Download references

Acknowledgments

This work has been supported by COMPETE: POCI-01-0145-FEDER-007043 and FCT (Fundação para a Ciência e Tecnologia) within the Project Scope: UID/CEC/00319/2013, and by Portugal Incentive System for Research and Technological Development, Project in co-promotion nº 002814/2015 (iFACTORY 2015-2018).

Author information

Authors and Affiliations

  1. Polytechnic of Coimbra, Institute of Engineering of Coimbra (ISEC), Coimbra, Portugal

    Mário Rodrigues & Jorge Bernardino

  2. ALGORITMI Research Centre, University of Minho, Guimarães, Portugal

    Maribel Yasmina Santos

  3. CISUC – Centre for Informatics and Systems of the University of Coimbra, Coimbra, Portugal

    Jorge Bernardino

Authors
  1. Mário Rodrigues
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Maribel Yasmina Santos
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jorge Bernardino
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Mário Rodrigues .

Editor information

Editors and Affiliations

  1. DEI/FCT, Universidade de Coimbra, Coimbra, Baixo Mondego, Portugal

    Álvaro Rocha

  2. Nova IMS, Universidade Nova de Lisboa, Lisboa, Portugal

    Ana Maria Correia

  3. College of Engineering, The Ohio State University, Columbus, Ohio, USA

    Hojjat Adeli

  4. DSI/EEUM, Universidade do Minho, Guimarães, Portugal

    Luís Paulo Reis

  5. DIMES, Università della Calabria, Arcavacata di Rende, Italy

    Sandra Costanzo

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Rodrigues, M., Santos, M.Y., Bernardino, J. (2017). Describing and Comparing Big Data Querying Tools. In: Rocha, Á., Correia, A., Adeli, H., Reis, L., Costanzo, S. (eds) Recent Advances in Information Systems and Technologies. WorldCIST 2017. Advances in Intelligent Systems and Computing, vol 569. Springer, Cham. https://doi.org/10.1007/978-3-319-56535-4_12

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-56535-4_12

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-56534-7

  • Online ISBN: 978-3-319-56535-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation