CAJ | 학술논문

近年来,能效数据库系统成为数据库领域的一个研究议题.CPU 动态电压频率调节(DVFS)是一种有效的动态功率节能技术.探寻PostgreSQL数据库在ACPI不同调节器下查询操作的性能、能耗、功率之间潜在联系,发现动态功耗管理与数据库系统的能效关系,通过运行TPC-H测试基准生成的数据库与相应22个查询,总结出调节器对数据库查询处理各种操作的影响.实验结果表明, DVFS可以对DBMS进行动态功耗管理是有效的,查询处理的不同操作具有各自特性,利用这些特性来设计效率更高的调节器是颇有前途的.
근년래,능효수거고계통성위수거고영역적일개연구의제.CPU 동태전압빈솔조절(DVFS)시일충유효적동태공솔절능기술.탐심PostgreSQL수거고재ACPI불동조절기하사순조작적성능、능모、공솔지간잠재련계,발현동태공모관리여수거고계통적능효관계,통과운행TPC-H측시기준생성적수거고여상응22개사순,총결출조절기대수거고사순처리각충조작적영향.실험결과표명, DVFS가이대DBMS진행동태공모관리시유효적,사순처리적불동조작구유각자특성,이용저사특성래설계효솔경고적조절기시파유전도적.
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.