Optimizing Cloud Resources for Machine Learning Applications: A Comparative Study of SQL-Driven and Python-Driven Workflows

Cloud computing has become a cornerstone for machine learning (ML) applications, offering scalable infrastructure to process vast amounts of data. This study evaluates SQL-driven and Python-driven workflows in cloud-based ML, focusing on execution time, cost efficiency, and performance across platforms like AWS, GCP, and Azure. Results reveal that SQL-driven workflows excel in speed and cost-effectiveness for structured data preprocessing, while Python-driven workflows provide superior flexibility and accuracy for advanced analytics and modeling. A hybrid approach integrating both workflows is recommended to optimize resource utilization and achieve a balance between efficiency and performance. The findings underscore the importance of selecting appropriate cloud resources and adopting monitoring tools to ensure scalability and cost control. These insights provide a roadmap for organizations seeking to enhance the efficiency and effectiveness of their cloud-based ML operations

Institutions

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2024-08-29
DOI
https://doi.org/10.5281/zenodo.14423700
Primary Topic
Cloud Computing and Resource Management
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Optimizing Cloud Resources for Machine Learning Applications: A Comparative Study of SQL-Driven and Python-Driven Workflows

Zenodo (CERN European Organization for Nuclear Research)
Cloud Computing and Resource Management
article

Optimizing Cloud Resources for Machine Learning Applications: A Comparative Study of SQL-Driven and Python-Driven Workflows

article en

Abstract

Cloud computing has become a cornerstone for machine learning (ML) applications, offering scalable infrastructure to process vast amounts of data. This study evaluates SQL-driven and Python-driven workflows in cloud-based ML, focusing on execution time, cost efficiency, and performance across platforms like AWS, GCP, and Azure. Results reveal that SQL-driven workflows excel in speed and cost-effectiveness for structured data preprocessing, while Python-driven workflows provide superior flexibility and accuracy for advanced analytics and modeling. A hybrid approach integrating both workflows is recommended to optimize resource utilization and achieve a balance between efficiency and performance. The findings underscore the importance of selecting appropriate cloud resources and adopting monitoring tools to ensure scalability and cost control. These insights provide a roadmap for organizations seeking to enhance the efficiency and effectiveness of their cloud-based ML operations

Zenodo (CERN European Organization for Nuclear Research)
Clinical Research Solutions (US), Torc Robotics (United States) (US)
Industry, innovation and infrastructure
Openalex Percentile: Top 35%
Cloud Computing and Resource Management
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.