Abstract: Power modeling and power profiling of database workload are the foundation of building energy-aware DBMS.To solve the high energy consumption problem of database workload,this paper proposed a method of building energy prediction model for database workload by mapping resource consumption of the main components(CPU and Disk) to their power and time cost.Firstly,power cost of workload is estimated according to their resource consumption pattern.Secondly,energy cost of workload is estimated by combing the power cost and time cost derived from the resource consumption pattern.And finally,a deep research of the model prediction accuracy is conducted by using the MBRC settings.Experimental results show that,the proposed energy prediction modeling method can make accurate estimation of workload energy cost,and the research on accuracy of model prediction can improve the reliability and accuracy of the energy modeling method under different system settings.

Key words: Green computing,Relational database,Green database,SQL energy modeling,MBRC