AlphaSort: a cache-sensitive parallel external sort
The VLDB Journal — The International Journal on Very Large Data Bases
Cache Conscious Algorithms for Relational Query Processing
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Performance tradeoffs in read-optimized databases
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
JouleSort: a balanced energy-efficiency benchmark
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Power provisioning for a warehouse-sized computer
Proceedings of the 34th annual international symposium on Computer architecture
No "power" struggles: coordinated multi-level power management for the data center
Proceedings of the 13th international conference on Architectural support for programming languages and operating systems
OLTP through the looking glass, and what we found there
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Database servers tailored to improve energy efficiency
SETMDM '08 Proceedings of the 2008 EDBT workshop on Software engineering for tailor-made data management
Tracking the power in an enterprise decision support system
Proceedings of the 14th ACM/IEEE international symposium on Low power electronics and design
FAWN: a fast array of wimpy nodes
Proceedings of the ACM SIGOPS 22nd symposium on Operating systems principles
Delivering energy proportionality with non energy-proportional systems: optimizing the ensemble
HotPower'08 Proceedings of the 2008 conference on Power aware computing and systems
A comparison of high-level full-system power models
HotPower'08 Proceedings of the 2008 conference on Power aware computing and systems
Performing sound flash device measurements: some lessons from uFLIP
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Building a power-aware database management system
Proceedings of the Fourth SIGMOD PhD Workshop on Innovative Database Research
Enhancing energy efficiency of database applications using SSDs
Proceedings of the Third C* Conference on Computer Science and Software Engineering
Energy management for MapReduce clusters
Proceedings of the VLDB Endowment
MemScale: active low-power modes for main memory
Proceedings of the sixteenth international conference on Architectural support for programming languages and operating systems
ARCS'11 Proceedings of the 24th international conference on Architecture of computing systems
WattDB: an energy-proportional cluster of wimpy nodes
Proceedings of the 2011 ACM SIGMOD International Conference on Management of data
A case for micro-cellstores: energy-efficient data management on recycled smartphones
Proceedings of the Seventh International Workshop on Data Management on New Hardware
Energy efficiency is not enough, energy proportionality is needed!
DASFAA'11 Proceedings of the 16th international conference on Database systems for advanced applications
Does low-power design imply energy efficiency for data centers?
Proceedings of the 17th IEEE/ACM international symposium on Low-power electronics and design
A survey on energy-efficient data management
ACM SIGMOD Record
Breaking up is hard to do: security and functionality in a commodity hypervisor
SOSP '11 Proceedings of the Twenty-Third ACM Symposium on Operating Systems Principles
DreamWeaver: architectural support for deep sleep
ASPLOS XVII Proceedings of the seventeenth international conference on Architectural Support for Programming Languages and Operating Systems
ACM Transactions on Architecture and Code Optimization (TACO)
Peak power plays in database engines
Proceedings of the 15th International Conference on Extending Database Technology
Energy- and Cost-Efficiency Analysis of ARM-Based Clusters
CCGRID '12 Proceedings of the 2012 12th IEEE/ACM International Symposium on Cluster, Cloud and Grid Computing (ccgrid 2012)
Building a power-proportional software router
USENIX ATC'12 Proceedings of the 2012 USENIX conference on Annual Technical Conference
Towards energy-efficient database cluster design
Proceedings of the VLDB Endowment
ACM Transactions on Architecture and Code Optimization (TACO)
PET: reducing database energy cost via query optimization
Proceedings of the VLDB Endowment
Ursa: Scalable Load and Power Management in Cloud Storage Systems
ACM Transactions on Storage (TOS)
KnightShift: Scaling the Energy Proportionality Wall through Server-Level Heterogeneity
MICRO-45 Proceedings of the 2012 45th Annual IEEE/ACM International Symposium on Microarchitecture
Energy efficiency for MapReduce workloads: an in-depth study
ADC '12 Proceedings of the Twenty-Third Australasian Database Conference - Volume 124
The impact of solid state drive on search engine cache management
Proceedings of the 36th international ACM SIGIR conference on Research and development in information retrieval
ISRN Communications and Networking
Energy-proportional query execution using a cluster of wimpy nodes
Proceedings of the Ninth International Workshop on Data Management on New Hardware
Energy-efficient in-memory database computing
Proceedings of the Conference on Design, Automation and Test in Europe
Exploiting Redundancies and Deferred Writes to Conserve Energy in Erasure-Coded Storage Clusters
ACM Transactions on Storage (TOS)
Monitoring and Autoscaling IaaS Clouds: A Case for Complex Event Processing on Data Streams
UCC '13 Proceedings of the 2013 IEEE/ACM 6th International Conference on Utility and Cloud Computing
Hi-index | 0.00 |
Rising energy costs in large data centers are driving an agenda for energy-efficient computing. In this paper, we focus on the role of database software in affecting, and, ultimately, improving the energy efficiency of a server. We first characterize the power-use profiles of database operators under different configuration parameters. We find that common database operations can exercise the full dynamic power range of a server, and that the CPU power consumption of different operators, for the same CPU utilization, can differ by as much as 60%. We also find that for these operations CPU power does not vary linearly with CPU utilization. We then experiment with several classes of database systems and storage managers, varying parameters that span from different query plans to compression algorithms and from physical layout to CPU frequency and operating system scheduling. Contrary to what recent work has suggested, we find that within a single node intended for use in scale-out (shared-nothing) architectures, the most energy-efficient configuration is typically the highest performing one. We explain under which circumstances this is not the case, and argue that these circumstances do not warrant a retargeting of database system optimization goals. Further, our results reveal opportunities for cross-node energy optimizations and point out directions for new scale-out architectures.