Paper Info
Title
Estimating Power/Energy Consumption in Database Servers.
Abstract
The explosive growth in the size of data centers, coupled with the wide-spread use of virtualization technology has brought power and energy consumption as major concerns for data center administrators. Provisioning decisions must take into consideration not only target application performance but also the power demands and total energy consumption incurred by the hardware and software. Failure to do so will result in damaged equipment, power outages, and ine_cient operation. Since database servers comprise one of the most popular and important server applications deployed in such facilities, it becomes necessary to have accurate cost models that can predict the power and energy demands that each database workloads will impose in the system. In this paper we present an empirical methodology to estimate the power and energy cost of database operations. Our methodology uses multiple-linear regression and factorial experimental design to derive accurate cost models that depend only on readily available statistics such as selectivity factors, tuple size, numbers columns and relational cardinality. Moreover, our method does not need measurement of individual hardware components, but rather total power and energy consumption measured at a server. We have implemented our methodology, and ran experiments with several server configurations. Our experiments indicate that we can predict power and energy more accurately than alternative methods.
Year
DOI
Venue
2011
10.1016/j.procs.2011.08.022
Procedia Computer Science
Keywords
Field
DocType
cloud computing,energy e_ciency,query processing
Virtualization,Data mining,Tuple,Computer science,Provisioning,Software,Database server,Data center,Energy consumption,Cloud computing
Journal
Volume
ISSN
Citations 
6
1877-0509
9
PageRank 
References 
Authors
0.55
8
4
Name
Order
Citations
PageRank
Manuel Rodríguez-Martínez1194.07
Harold Valdivia290.55
Jaime Seguel33910.02
Melvin Greer4243.55