.png){kind=icon}
返回
A green framework for DBMS based on energy-aware query optimization and energy-efficient query processing
.png){kind=icon}
PRE
AI
DOI：10.1016/j.jnca.2017.02.015.png)
.png){kind=icon}
原文求助.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
Traditional database systems result in high energy consumption and low energy efficiency due to the lack of consideration of energy issues and environmental adaptation in the design process. In this study, we report our recent efforts on this issue, with a focus on energy-aware query optimization and energy-efficient query processing. Firstly, a method of modeling energy cost of query plans during query processing based on their resource consumption patterns is proposed, which helps predict energy cost of queries before execution. Secondly, as the traditional query optimizer focuses on solely optimizing for performance and ignores energy efficient query plans, a query-plan evaluation model is proposed after a comprehensive study of plan evaluation principles. Using the cost model as a basis, the evaluation model can utilizes the trade-offs between power and performance of plans, and helps the query optimizer select plans that meet performance requirements but result in lower energy cost. Finally, a green database framework integrated with the two above models is proposed to enhance a commercial DBMS. Experimental results reveal that, with reliable and accurate statistical data, the proposed framework in this study can achieve significant energy savings and improve energy efficiency.
Keyword:
Green database
Query optimization
Energy saving
Energy efficiency
Query-plan evaluation
Energy-aware
AI总结
对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
8
论文数:
3.6K
被引数:
1.1W
机构
引用论文
.png){kind=icon}
分享收藏
查看更多内容