Abstract
This study explores the analysis and modeling of energy consumption in the context of database workloads, aiming to develop an eco-friendly database management system (DBMS). It leverages vibration energy harvesting systems with self-sustaining wireless vibration sensors (WVSs) in combination with the least square support vector machine algorithm to establish an energy consumption model (ECM) for relational database workloads. Through experiments, the performance of self-sustaining WVS in providing power is validated, and the accuracy of the proposed ECM during the execution of Structured Query Language (SQL) statements is evaluated. The findings demonstrate that this approach can reliably predict the energy consumption of database workloads, with a maximum prediction error rate of 10% during SQL statement execution. Furthermore, the ECM developed for relational databases closely approximates actual energy consumption for query operations, with errors ranging from 1 to 4%. In most cases, the predictions are conservative, falling below the actual values. This finding underscores the high predictive accuracy of the ECM in anticipating relational database workloads and their associated energy consumption. Additionally, this paper delves into prediction accuracy under different types of operations and reveals that ECM excels in single-block read operations, outperforming multi-block read operations. ECM exhibits substantial accuracy in predicting energy consumption for SQL statements in sequential and random read modes, especially in specialized database management system environments, where the error rate for the sequential read model is lower. In comparison to alternative models, the proposed ECM offers superior precision. Furthermore, a noticeable correlation between model error and the volume of data processed by SQL statements is observed. In summary, the relational database ECM introduced in this paper provides accurate predictions of workload and database energy consumption, offering a theoretical foundation and practical guidance for the development of eco-friendly DBMS.