CAJ | 학술논문

随着数据管理需求的不断增长，降低与控制数据中心的能耗成为一个挑战性问题。 DBMS 是数据中心核心软件，能效查询处理与优化是其中一个重要议题。本文提出了新型的能耗代价评估模型，通过评估查询计划的时间和能耗代价，考察了不同优化目标在不同硬件条件下对查询处理的影响。实验表明，传统硬件下面向性能的优化与面向能耗的优化结果是一致的；在新硬件条件下，两者结果则不同，可以改进数据库系统能效。
수착수거관리수구적불단증장，강저여공제수거중심적능모성위일개도전성문제。 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.