An Evaluation of the Impact of End-to-End Query Optimization Strategies on Energy Consumption

Eros Cedeño, Ana Aguilera, Denisse Muñante, Jorge Correia, Leonel Guerrero, Carlos Sivira, Yudith Cardinale, Yudith Cardinale

2024

Abstract

Query optimization strategies is an important aspect in database systems that have been mainly studied only from the perspective of reducing the execution time, neglecting the analysis of their impact on energy consumption. We perform an empirical evaluation for understanding the impact of end-to-end query optimization strategies on the power consumption of database systems, from both client and server perspectives. We perform tests over a PostgreSQL database for two optimization strategies (i.e., indexation and data compression) using the TPC-H benchmark, configured with 22 queries on a 1GB dataset. To measure the energy consumption of both client and server, we propose Juliet, a C++ agent for monitoring and estimating Linux processes energy consumption in Joules (J). Experimental results show that indexation is more effective than data compression to reduce the energy consumed by the execution of the majority of the 22 queries tested.

Paper Citation

in Harvard Style

Cedeño E., Aguilera A., Muñante D., Correia J., Guerrero L., Sivira C. and Cardinale Y. (2024). An Evaluation of the Impact of End-to-End Query Optimization Strategies on Energy Consumption. In Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE; ISBN 978-989-758-696-5, SciTePress, pages 657-665. DOI: 10.5220/0012708000003687

in Bibtex Style

@conference{enase24,
author={Eros Cedeño and Ana Aguilera and Denisse Muñante and Jorge Correia and Leonel Guerrero and Carlos Sivira and Yudith Cardinale},
title={An Evaluation of the Impact of End-to-End Query Optimization Strategies on Energy Consumption},
booktitle={Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE},
year={2024},
pages={657-665},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0012708000003687},
isbn={978-989-758-696-5},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE
TI - An Evaluation of the Impact of End-to-End Query Optimization Strategies on Energy Consumption
SN - 978-989-758-696-5
AU - Cedeño E.
AU - Aguilera A.
AU - Muñante D.
AU - Correia J.
AU - Guerrero L.
AU - Sivira C.
AU - Cardinale Y.
PY - 2024
SP - 657
EP - 665
DO - 10.5220/0012708000003687
PB - SciTePress