Performance Evaluation of SQL-on-Lake Engines and Traditional Data Warehouses for Analytical Workloads

The rapid growth of big data and cloud computing has transformed the way organizations store, manage, and analyse large volumes of data. Among the emerging analytical platforms, SQL-on-Lake engines and traditional data warehouses have become widely adopted for supporting business intelligence and decision-making. However, selecting the most appropriate architecture remains challenging because each platform offers distinct advantages in terms of performance, scalability, and resource utilization. This study evaluated and compared the performance of SQL-on-Lake engines and traditional data warehouses for analytical workloads using an experimental approach. Performance evaluation was based on six metrics: query execution time, throughput, CPU utilization, memory utilization, scalability, and storage efficiency. The results showed that the traditional data warehouse consistently achieved lower query execution times, higher throughput, and more efficient CPU and memory utilization for structured analytical queries. In contrast, the SQL-on-Lake engine demonstrated superior scalability and storage efficiency, particularly as dataset size increased, making it more suitable for processing large-scale and heterogeneous datasets. The findings reveal that each architecture exhibits unique strengths depending on workload characteristics and operational requirements. The study concludes that neither architecture is universally superior for all analytical scenarios. It is therefore recommended that traditional data warehouses be adopted for latency-sensitive business intelligence applications, while SQL-on-Lake engines should be preferred for cloud-native environments requiring scalable, flexible, and cost-efficient analytics over diverse and rapidly growing datasets. The study contributes empirical evidence to support informed architectural decisions in modern data analytics.

Authors

Institutions

Publication Details

Journal
Iconic Research and Engineering Journals
Published
2026-11-17
DOI
https://doi.org/10.64388/ire1725270
Primary Topic
Advanced Database Systems and Queries
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

Performance Evaluation of SQL-on-Lake Engines and Traditional Data Warehouses for Analytical Workloads

Mya Franklin, Onyedikachi Iheanacho Nnadi
5 links
Iconic Research and Engineering Journals
Advanced Database Systems and Queries
article

Performance Evaluation of SQL-on-Lake Engines and Traditional Data Warehouses for Analytical Workloads

Mya Franklin, Onyedikachi Iheanacho Nnadi
article en

Abstract

The rapid growth of big data and cloud computing has transformed the way organizations store, manage, and analyse large volumes of data. Among the emerging analytical platforms, SQL-on-Lake engines and traditional data warehouses have become widely adopted for supporting business intelligence and decision-making. However, selecting the most appropriate architecture remains challenging because each platform offers distinct advantages in terms of performance, scalability, and resource utilization. This study evaluated and compared the performance of SQL-on-Lake engines and traditional data warehouses for analytical workloads using an experimental approach. Performance evaluation was based on six metrics: query execution time, throughput, CPU utilization, memory utilization, scalability, and storage efficiency. The results showed that the traditional data warehouse consistently achieved lower query execution times, higher throughput, and more efficient CPU and memory utilization for structured analytical queries. In contrast, the SQL-on-Lake engine demonstrated superior scalability and storage efficiency, particularly as dataset size increased, making it more suitable for processing large-scale and heterogeneous datasets. The findings reveal that each architecture exhibits unique strengths depending on workload characteristics and operational requirements. The study concludes that neither architecture is universally superior for all analytical scenarios. It is therefore recommended that traditional data warehouses be adopted for latency-sensitive business intelligence applications, while SQL-on-Lake engines should be preferred for cloud-native environments requiring scalable, flexible, and cost-efficient analytics over diverse and rapidly growing datasets. The study contributes empirical evidence to support informed architectural decisions in modern data analytics.

Iconic Research and Engineering JournalsVol. 10(5)
Rivers State University (NG)
Advanced Database Systems and Queries
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.

Laika access coming soon