Offloaded Data Processing Energy Efficiency Evaluation

IF 3.3 4区计算机科学 Q2 COMPUTER SCIENCE, INFORMATION SYSTEMS

Informatica Pub Date : 2024-07-24 DOI:10.15388/24-infor567

Victor Prokhorenko, Muhammad Ali Babar

{"title":"Offloaded Data Processing Energy Efficiency Evaluation","authors":"Victor Prokhorenko, Muhammad Ali Babar","doi":"10.15388/24-infor567","DOIUrl":null,"url":null,"abstract":"The growing popularity of mobile and cloud computing raises new challenges related to energy efficiency. This work evaluates four various SQL and NoSQL database solutions in terms of energy efficiency. Namely, Cassandra, MongoDB, Redis, and MySQL are taken into consideration. This study measures energy efficiency of the chosen data storage solutions on a selected set of physical and virtual computing nodes by leveraging Intel RAPL (Running Average Power Limit) technology. Various database usage scenarios are considered in this evaluation including both local usage and remote offloading. Different workloads are benchmarked through the use of YCSB (Yahoo! Cloud Serving Benchmark) tool. Extensive experimental results show that (i) Redis and MongoDB are more efficient in energy consumption under most usage scenarios, (ii) remote offloading saves energy if the network latency is low and destination CPU is significantly more powerful, and (iii) computationally weaker CPUs may sometimes demonstrate higher energy efficiency in terms of J/ops. An energy efficiency measurement framework is proposed in order to evaluate and compare different database solutions based on the obtained experimental results.\nPDF  XML","PeriodicalId":56292,"journal":{"name":"Informatica","volume":"67 1","pages":""},"PeriodicalIF":3.3000,"publicationDate":"2024-07-24","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Informatica","FirstCategoryId":"94","ListUrlMain":"https://doi.org/10.15388/24-infor567","RegionNum":4,"RegionCategory":"计算机科学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"COMPUTER SCIENCE, INFORMATION SYSTEMS","Score":null,"Total":0}

引用次数: 0

Abstract

The growing popularity of mobile and cloud computing raises new challenges related to energy efficiency. This work evaluates four various SQL and NoSQL database solutions in terms of energy efficiency. Namely, Cassandra, MongoDB, Redis, and MySQL are taken into consideration. This study measures energy efficiency of the chosen data storage solutions on a selected set of physical and virtual computing nodes by leveraging Intel RAPL (Running Average Power Limit) technology. Various database usage scenarios are considered in this evaluation including both local usage and remote offloading. Different workloads are benchmarked through the use of YCSB (Yahoo! Cloud Serving Benchmark) tool. Extensive experimental results show that (i) Redis and MongoDB are more efficient in energy consumption under most usage scenarios, (ii) remote offloading saves energy if the network latency is low and destination CPU is significantly more powerful, and (iii) computationally weaker CPUs may sometimes demonstrate higher energy efficiency in terms of J/ops. An energy efficiency measurement framework is proposed in order to evaluate and compare different database solutions based on the obtained experimental results. PDF XML

查看原文本刊更多论文

卸载数据处理能效评估

移动和云计算的日益普及带来了与能效有关的新挑战。这项工作从能效角度评估了四种不同的 SQL 和 NoSQL 数据库解决方案。即 Cassandra、MongoDB、Redis 和 MySQL。本研究利用英特尔 RAPL（平均运行功耗限制）技术，在一组选定的物理和虚拟计算节点上测量了所选数据存储解决方案的能效。评估中考虑了各种数据库使用场景，包括本地使用和远程卸载。通过使用 YCSB（雅虎云服务基准）工具对不同的工作负载进行了基准测试。广泛的实验结果表明：(i) Redis 和 MongoDB 在大多数使用场景下的能耗效率更高；(ii) 如果网络延迟较低且目标 CPU 性能明显更强，则远程卸载可节省能耗；(iii) 计算能力较弱的 CPU 有时可能在 J/ops 方面表现出更高的能效。本文提出了一个能效测量框架，以便根据获得的实验结果评估和比较不同的数据库解决方案。PDF XML

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

Informatica 工程技术-计算机：信息系统

CiteScore

5.90

自引率

6.90%

发文量

审稿时长

12 months

期刊介绍： The quarterly journal Informatica provides an international forum for high-quality original research and publishes papers on mathematical simulation and optimization, recognition and control, programming theory and systems, automation systems and elements. Informatica provides a multidisciplinary forum for scientists and engineers involved in research and design including experts who implement and manage information systems applications.