International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
Call for Papers | Fully Refereed | Open Access | Double Blind Peer Reviewed

ISSN: 2319-7064


Downloads: 2 | Views: 94 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1

Review Papers | Computer Science and Information Technology | United States of America | Volume 12 Issue 12, December 2023


Optimizing Data Warehousing Performance through Machine Learning Algorithms in the Cloud

Sina Ahmadi


Abstract: This comprehensive overview explores the integration of machine learning (ML) in data warehousing, focusing on optimization challenges, methodologies, results, and future trends. Data warehouses, central to reporting and analysis, undergo a transformative shift with ML, addressing challenges like high maintenance costs and failure rates. The integration enhances performance through query optimization, indexing, and automated data management. Results showcase ML's application in predictive analytics for workload management, automated query optimization, and adaptive resource allocation, thus improving efficiency. However, challenges include data privacy, security concerns, and skill/resource constraints. The future scope anticipates trends like Explainable AI, Automated ML, Augmented Analytics, Federated Learning, and Continuous Intelligence, offering potential impacts on decision-making, resource allocation, data management, privacy, and real-time responsiveness. This succinct summary encapsulates the critical aspects of ML in data warehousing for holistic understanding.


Keywords: cloud, data warehousing, machine learning, algorithm


Edition: Volume 12 Issue 12, December 2023,


Pages: 1859 - 1867


How to Download this Article?

Type Your Valid Email Address below to Receive the Article PDF Link


Verification Code will appear in 2 Seconds ... Wait

Top