FUTURE TRENDS IN SQL DATABASES AND BIG DATA ANALYTICS: IMPACT OF MACHINE LEARNING AND ARTIFICIAL INTELLIGENCE

Abstract

This study systematically reviews the integration of machine learning (ML) and artificial intelligence (AI) into SQL databases and big data analytics, highlighting significant advancements and emerging trends. Using the Preferred Reporting Items for Systematic Reviews and Meta-Analyses (PRISMA) guidelines, a comprehensive review of 60 selected articles published between 2010 and 2023 was conducted. The findings reveal substantial improvements in query optimization through ML algorithms, which adapt dynamically to changing data patterns, reducing processing times and enhancing performance. Additionally, embedding ML models within SQL databases facilitates real-time predictive analytics, streamlining workflows, and improving the accuracy and speed of predictions. AI-driven security systems provide proactive and real-time threat detection, significantly enhancing data protection. The development of hybrid systems that combine relational and non-relational databases offers versatile and efficient data management solutions, addressing the limitations of traditional systems. This study confirms the evolving role of AI and ML in transforming data management practices and aligns with and extends previous research findings.