摘要
随着数据管理需求的不断增长,降低与控制数据中心的能耗成为一个挑战性问题.DBMS是数据中心核心软件,能效查询处理与优化是其中一个重要议题.本文提出了新型的能耗代价评估模型,通过评估查询计划的时间和能耗代价,考察了不同优化目标在不同硬件条件下对查询处理的影响.实验表明,传统硬件下面向性能的优化与面向能耗的优化结果是一致的;在新硬件条件下,两者结果则不同,可以改进数据库系统能效.
With the growing demand for data management, it is a great challenge to reduce and throttle the energy consumption in data centers. DBMS is a vital software in data center to deal with volumes of data, thus, energy efficient query processing and optimization is one of the critical issues to be solved. We proposed a novel cost model to estimate energy consumption of a query plan, and we investigated the effects of different optimization goals on query optimization under different hardware configurations. Experiements demonstrated that the results of performance-oriented and energy-oriented query optimization are same under the traditional hardware configuration, while the results turned out to be different under the new hardware configuration, which indicates that it is practical to improve the energy efficiency of database systems.
出处
《计算机系统应用》
2014年第4期178-182,共5页
Computer Systems & Applications
基金
国家自然科学基金(61070042)
浙江省自然科学基金(Y13F020110)
关键词
能耗
代价模型
查询优化
查询处理
energy consumption
cost model
query optimization
query processing
