###

DOI:

计算机系统应用英文版:2013,22(3):16-20,24

View/Add Comment 过刊浏览高级检索 HTML

←前一篇 | 后一篇→

码上扫一扫！

下载全文

PostgreSQL数据库在不同调节器中的能效比较

王萌^1,2, 杨良怀^1,2, 王英姿^1,2, 潘建^1,2

(1.浙江工业大学计算机科学与技术学院, 杭州 310014;2.浙江省可视媒体智能处理技术研究重点实验室, 杭州 310014)

Energy Efficiency Comparisons for PostgreSQL Under Different Governors

WANG Meng^1,2, YANG Liang-Huai^1,2, WANG Ying-Zi^1,2, PAN Jian^1,2

(1.School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China;2.Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China)

摘要

图/表

参考文献

相似文献

本文已被：浏览 1536次下载 2879次
Received:September 05, 2012 Revised:October 17, 2012

中文摘要: 近年来, 能效数据库系统成为数据库领域的一个研究议题.CPU动态电压频率调节(DVFS)是一种有效的动态功率节能技术. 探寻PostgreSQL数据库在ACPI不同调节器下查询操作的性能、能耗、功率之间潜在联系, 发现动态功耗管理与数据库系统的能效关系, 通过运行TPC-H测试基准生成的数据库与相应22个查询, 总结出调节器对数据库查询处理各种操作的影响.实验结果表明, DVFS可以对DBMS进行动态功耗管理是有效的, 查询处理的不同操作具有各自特性, 利用这些特性来设计效率更高的调节器是颇有前途的.

中文关键词: 数据库系统能效 ACPI 动态电压频率调节

Abstract:Energy-efficient DBMS has become a hot research topic for recent years. CPU DVFS is an effective dynamic power management scheme. This paper looks into the relationships between performance, energy and power in PostgreSQL under different governors with the aim to discover the power saving effectiveness in DBMS from hardware perspective. After running 22 TPC-H benchmark queries, we summarize the effects of 4 governors on different query processing operators. The experiment results show that CPU DVFS is effective on DBMS energy-efficiency, and different query operators have their respective power usage characteristics and can be exploited to design more efficient customized governors.

keywords: database system energy efficiency ACPI DVFS

文章编号： 中图分类号： 文献标志码：

基金项目:国家自然科学基金(61070042);浙江省自然科学基金(Y1090096)

Author Name	Affiliation
WANG Meng	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China
YANG Liang-Huai	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China
WANG Ying-Zi	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China
PAN Jian	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China

Author Name	Affiliation
WANG Meng	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China
YANG Liang-Huai	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China
WANG Ying-Zi	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China
PAN Jian	School of Computer Science and Technology, Zhejiang University of Technology, Hangzhou 310014, China Key Laboratory of Visual Media Intelligent Process Technology of Zhejiang Province, Hangzhou 310014, China

引用文本：
王萌,杨良怀,王英姿,潘建.PostgreSQL数据库在不同调节器中的能效比较.计算机系统应用,2013,22(3):16-20,24
WANG Meng,YANG Liang-Huai,WANG Ying-Zi,PAN Jian.Energy Efficiency Comparisons for PostgreSQL Under Different Governors.COMPUTER SYSTEMS APPLICATIONS,2013,22(3):16-20,24