Enhancing of data retrieval by means of Database Query Analyzer (DBQA)

Abstract

The power and usefulness of computer are due to its efficiency, accuracy, compatibility, and consistency features. The efficiency of computer had great enhancement from first generation to fifth generation and is an ongoing process until date. Efficiency of computer depends upon the performance of the system while achieving particular result. To increase efficiency and attain fast performance in database management system, query optimization plays an important role. Optimizer in query optimization acts as a brain of computer, which decides the right access method, algorithm, and joins order for better execution of the query with minimum time and cost. Cost is the time for disk access. In this paper, we have attempted cost optimization for select * query by developing Database Query Analyzer (DBQA). DBQA is analyzer which analyzes given query and produces results in terms of time and cost. In the experiment, select * query was provided to DBQA for three different standard databases like dvdrental, accidents, and DBLP with size 7 MB, 320 MB, and 2 GB, respectively, and observed that cost produced by DBQA was 96% optimized than cost produced by existing system.