- Titel
- Energy-Efficient Databases Using Sweet Spot Frequencies
- Zitierfähige Url:
- https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-818929
- Konferenz
- 2014 IEEE/ACM 7th International Conference on Utility and Cloud Computing. London, 08.-11.12.2014
- Quellenangabe
- 2014 IEEE/ACM 7th International Conference on Utility and Cloud Computing. Proceedings
Erscheinungsort: New York
Verlag: IEEE
Erscheinungsjahr: 2014
Seiten: 871-876 - Erstveröffentlichung
- 2014
- Abstract (EN)
- Database management systems (DBMS) are typically tuned for high performance and scalability. Nevertheless, carbon footprint and energy efficiency are also becoming increasing concerns. Unfortunately, existing studies mainly present theoretical contributions but fall short on proposing practical techniques. These could be used by administrators or query optimizers to increase the energy efficiency of the DBMS. Thus, this paper explores the effect of so-called sweet spots, which are energy-efficient CPU frequencies, on the energy required to execute queries. From our findings, we derive the Sweet Spot Technique, which relies on identifying energy-efficient sweet spots and the optimal number of threads that minimizes energy consumption for a query or an entire database workload. The technique is simple and has a practical implementation leading to energy savings of up to 50% compared to using the nominal frequency and maximum number of threads.
- Andere Ausgabe
- Link zum Artikel, der zuerst in der IEEE Xplore Digital Library erschienen ist.
DOI: 10.1109/UCC.2014.142 - Freie Schlagwörter (DE)
- Datenbanken, Energieeffizienz, DVFS
- Freie Schlagwörter (EN)
- databases, energy-efficiency, DVFS
- Verlag
- IEEE, New York
- Version / Begutachtungsstatus
- angenommene Version / Postprint / Autorenversion
- URN Qucosa
- urn:nbn:de:bsz:14-qucosa2-818929
- Veröffentlichungsdatum Qucosa
- 12.01.2023
- Dokumenttyp
- Konferenzbeitrag
- Sprache des Dokumentes
- Englisch
- Lizenz / Rechtehinweis
