Simon Pierre Dembele ; Ladjel Bellatreche ; Carlos Ordonez ; Nabil Gmati ; Mathieu Roche et al. - Big Steps Towards Query Eco-Processing - Thinking Smart

arima:6767 - Revue Africaine de Recherche en Informatique et Mathématiques Appliquées, March 30, 2021, Volume 34 - Special Issue CARI 2020 - 2021 - https://doi.org/10.46298/arima.6767
Big Steps Towards Query Eco-Processing - Thinking SmartArticle

Authors: Simon Pierre Dembele ORCID1,2; Ladjel Bellatreche ORCID1,2; Carlos Ordonez 3; Nabil Gmati ; Mathieu Roche ORCID; Tri Nguyen-Huu ; Laurent Debreu

Computers and electronic machines in businesses consume a significant amount of electricity, releasing carbon dioxide (CO2), which contributes to greenhouse gas emissions. Energy efficiency is a pressing concern in IT systems, ranging from mobile devices to large servers in data centers, in order to be more environmentally responsible. In order to meet the growing demands in the awareness of excessive energy consumption, many initiatives have been launched on energy efficiency for big data processing covering electronic components, software and applications. Query optimizers are one of the most power consuming components of a DBMS. They can be modified to take into account the energetical cost of query plans by using energy-based cost models with the aim of reducing the power consumption of computer systems. In this paper, we study, describe and evaluate the design of three energy cost models whose values of energy sensitive parameters are determined using the Nonlinear Regression and the Random Forests techniques. To this end, we study in depth the operating principle of the selected DBMS and present an analysis comparing the performance time and energy consumption of typical queries in the TPC benchmark. We perform extensive experiments on a physical testbed based on PostreSQL, MontetDB and Hyrise systems using workloads generatedusing our chosen benchmark to validate our proposal.


Volume: Volume 34 - Special Issue CARI 2020 - 2021
Published on: March 30, 2021
Accepted on: March 3, 2021
Submitted on: September 8, 2020
Keywords: Green query processing,DBMS audit,NonLinear Regression technique,Random Forest Technique,[INFO]Computer Science [cs],[INFO.INFO-AI]Computer Science [cs]/Artificial Intelligence [cs.AI],[INFO.INFO-DB]Computer Science [cs]/Databases [cs.DB]

1 Document citing this article

Consultation statistics

This page has been seen 377 times.
This article's PDF has been downloaded 525 times.