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

Les métriques sont temporairement indisponibles