Revolutionizing Database Efficiency: A Comprehensive Exploration of Query Processing Strategies and Optimization Technique
Abstract
Query processing and optimization play a crucial role in enhancing the efficiency of database systems by reducing query execution time and improving overall system performance. In this paper, we have integrated various approaches to optimize query execution time and minimize costs by eliminating poorly constructed SQL statements. The optimization process involves considering potential query plans based on lineage, aiming to identify the most efficient way to execute a specific query. Our approach incorporates several key components, including a scanner and parser, intermediate query representation, and a query optimizer. By evaluating the order of all clauses, multiple query execution plans can be generated. The query optimizer then selects the most efficient plan, influencing the ultimate result of the query. This study underscores the significance of employing diverse query optimization techniques and sheds light on their effectiveness. Ultimately, the insights gained from this research can assist both database administrators and developers in making well-informed decisions when selecting the most suitable query optimization technique for their specific database system.
References
[2] A.Despande, Z.Ives and V.Raman,”Adaptive query processing”, Foundation and trend in databases, vol. 1, No. 1(2007) 1-140
[3] A. Hameurlain, “Evolution of Query Optimization Methods: From Centralized Database Systems to Data Grid Systems”, Proceedings of the 20th International Conference on Database and Expert Systems Applications, (2009).
[4] E. Zafarani, M. Reza, H. Asil and A. Asil, “Presenting a New Method for Optimizing Join Queries Processing in Heterogeneous Distributed Databases”, In Knowledge Discovery and Data Mining,WKDD ’10, (2010).
[5] Henk Ernst Blok, Djoerd Hiemstra and Sunil Choenni, Franciska de Jong, Henk M. Blanken and Peter M.G. Apers. Predicting the cost-quality trade-off for information retrieval queries: Facilitatiing database design and query optimization. Proceedings of the tenth international conference on Information and knowledge management, October 2001, Pages 207-214.
[6] D. Apriani, A. Williams, U. Rahardja, A. Khoirunisa, and S. Avionita, “The Use of Science Technology In Islamic Practices and Rules In The Past Now and The Future,” International Journal of Cyber and IT Service Management, vol. 1, no. 1 SE-Articles, pp. 48–64, Apr. 2021.
[7] D. Cahyadi, A. Faturahman, H. Haryani, E. Dolan, and S. millah, “BCS : Blockchain Smart Curriculum System for Verification Student Accreditation,” International Journal of Cyber and IT Service Management, vol. 1, no. 1 SE-Articles, pp. 65–83, Apr. 2021.
[8] Pirahesh, H., Hellerstein, J.M., Hasan, W.: Extensible/rule based query rewrite optimization in starburst. In: Proceedings of the International Conference on Management of Data (SIGMOD), pp. 39–48 (1992)
[9] Weipeng P. Yan, Per Ake Larson, “Performing Group by before join”, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.
[10] Won Kim, “On Optimizing an SQL-like Nested Query”, ACM Transactions on Database Systems, Vol. 7, No. 3, September 1982.
[11] Jean Habimana, “Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries”, International Journal Of Scientific & Technology Research Volume 4, Issue 10, October 2015 ISSN 2277-8616 22.
[12] Vamsi Krishna Myalapalli and Pradeep Raj Savarapu, “High Performance SQL”, 11th IEEE International Conference on Emerging Trends in Innovation and Technology, December 2014, Pune, India.
[13] Vanier, E.; Shah, B.; Malepati, T. Advanced MySQL 8; Packt Publishing Limited: Birmingham, UK, 2019; ISBN 1788834445.
[14] Sahal, R.; Khafagy, M.H.; Omara, F.A. Comparative study of multi-query optimization techniques using shared predicate-based for big data. Int. J. Grid Distrib. Comput. 2016, 9, 229–240.
