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

Details

Serval ID
serval:BIB_F4A54043494B
Type
A part of a book
Collection
Publications
Institution
Title
Energy-Efficient Query Processing in a Combined Database and Web Service Environment
Title of the book
Green Computing Strategies for Competitive Advantage and Business Sustainability
Author(s)
Niinimäki M., Abaunza F., Niemi T., Thanisch P., Kommeri J.
Publisher
IGI Global
ISBN
9781522550174
9781522550181
ISSN
2327-3453
2327-3461
Publication state
Published
Issued date
02/2018
Pages
62-88
Language
english
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.
Create date
28/02/2018 10:15
Last modification date
21/08/2019 5:11
Usage data