结构化查询语言动态功耗解析及建模  

Dynamic power consumption profiling and modeling by structured query language

作　　者：国冰磊 于炯[1] 廖彬[2] 杨德先[1] 

机构地区：[1]新疆大学软件学院,乌鲁木齐830008 [2]新疆财经大学统计与信息学院,乌鲁木齐830012

出　　处：《计算机应用》2015年第12期3362-3367,共6页journal of Computer Applications

基　　金：国家自然科学基金资助项目(61462079;61363083;61262088);新疆自然科学基金资助项目(2011211A011)

摘　　要：为构建节能的绿色数据库,提出一种基于结构化查询语言(SQL)资源(中央处理单元(CPU)、磁盘)消耗的最小单位的数据库动态能耗模型。该模型对系统动态能耗进行解析,将系统主要硬件(CPU、磁盘)的资源消耗映射成功率消耗,采用多元线性回归方法拟合模型关键参数,实时地估算系统动态功率,构建单位统一的动态功耗模型。实验结果表明,相比基于元组总数的模型,CPU指令总数能更好地反映CPU的功率消耗,所构模型在数据库管理系统(DBMS)独占系统资源的静态环境下,平均相对误差小于6%,绝对误差不超过9%。该动态功耗模型更适合于构建节能的绿色数据库。In order to build energy-saving green database, a database model of dynamic power consumption based on the smallest unit of Structured Query Language（ SQL） resource（ Central Processing Unit（ CPU）, disk） consumption. The proposed model profiled the dynamic power consumption and mapped the main hardwares（ CPU, disk） resource consumption to power consumption. Key parameters of the model were fitted by adopting the method of multiple linear regression to estimate the dynamic system power in real-time and build the unit-unified model of dynamic power consumption. The experimental results show that, compared with the model based on the total number of tuples, the total number of CPU instructions can better reflect the CPU power consumption. The average relative error of the constitutive model is less than 6% and the absolute error of the constitutive model is less than 9% while the Data Base Management System（ DBMS） monopolizes system resources in the static environment. The proposed dynamic power consumption model is more suitable for building energy-saving green database.

关 键 词：绿色计算 查询处理 执行计划 结构化查询语言 功耗建模 

分 类 号：TP315[自动化与计算机技术—计算机软件与理论]