Energy Efficient Query Processing in Green Database

Abstract

Data centers square measure renowned to consume giant amounts of energy. Since information is during all the main applications in a typical information center, building energy-aware information systems has become a lively analysis topic recently. The quantification of the energy price of information systems is a very important task in coming up with such systems. During this paper, we tend to report our recent efforts on this subject, with a spotlight on the energy price estimation of question plans throughout question improvement. We tend to begin from building a series of physical models for energy estimation of individual relative operators supported their resource consumption patterns. Since the execution of individual queries may be a combination of relative operators, we tend to use the physical models as a basis for a comprehensive energy price estimation model for entire question plans. To additional improve model accuracy underneath system dynamics and also the variations of work characteristics, we tend to develop an internet model estimation theme that dynamically corrects the static model supported advanced modeling techniques adopted from management engineering. Mistreatment the price model as a basis, the analysis model will utilize the trade-offs between power and performance of plans and helps the question optimizer choose plans that meet performance needs however lead to lower energy price. Finally, an inexperienced information framework integrated with the 2 higher than models is projected to boost a poster software. Experimental results reveal that, with reliable and correct applied math information, the projected framework during this study is able to do important energy savings and improve energy potency.