Proceedings of the 2nd International Conference on Advances in Computer Science and Engineering (CSE 2013)

Generating Power-Efficient Query Execution Plan

Authors
Xiaowei Liu, Jinbao Wang, Haijie Wang, Hong Gao
Corresponding Author
Xiaowei Liu
Available Online July 2013.
DOI
https://doi.org/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.
Open Access
This is an open access article distributed under the CC BY-NC license.

Download article (PDF)

Proceedings
2nd International Conference on Advances in Computer Science and Engineering (CSE 2013)
Part of series
Advances in Intelligent Systems Research
Publication Date
July 2013
ISBN
978-90786-77-70-3
ISSN
1951-6851
DOI
https://doi.org/10.2991/cse.2013.64How to use a DOI?
Open Access
This is an open access article distributed under the CC BY-NC license.

Cite this article

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  - 2nd International Conference on Advances in Computer Science and Engineering (CSE 2013)
PB  - Atlantis Press
SN  - 1951-6851
UR  - https://doi.org/10.2991/cse.2013.64
DO  - https://doi.org/10.2991/cse.2013.64
ID  - Liu2013/07
ER  -