{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,8,2]],"date-time":"2025-08-02T04:14:51Z","timestamp":1754108091829,"version":"3.41.0"},"reference-count":18,"publisher":"Association for Computing Machinery (ACM)","issue":"1","license":[{"start":{"date-parts":[[2014,5,13]],"date-time":"2014-05-13T00:00:00Z","timestamp":1399939200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2014,5,13]]},"abstract":"<jats:p>Energy consumption of computer systems has increased at a steep rate in recent years. Following extensive energyrelated research and practice in the hardware and OS communities, much attention has been paid to developing energy-efficient applications. With database systems being a heavy energy consumer in modern data centers, we face the challenge of designing DBMSs with energy as a first-class performance goal. This paper presents our on-goingwork in designing and implementing a DBMS that enables significant energy conservations while maintaining other performance targets. We follow two new strategies in DBMS implementation to achieve our system design goal. The first one is to change the resource consumption patterns via energy-aware query optimization and reorganizing data records to enable load consolidation in disks. The second strategy is active control of power modes of hardware (i.e., CPU and hard disks) toward energy reduction. Specifically, we use control-theoretic techniques to allowdynamic adjustment of CPU frequency and online data migration to achieve disk load consolidation. Preliminary results have shown the effectiveness of our design.<\/jats:p>","DOI":"10.1145\/2627692.2627696","type":"journal-article","created":{"date-parts":[[2014,5,27]],"date-time":"2014-05-27T12:56:59Z","timestamp":1401195419000},"page":"21-26","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":25,"title":["A system for energy-efficient data management"],"prefix":"10.1145","volume":"43","author":[{"given":"Yi-Cheng","family":"Tu","sequence":"first","affiliation":[{"name":"University of South Florida"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xiaorui","family":"Wang","sequence":"additional","affiliation":[{"name":"The Ohio State University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bo","family":"Zeng","sequence":"additional","affiliation":[{"name":"University of South Florida"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zichen","family":"Xu","sequence":"additional","affiliation":[{"name":"The Ohio State University"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2014,5,13]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Ultrastar 7k4000 OEM specification. http:\/\/www.hgst.com\/tech\/techlib.nsf\/products\/ultrastar 7k4000.  Ultrastar 7k4000 OEM specification. http:\/\/www.hgst.com\/tech\/techlib.nsf\/products\/ultrastar 7k4000."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1736020.1736048"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1109\/MC.2004.217"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1088149.1088188"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/1385486.1385494"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/859618.859638"},{"key":"e_1_2_1_7_1","volume-title":"CIDR","author":"Harizopoulos S.","year":"2009","unstructured":"S. Harizopoulos : The new holy grail of data management systems research . In CIDR , 2009 . S. Harizopoulos et al. Energy efficiency: The new holy grail of data management systems research. In CIDR, 2009."},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2247596.2247648"},{"key":"e_1_2_1_9_1","volume-title":"CIDR","author":"Lang W.","year":"2009","unstructured":"W. Lang and J. Patel . Towards eco-friendly database management systems . In CIDR , 2009 . W. Lang and J. Patel. Towards eco-friendly database management systems. In CIDR, 2009."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.868912"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454162"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2010.5447806"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/1791314.1791336"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/980152.980157"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807194"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2010.5447840"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367546"},{"key":"e_1_2_1_18_1","first-page":"315","volume-title":"Tu. Power-Aware Throughput Control for Database Management Systems. In the 10th International Conference on Autonomic Computing","author":"Xu Z.","year":"2013","unstructured":"Z. Xu , X. Wang , and Y.- C. Tu. Power-Aware Throughput Control for Database Management Systems. In the 10th International Conference on Autonomic Computing , pages 315 -- 324 , 2013 . Z. Xu, X. Wang, and Y.-C. Tu. Power-Aware Throughput Control for Database Management Systems. In the 10th International Conference on Autonomic Computing, pages 315--324, 2013."}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2627692.2627696","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2627692.2627696","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T07:01:36Z","timestamp":1750230096000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2627692.2627696"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,5,13]]},"references-count":18,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2014,5,13]]}},"alternative-id":["10.1145\/2627692.2627696"],"URL":"https:\/\/doi.org\/10.1145\/2627692.2627696","relation":{},"ISSN":["0163-5808"],"issn-type":[{"type":"print","value":"0163-5808"}],"subject":[],"published":{"date-parts":[[2014,5,13]]},"assertion":[{"value":"2014-05-13","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}