loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Authors: Eros Cedeño 1 ; Ana Aguilera 2 ; Denisse Muñante 3 ; Jorge Correia 1 ; Leonel Guerrero 1 ; Carlos Sivira 1 and Yudith Cardinale 1 ; 4

Affiliations: 1 Departamento Computación y Tecnología de la Información, Universidad Simón Bolívar, Caracas, Venezuela ; 2 Escuela de Ingeniería Informática, Facultad de Ingeniería, Universidad de Valparaíso, Chile ; 3 ENSIIE & SAMOVAR, Évry, France ; 4 Centro de Estudios en Ciancia de Datos e IA (ESenCIA), Universidad Internacional de Valencia, Spain

Keyword(s): Energy Consumption, Relational Databases, Empirical Evaluation, Query Optimization.

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.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 18.117.12.181

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 - ENASE; ISBN 978-989-758-696-5; ISSN 2184-4895, SciTePress, pages 657-665. DOI: 10.5220/0012708000003687

@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 - ENASE},
year={2024},
pages={657-665},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0012708000003687},
isbn={978-989-758-696-5},
issn={2184-4895},
}

TY - CONF

JO - Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - ENASE
TI - An Evaluation of the Impact of End-to-End Query Optimization Strategies on Energy Consumption
SN - 978-989-758-696-5
IS - 2184-4895
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

- Science and Technology Publications, Lda.
RESOURCES

Proceedings

Papers

Authors

Ontology

CONTACTS

Science and Technology Publications, Lda
Avenida de S. Francisco Xavier, Lote 7 Cv. C,
2900-616 Setúbal, Portugal.

Phone: +351 265 520 185 (National fixed network call)
Fax: +351 265 520 186
Email: info@scitepress.org

EXTERNAL LINKS

PRIMORIS

INSTICC

SCITEVENTS

CROSSREF

PROCEEDINGS SUBMITTED FOR INDEXATION BY:

dblp

Ei Compendex

SCOPUS

Semantic Scholar

Google Scholar

Microsoft Academic