Energy-Efficient Query Processing in a Combined Database and Web Service Environment

Abstract

The energy-efficiency of server hardware, web server software, and databases has been widely studied. However, studies that combine these aspects are rare. In this chapter, the authors present an energy-efficiency evaluation of a web/database application in a Windows/IIS/MSSQL environment running on an industrial grade Intel server. Moreover, they provide a wide overview of related research and technologies. Researchers have noticed that despite energy-saving technologies, energy consumption of data centers is still growing. To resolve this dilemma, the authors explore the background and propose concrete solutions. They concentrate on the following aspects: server BIOS/operating system energy optimization (limited impact) and “bursting” (i.e., queuing requests and then executing them in bursts). The authors have used the bursting method with both database and web/database applications. Their results indicate about 10% energy savings using this method. The authors analyse the model using statistical tools and present an equation to express the quality of service vs. burst wait time relationship.