Generating Power-Efficient Query Execution Plan

DOI

10.2991/cse.2013.64How to use a DOI?

Keywords

query execution plan; power-efficiency; power model;

Abstract

As more and more power is consumed in servers, growing attention has been paid to power management. However, little work has been dated on the power-efficiency of query execution plans generated by the DBMS. Traditional optimal query execution plan does not take power-efficiency into account. This paper tries to generate a power-efficient query execution plan by redesigning the query optimizer of the database. We build a power model to estimate the power consumption of a query execution plan and propose an algorithm to generate the power-efficient query execution plan. Using two experiments based on the TPC-H benchmark, we evaluate the accuracy of our power model and compare the power-efficient query execution plan with the traditional optimal query execution plan.

Copyright

© 2013, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Xiaowei Liu
AU  - Jinbao Wang
AU  - Haijie Wang
AU  - Hong Gao
PY  - 2013/07
DA  - 2013/07
TI  - Generating Power-Efficient Query Execution Plan
BT  - Proceedings of the 2nd International Conference on Advances in Computer Science and Engineering (CSE 2013)
PB  - Atlantis Press
SP  - 286
EP  - 290
SN  - 1951-6851
UR  - https://doi.org/10.2991/cse.2013.64
DO  - 10.2991/cse.2013.64
ID  - Liu2013/07
ER  -