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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
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)
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)
Gennick, J.: Oracle SQL*Plus—The Definitive Guide. O’Reilly Media (1999)
Pratt, P.J.: A relational approach to database design. ACM SIGCSE Bull. 17(1), 184–201 (1985)
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)
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)
Capriolo, E., Wampler, D., Rutherglen, J: Hive Programming Guide. O’Reilly Media (2012)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Bhuvaneshwari, P., Nagaraja Rao, A., Aditya Sai Srinivas, T., Jayalakshmi, D., Somula, R., Govinda, K. (2019). Evaluating the Performance of SQL*Plus with Hive for Business. In: Peter, J., Alavi, A., Javadi, B. (eds) Advances in Big Data and Cloud Computing. Advances in Intelligent Systems and Computing, vol 750. Springer, Singapore. https://doi.org/10.1007/978-981-13-1882-5_40
Download citation
DOI: https://doi.org/10.1007/978-981-13-1882-5_40
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-1881-8
Online ISBN: 978-981-13-1882-5
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)