HAL will be down for maintenance from Friday, June 10 at 4pm through Monday, June 13 at 9am. More information
Skip to Main content Skip to Navigation
Conference papers

Vers le traitement et optimisation écologique des requêtes

Abstract : Nowadays, energy reduction has now become a critical and urgent issue for the database community. A lot of initiatives have been launched on energy-efficiency for intensive-workload computation covering individual hardware components, system software, to applications. This computation is mainly ensured by query optimizers. In this paper, we claim that building from scratch a green query processors and revisiting existing ones passes through 4-steps procedure:(1) establishment of a deep audit that allows understanding the query processor functioning, (2) identification of relevant energy-sensitive parameters belonging to hardware and software components, (3) elaboration of mathematical cost models estimating consumed energy when executing a single query on a target DBMS and (4) setting of values of the energy-sensitive parameters using a nonlinear regression technique. To show the effectiveness of this procedure, we apply it on two open-source DBMSs with different functioning policies: PostgreSQL and MonetDB and compared them using the dataset and the workload of the TPC-H benchmark.
Document type :
Conference papers
Complete list of metadata

Cited literature [20 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-02926090
Contributor : Simon Pierre Dembele Connect in order to contact the contributor
Submitted on : Monday, August 31, 2020 - 1:00:56 PM
Last modification on : Friday, September 4, 2020 - 4:27:32 PM
Long-term archiving on: : Tuesday, December 1, 2020 - 12:27:44 PM

File

CARI2020-03.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-02926090, version 1

Collections

Citation

Simon Pierre Dembele, Bellatreche Ladjel, Ordonez Carlos. Vers le traitement et optimisation écologique des requêtes. CARI 2020 - Colloque Africain sur la Recherche en Informatique et en Mathématiques Apliquées, Oct 2020, Thiès, Sénégal. ⟨hal-02926090⟩

Share

Metrics

Record views

92

Files downloads

40