Advertisement

Evaluating the Performance of SQL*Plus with Hive for Business

  • P. BhuvaneshwariEmail author
  • A. Nagaraja Rao
  • T. Aditya Sai Srinivas
  • D. Jayalakshmi
  • Ramasubbareddy Somula
  • K. Govinda
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 750)

Abstract

Implementation of advanced analytics for big data processing in business intelligence is significant towards gaining profits. For processing large-scale data sets efficiently, so many challenges are faced by traditional database system. To overcome the disadvantages present in an existing system, various kinds of a new database have been evolved along with application programs (e.g., MySQL, PostgreSQL, Hive, etc.). Such type of systems store the data in the database, retrieves, and displays the information once it is queried. The time duration varies in the different database for doing the process. This paper evaluates the performance by using SQL*Plus and Hive. In the enterprise business data model, a comparison of both SQL*Plus and Hive for some CRUD operations (Insert, Join, and Retrieve) are estimated. By the work presented in this paper, we conclude if performance is a key, then SQL*Plus is a right choice to use and for processing large datasets hive works better.

Keywords

Big data Business intelligence CRUD operations Hive SQL*plus 

References

  1. 1.
    Surekha, D., Swamy, G., Venkatramaphanikumar, S.: Real time streaming data storage and processing using storm and analytics with Hive. In: ICACCCT, International Conference on IEEE, pp. 606–610 (2016)Google Scholar
  2. 2.
    Huai, Y., Chauhan, A., Gates, A., Hagleitner, G., Hanson, E.N., O’Malley, O., … Zhang, X.: Major technical advancements in apache hive. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 1235–1246. ACM (2014)Google Scholar
  3. 3.
    Gennick, J.: Oracle SQL*Plus—The Definitive Guide. O’Reilly Media (1999)Google Scholar
  4. 4.
    Pratt, P.J.: A relational approach to database design. ACM SIGCSE Bull. 17(1), 184–201 (1985)CrossRefGoogle Scholar
  5. 5.
    Abramova, V., Bernardino, J.: NoSQL databases: MongoDB vs Cassandra. In: Proceedings of the International C* Conference on Computer Science and Software Engineering, pp. 14–22. ACM (2013)Google Scholar
  6. 6.
    Guo, Y., Rao, J., Cheng, D., Zhou, X.: ishuffle: Improving Hadoop performance with shuffle-on-write. IEEE Trans. Parallel Distrib. Syst. 28(6), 1649–1662 (2017)CrossRefGoogle Scholar
  7. 7.
  8. 8.
    Capriolo, E., Wampler, D., Rutherglen, J: Hive Programming Guide. O’Reilly Media (2012)Google Scholar

Copyright information

© Springer Nature Singapore Pte Ltd. 2019

Authors and Affiliations

  • P. Bhuvaneshwari
    • 1
    Email author
  • A. Nagaraja Rao
    • 1
  • T. Aditya Sai Srinivas
    • 1
  • D. Jayalakshmi
    • 1
  • Ramasubbareddy Somula
    • 1
  • K. Govinda
    • 1
  1. 1.SCOPEVITVelloreIndia

Personalised recommendations