Machine Learning Approaches for Enhancing Query Optimization in Large Databases
Journal Title: Engineering and Technology Journal - Year 2025, Vol 10, Issue 03
Abstract
More effective query optimization strategies in large-scale databases are required due to the growing volume and complexity of data in contemporary applications. Performance inefficiencies result from traditional query optimization techniques, such as rule-based and cost-based approaches, which frequently find it difficult to manage dynamic and complicated workloads. By utilizing deep learning, reinforcement learning, and predictive analytics to enhance query execution plans, indexing, and workload management, machine learning (ML) has become a game-changing method for improving query optimization. With its many advantages—including workload-aware indexing, adaptive tuning, and real-time performance improvements—ML-driven optimization approaches are especially well-suited for distributed and cloud-based database setups. However, challenges remain, such as the need for more explainable AI-powered optimizers, security vulnerabilities, and the high computational costs of training machine learning models. To ensure reliable and efficient database management, future research should focus on creating hybrid optimization frameworks, strengthening security measures, and making machine learning-based decision-making more explainable. By addressing these challenges, machine learning-powered query optimization could open the door to smarter, more flexible, and scalable database systems.
Authors and Affiliations
Warveen merza eido , Hajar Maseeh Yasin,
Keywords
Related Articles
- EP ID EP762259
- DOI 10.47191/etj/v10i03.39
- Views 11
- Downloads 0
THE MODULATORY EFFECTS OF HORMONES ON SATO, RAJO AND TAMO GUNA
Hormones are a substance which, produced in any one part of an organism, is transferred to another part and there influences a specific physiological process. Hormones are chemical messengers which can trigger genetic fl...
DISTRIBUTION UTILITY-OWNED EMBEDDED 5MW AC SOLAR POWER A Feasibility Study
Solar energy creates clean, renewable power from the sun and benefits the environment. Alternatives to fossil fuels reduce carbon footprint and greenhouse gases around the globe. Distribution system is a process by which...
CONCENTRATED SOLAR THERMAL TECHNOLOGY FOR POWER GENERATION AND ITS CASE STUDIES
The dependence on conventional energy sources since the Industrial revolution has increased extensively, affecting our environment. Over-exploitation of natural resources has led to the increased global average temperatu...
Activated Carbon Prepared from Date Pits Using Microwave Heating
Activated carbon (AC) adsorption remains one of the most technically efficient water treatment processes. However, its high preparation cost, mainly due to energy-intensive methods, has led to research on developing effi...
Implementing the Based Weight Method using Game Theory for Faultfinding Lines in Electrical Power System
The Identification of critical transmission lines in a power system is crucial for ensuring its stability and reliability. Traditional methods often relay on static metrics, such as line loading or voltage deviations, w...