SQL能耗建模及优化研究

IT系统能耗的节节攀升,使得设计新一代DBMS时必须考虑其能耗效率问题。由于SQL语句的执行过程大约消耗70%~90%的数据库资源,因此对SQL进行能耗建模及优化对提高数据库的能源使用效率具有重要的意义。在对SQL查询处理机制进行研究的基础上,构建了SQL能耗模型,并对一系列查询优化原则进行了实验,以表明不同优化原则对性能提升及能耗减少的有效性。实验及能耗数据分析表明:CPU利用率是影响系统功耗的最关键因素,SQL能耗优化方法可忽略内存优化且应该均衡考虑性能优化及功耗优化两方面,提出的SQL能耗模型及节能优化方法具有较强的应用价值。

Research on SQL Energy Consumption Modeling and Optimization

The increasing energy consumption of IT system makes us take energy efficiency into consideration when designing a new generation of DBMS.Because SQL queries consumes almost 70%~90% of the database resources,the energy efficiency of database can be improved by optimizing query and energy consumption modeling.After an in-depth study on optimization of query processing mechanism,an energy consumption model for SQL was proposed and many experiments were designed on a series of query optimization methods to show their effectiveness of performance improvement and energy reduction.Experiments and energy consumption data analysis prove that CPU utilization is the most critical factor that affects power consumption,SQL energy consumption optimization can ignore the memory optimization and should balance two aspects:performance optimization and power consumption optimization,and the model and the proposed methods have good application value.