Generating Power-Efficient Query Execution Plan
Xiaowei Liu, Jinbao Wang, Haijie Wang, Hong Gao
Available Online July 2013.
- https://doi.org/10.2991/cse.2013.64How to use a DOI?
- query execution plan; power-efficiency; power model;
- 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.
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 SP - 286 EP - 290 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 -