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. © 2019, Springer Nature Singapore Pte Ltd.