能效查询处理与优化可行性初探-计算机系统应用.PDFVIP

计 算 机 系 统 应 用 2014 年 第 23 卷 第 4 期 ① 能效查询处理与优化可行性初探 吴 岩, 杨良怀, 潘 建 (浙江工业大学 计算机科学与技术学院, 杭州 310014) (浙江省可视媒体智能处理技术研究重点实验室, 杭州 310014) 摘 要: 随着数据管理需求的不断增长, 降低与控制数据中心的能耗成为一个挑战性问题. DBMS 是数据中心核 心软件, 能效查询处理与优化是其中一个重要议题. 本文提出了新型的能耗代价评估模型, 通过评估查询计划的 时间和能耗代价, 考察了不同优化目标在不同硬件条件下对查询处理的影响. 实验表明, 传统硬件下面向性能的 优化与面向能耗的优化结果是一致的; 在新硬件条件下, 两者结果则不同, 可以改进数据库系统能效. 关键词: 能耗; 代价模型; 查询优化; 查询处理 Towards Energy Efficient Query Optimization WU Yan, YANG Liang-Huai, 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) Abstract: 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. Key words: energy consumption; cost model; query optimization; query processing 1 引言 储层次中进行面向能效查询优化是充满机遇的. 传统数据库系统中硬盘存取代价占统治地位, 其 为解决 DBMS 的能效查询优化问题, 本文构建了 查询优化面向性能