Title
Tracking the power in an enterprise decision support system
Abstract
Enterprises rely on decision support systems to influence critical business choices. At the same time, IT-related power costs are growing and are a key concern for enterprise executives. Yet, there is little work to date characterizing the power use of decision support systems. Towards this end, we present the first holistic measurements and analysis of an audit-class system running the TPC-H decision support benchmark at the 300GB scale. We first provide a breakdown of the system's power use into its core hardware components. We then explore its power-performance tradeoffs. This investigation shows that there is ample room to improve its energy use without sacrificing much performance. Moreover, the most energy-efficient configuration depends on the workload. These results suggest that, going forward, database software has an important role to play in optimizing for energy use.
Year
DOI
Venue
2009
10.1145/1594233.1594295
ISLPED
Keywords
Field
DocType
ample room,power use,decision support system,energy use,core hardware component,critical business choice,enterprise decision support system,audit-class system,it-related power cost,database software,tpc-h decision support benchmark,energy efficiency,decision support,energy,power
Workload,Computer science,Efficient energy use,Decision support system,Real-time computing
Conference
Citations 
PageRank 
References 
14
1.07
14
Authors
5
Name
Order
Citations
PageRank
Justin Meza141918.08
Mehul A. Shah23547317.66
Parthasarathy Ranganathan33316230.61
Mike Fitzner4141.07
Judson Veazey5141.74