Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database
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 combinati...
| Main Authors: | , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Nature Portfolio
2023-11-01
|
| Series: | Scientific Reports |
| Online Access: | https://doi.org/10.1038/s41598-023-46414-3 |
| _version_ | 1797636925758111744 |
|---|---|
| author | Dexian Yang Jiong Yu Zhenzhen He Ping Li Xusheng Du |
| author_facet | Dexian Yang Jiong Yu Zhenzhen He Ping Li Xusheng Du |
| author_sort | Dexian Yang |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-03-11T12:42:08Z |
| format | Article |
| id | doaj.art-c9ed00b52509433ba6be9d2f2cc4fd35 |
| institution | Directory Open Access Journal |
| issn | 2045-2322 |
| language | English |
| last_indexed | 2024-03-11T12:42:08Z |
| publishDate | 2023-11-01 |
| publisher | Nature Portfolio |
| record_format | Article |
| series | Scientific Reports |
| spelling | doaj.art-c9ed00b52509433ba6be9d2f2cc4fd352023-11-05T12:16:53ZengNature PortfolioScientific Reports2045-23222023-11-0113111610.1038/s41598-023-46414-3Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational databaseDexian Yang0Jiong Yu1Zhenzhen He2Ping Li3Xusheng Du4School of Information Science and Engineering, Xinjiang UniversitySchool of Information Science and Engineering, Xinjiang UniversitySchool of Information Science and Engineering, Xinjiang UniversitySchool of Information Science and Engineering, Xinjiang UniversitySchool of Information Science and Engineering, Xinjiang UniversityAbstract 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.https://doi.org/10.1038/s41598-023-46414-3 |
| spellingShingle | Dexian Yang Jiong Yu Zhenzhen He Ping Li Xusheng Du Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database Scientific Reports |
| title | Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database |
| title_full | Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database |
| title_fullStr | Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database |
| title_full_unstemmed | Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database |
| title_short | Applying self-powered sensor and support vector machine in load energy consumption modeling and prediction of relational database |
| title_sort | applying self powered sensor and support vector machine in load energy consumption modeling and prediction of relational database |
| url | https://doi.org/10.1038/s41598-023-46414-3 |
| work_keys_str_mv | AT dexianyang applyingselfpoweredsensorandsupportvectormachineinloadenergyconsumptionmodelingandpredictionofrelationaldatabase AT jiongyu applyingselfpoweredsensorandsupportvectormachineinloadenergyconsumptionmodelingandpredictionofrelationaldatabase AT zhenzhenhe applyingselfpoweredsensorandsupportvectormachineinloadenergyconsumptionmodelingandpredictionofrelationaldatabase AT pingli applyingselfpoweredsensorandsupportvectormachineinloadenergyconsumptionmodelingandpredictionofrelationaldatabase AT xushengdu applyingselfpoweredsensorandsupportvectormachineinloadenergyconsumptionmodelingandpredictionofrelationaldatabase |