Eleazar Leal

Eleazar Leal

Auto-generated profile, based on publicly available information

Eleazar Leal

Department of Computer Science, University of Minnesota Duluth, Duluth, USA

Research Focus & Metrics

Academic Career Length

6Years (2021-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
26 January 2022 in The VLDB Journal
Verified
Journal Article
Closed access
PDF file
EPEgawati Panjei
Egawati Panjei
LGLe Gruenwald
Le Gruenwald
ELEleazar Leal
Eleazar Leal
CNChristopher Nguyen
Christopher Nguyen
SSShejuti Silvia
Shejuti Silvia

13 May 2023 in Distributed and Parallel Databases
Verified
Journal Article
Closed access
PDF file
HMHamza Mustafa
Hamza Mustafa
CBClark Barrus
Clark Barrus
ELEleazar Leal
Eleazar Leal
LGLe Gruenwald
Le Gruenwald

28 February 2021 in International Journal of Database Management Systems
Verified
Journal Article
Open access
Chenxiao WangChenxiao Wang
Chenxiao Wang
ZAZach Arani
Zach Arani
LGLe Gruenwald
Le Gruenwald
LDLaurent D'Orazio
Laurent D'Orazio
ELEleazar Leal
Eleazar Leal
In cloud environments, hardware configurations, data usage, and workload allocations are continuously changing. These changes make it difficult for the query optimizer of a cloud database management system (DBMS) to select an optimal query execution plan (QEP). In order to optimize a query with a more accurate cost estimation, performing query re-optimizations during the query execution has been proposed in the literature. However, some of there-optimizations may not provide any performance gain in terms of query response time or monetary costs, which are the two optimization objectives for cloud databases, and may also have negative impacts on the performance due to their overheads. This raises the question of how to determine when are-optimization is beneficial. In this paper, we present a technique called ReOptML that uses machine learning to enable effective re-optimizations. This technique executes a query in stages, employs a machine learning model to predict whether a query re-optimization is beneficial after a stage is executed, and invokes the query optimizer to perform the re-optimization automatically. The experiments comparing ReOptML with existing query re-optimization algorithms show that ReOptML improves query response time from 13% to 35% for skew data and from 13% to 21% for uniform data, and improves monetary cost paid to cloud service providers from 17% to 35% on skewdata.