Analyzing the Energy Efficiency of a Database Server

Summary: Characterizes database operator power profiles on a server, showing wide dynamic ranges, up to 60% variance, and non-linear CPU power for the same utilization. In a single-node scale-out, energy-optimal config is usually the top performer; notes cross-node energy and scale-out implications. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h71017401299a604a
Venue: SIGMOD
Year: 2010
Pagerank: 0.00013178114
Overall Rank: 902 | 93.94%
DOI: 10.1145/1807167.1807194

Incoming Non-self Citations Over Time

Authors

1. Dimitris Tsirogiannis (University of Toronto)
2. Stavros Harizopoulos (Hewlett Packard Enterprise)
3. Mehul A. Shah (Hewlett Packard Enterprise)

BibTeX Citation

@inproceedings{tsirogiannis_sigmod10,
        title = {{Analyzing the Energy Efficiency of a Database Server}},
        author = {Tsirogiannis, Dimitris and Harizopoulos, Stavros and Shah, Mehul A.},
        series = {{SIGMOD} '10},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1807167.1807194},
        url = {https://dl.acm.org/doi/10.1145/1807167.1807194},
        year = {2010}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
400	Monkey: Optimal Navigable Key-Value Store	2017	SIGMOD	0.00019124757
3,158	Energy Management for MapReduce Clusters	2010	VLDB	7.5798726e-05
4,123	The bionic DBMS is coming, but what will it look like?	2013	CIDR	6.7901576e-05
5,463	PET: Reducing Database Energy Cost via Query Optimization	2012	VLDB	6.1201995e-05
6,058	Towards Energy-Efficient Database Cluster Design	2012	VLDB	5.8979077e-05
6,262	A Performance Study of Big Data on Small Nodes	2015	VLDB	5.8301898e-05
7,737	One DBMS for all: the Brawny Few and the Wimpy Crowd	2014	SIGMOD	5.4628404e-05
8,719	WattDB: An Energy-Proportional Cluster of Wimpy Nodes	2011	SIGMOD	5.2880532e-05
9,102	DimmStore: Memory Power Optimization for Database Systems	2019	VLDB	5.2258409e-05
9,548	Controlled Intentional Degradation in Analytical Video Systems	2022	SIGMOD	5.159717e-05
9,933	Workload-Aware CPU Performance Scaling for Transactional Database Systems	2018	SIGMOD	5.1079647e-05
10,054	Adaptive Energy-Control for In-Memory Database Systems	2018	SIGMOD	5.0871013e-05
11,356	Environmental Footprints of Query Processing: A Vision for Sustainable Database Architectures	2025	VLDB	4.9769913e-05
12,285	The Next 700 Transaction Processing Engines	2017	SIGMOD	4.9769913e-05
12,340	Energy Elasticity on Heterogeneous Hardware using Adaptive Resource Reconfiguration LIVE	2016	SIGMOD	4.9769913e-05
12,523	Green Databases Through Integration of Renewable Energy	2013	CIDR	4.9769913e-05
12,737	Performing Sound Flash Device Measurements: Some Lessons from uFLIP	2010	SIGMOD	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
76	Cache Conscious Algorithms for Relational Query Processing	1994	VLDB	0.00036891569
157	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD	0.00028316479
634	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00015367822
2,727	Energy Efficiency: The New Holy Grail of Data Management Systems Research	2009	CIDR	8.0858491e-05
2,878	Towards Eco-friendly Database Management Systems	2009	CIDR	7.9129052e-05
3,575	JouleSort: A Balanced Energy-Efficiency Benchmark	2007	SIGMOD	7.1927277e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,227	Energy-Utility Function-Based Resource Control for In-Memory Database Systems LIVE	2018	SIGMOD
2	1,583	On the Design and Scalability of Distributed Shared-Data Databases	2015	SIGMOD
3	2,878	Towards Eco-friendly Database Management Systems	2009	CIDR
4	8,944	Performance and Scalability of Client-Server Database Architectures	1992	VLDB
5	9,102	DimmStore: Memory Power Optimization for Database Systems	2019	VLDB
6	9,369	A Case for Ecological Efficiency in Database Server Lifecycles	2025	CIDR
7	2,610	Energy Cost, The Key Challenge of Today’s Data Centers: A Power Consumption Analysis of TPC-C Results	2008	VLDB
8	10,054	Adaptive Energy-Control for In-Memory Database Systems	2018	SIGMOD
9	2,727	Energy Efficiency: The New Holy Grail of Data Management Systems Research	2009	CIDR
10	6,058	Towards Energy-Efficient Database Cluster Design	2012	VLDB