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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Rupley Jr., M.L.: Introduction to Query Processing and Optimization. Indiana University at South Bend
Cole, R.L., Graefe, G.: Optimization of dynamic query evaluation plans. In: Proceedings of the ACM SIGMOD, vol. 24, pp. 150–160. ACM Press, New York (1994)
Morvan, F., Hameurlain, A.: Dynamic query optimization: towards decentralized methods. Int. J. Intell. Inf. Database Syst. (2009)
Kumari, N.: SQL server query optimization techniques—tips for writing efficient and faster queries. Int. J. Sci. Res. Publ. 2(6) (2012)
Misal, S.B., Gaikwad, A.T.: Design execution plan for effective run time. IJMER 3(3, 11) (March 2014)
Habimana, J.: Query optimization techniques—tips for writing efficient and faster queries. Int. J. Sci. Technol. Res. 4(10) (2015)
Shekhar, S., Hamidzadeh, B., Kohli, A., Coyle, M.: Learning transformation rules for semantic query optimization a data driven approach. IEEE Trans. Knowl. Data Eng. 5(6) (1993)
Pedrozo, W.G., Vaz, M.S.M.G.: A tool for automatic index selection in database management systems. In: IEEE International Symposium on Computer, Consumer and Control (2014). 978-1-4799-5277-9/14
Raza, B., Mateen, A., Sher, M., Awais, M.M., Hussain T.: Autonomic view of query optimizers in database management systems. In: 8th ACIS International Conference on Software Engineering Research, Management and Applications (2010). https://doi.org/10.1109/sera.2010.11
Bassil, Y.: A comparative study on the performance of the top DBMS systems. J. Comput. Sci. Res. 1(1). 20–31 (2012)
Saikia, A., Joy, S., Dolma, D., Mary, R.: Int. J. Adv. Res. Comput. Commun. Eng. 4(3) (2015)
Wu, W., Wu, X., Hacigümüs, H., Naughton, J.F.: Uncertainty aware query execution time prediction. In: Proceedings of the VLDB Endowment, vol. 7, no. 14 (2014)
Wu, W., Chi, Y., Zhu, S., Tatemura, J., Hacígümüş, H., Naughtony, J.F.: Predicting query execution time: are optimizer cost models really unusable?
Wu, W., Chi, Y., Hacígümüş, H., Naughton, J.F.: Towards predicting query execution time for concurrent and dynamic database workloads. In: Proceedings of the VLDB Endowment, vol. 6, no. 10 (2013)
Akdere, M., Cetintemel, U.: Learning-based query performance modeling and prediction
Hassan, M.M., Sultan, A.M.: SQOPI: semantic query optimization framework. Int. J. Comput. Appl. 96(6) (0975-8887) (2014)
Muhammad, L.J., Zakariyau, Y.B., Ali, A.G., Mohammed, I.A.: Multi query optimization algorithm using semantic and heuristic approaches. Int. J. Modern Nonlinear Theory Appl. (2016)
MySQL 5.7. http://downloads.mysql.com/docs/refman-5.7-en.pdf. Accessed 25 July 2016
Oracle Database 11g Release 2. http://docs.oracle.com/cd/E11882_01/server.112/e40402.pdf. Accessed 30 July 2016
PostgreSQL Release 9.5. www.postgresql.org/docs/9.5/static/docguide.html. Accessed 01 Aug 2016
MS SQL Server 2014. https://msdn.microsoft.com/en-us/library/mt238488.aspx. Accessed 06 Aug 2016
Lange, D., Naumann, F.: Proceedings of the 20th ACM Conference on Information and Knowledge Management (CIKM), pp. 243–248, Glasgow, Scotland, UK (2011)
Acknowledgements
Dr. Babasaheb Ambedkar Research and Training Institute (BARTI), Pune, supports this research. We are thankful to the Department of Computer Science and IT, Dr. Babasaheb Ambedkar Marathwada University, for providing necessary facility at prompt.
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
Misal, S.B., Gaikwad, A.T. (2019). Enhancing of Data Retrieval by Means of Database Query Analyzer (DBQA). In: Satapathy, S., Joshi, A. (eds) Information and Communication Technology for Intelligent Systems . Smart Innovation, Systems and Technologies, vol 107. Springer, Singapore. https://doi.org/10.1007/978-981-13-1747-7_10
Download citation
DOI: https://doi.org/10.1007/978-981-13-1747-7_10
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-1746-0
Online ISBN: 978-981-13-1747-7
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)