Database engines: Evolution of greenness. Issue 4 (16th November 2017)

• Record Type: Journal Article
• Authors: Miranskyy, A. V.; Al‐zanbouri, Z.; Godwin, D.; Bener, A. B.
• Is Part Of: Journal of software. Volume 30:Issue 4(2018)
• Page Start: n/a
• Page End: n/a
• Publication Date: 2017-11-16
• Subjects: energy consumption -- database -- green computing -- MySQL -- software metrics; Software engineering -- Periodicals; Computer software -- Development -- Periodicals; Software maintenance -- Periodicals; 005.1
• DOI: 10.1002/smr.1915
• Languages: English
• ISSNs: 2047-7473

Abstract

Abstract: Information technology consumes up to 10% of the world's electricity generation, contributing to CO2 emissions and high energy costs. Data centers, particularly databases, use up to 23% of this energy. Therefore, building an energy‐efficient (green) database engine could reduce energy consumption and CO2 emissions. The goal of this study is to understand the factors driving databases' energy consumption and execution time throughout their evolution. We conducted an empirical case study of energy consumption by 2 MySQL database engines, InnoDB and MyISAM, across 40 releases. We examined the relationships of 4 software metrics to energy consumption and execution time to determine which metrics reflect the greenness and performance of a database. Our analysis shows that database engines' energy consumption and execution time increase as databases evolve. Moreover, the lines of code (LOC) metric is correlated moderately to strongly with energy consumption and execution time in 88% of cases. Our findings provide insights to practitioners and researchers. Database administrators may use them to select a fast, green release of the MySQL database engine. MySQL developers may use LOC to assess products' greenness and performance. Researchers may use our findings to further develop new hypotheses or build models predicting greenness and performance of databases.