Evaluating the Performance of SQL*Plus with Hive for Business
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.
KeywordsBig data Business intelligence CRUD operations Hive SQL*plus
- 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.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.Gennick, J.: Oracle SQL*Plus—The Definitive Guide. O’Reilly Media (1999)Google Scholar
- 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
- 8.Capriolo, E., Wampler, D., Rutherglen, J: Hive Programming Guide. O’Reilly Media (2012)Google Scholar