A Study of the Energy Consumption of Databases and Cloud Patterns. Bani, B., Khomh, F., & Guéhéneuc, Y. In Sheng, M., Stroulia, E., & Tata, S., editors, Proceedings of the 14<sup>th</sup> International Conference on Service Oriented Computing (ICSOC), pages 606–614, October, 2016. Springer. Short paper. 8 pages.Paper abstract bibtex Nowadays databases have become the backbone of cloud-based applications. Cloud-based applications are used in about every industry today. Despite their popularity and wide adoption, little is still known about the energy footprint of these applications and, in particular, of their databases. Yet, reducing the energy consumption of applications is a major objective for society and will continue to be so in the near to far future. In this paper, we study the energy consumption of three databases used by cloud-based applications: MySQL, PostgreSQL, and MongoDB, through a series of experiments with three cloud-based applications (a RESTful multi-threaded application, DVD Store, and JPetStore). We also study the impact of cloud patterns on the energy consumption because databases in cloud-based applications are often implemented in conjunction with patterns. We measure the energy consumption using the Power-API tool to keep track of the energy consumed at the process-level by the variants of the cloud-based applications. We report that the choice of the databases can reduce the energy consumption of a cloud-based application regardless of the cloud patterns that are implemented.
@INPROCEEDINGS{Bani16-ICSOC-CloudPatternEnergy,
author = {B{\'e}chir Bani and Foutse Khomh and Yann-Ga{\"e}l Gu{\'e}h{\'e}neuc},
title = {A Study of the Energy Consumption of Databases and Cloud Patterns},
booktitle = {Proceedings of the 14<sup>{th}</sup> International Conference on Service Oriented Computing ({ICSOC})},
year = {2016},
month = {October},
editor = {Michael Sheng and Eleni Stroulia and Samir Tata},
publisher = {Springer},
note = {Short paper. 8 pages.},
abstract = {
Nowadays databases have become the backbone of cloud-based applications.
Cloud-based applications are used in about every industry today. Despite
their popularity and wide adoption, little is still known about the energy
footprint of these applications and, in particular, of their databases. Yet,
reducing the energy consumption of applications is a major objective for
society and will continue to be so in the near to far future. In this paper,
we study the energy consumption of three databases used by cloud-based
applications: MySQL, PostgreSQL, and MongoDB, through a series of experiments
with three cloud-based applications (a RESTful multi-threaded application,
DVD Store, and JPetStore). We also study the impact of cloud patterns on the
energy consumption because databases in cloud-based applications are often
implemented in conjunction with patterns. We measure the energy consumption
using the Power-API tool to keep track of the energy consumed at the
process-level by the variants of the cloud-based applications. We report that
the choice of the databases can reduce the energy consumption of a
cloud-based application regardless of the cloud patterns that are
implemented.},
grant = {NSERC DG and CRC on Software Patterns},
keywords = {Evolution patterns ; ICSOC},
kind = {MISA},
language = {english},
url = {http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf},
pdf = {http://www.ptidej.net/publications/documents/ICSOC16b.ppt.pdf},
pages = {606--614}
}
Downloads: 0
{"_id":"theTwq8QeAiMSCvZW","bibbaseid":"bani-khomh-guhneuc-astudyoftheenergyconsumptionofdatabasesandcloudpatterns-2016","downloads":0,"creationDate":"2018-01-17T20:29:42.185Z","title":"A Study of the Energy Consumption of Databases and Cloud Patterns","author_short":["Bani, B.","Khomh, F.","Guéhéneuc, Y."],"year":2016,"bibtype":"inproceedings","biburl":"http://www.yann-gael.gueheneuc.net/Work/BibBase/guehene (automatically cleaned).bib","bibdata":{"bibtype":"inproceedings","type":"inproceedings","author":[{"firstnames":["Béchir"],"propositions":[],"lastnames":["Bani"],"suffixes":[]},{"firstnames":["Foutse"],"propositions":[],"lastnames":["Khomh"],"suffixes":[]},{"firstnames":["Yann-Gaël"],"propositions":[],"lastnames":["Guéhéneuc"],"suffixes":[]}],"title":"A Study of the Energy Consumption of Databases and Cloud Patterns","booktitle":"Proceedings of the 14<sup>th</sup> International Conference on Service Oriented Computing (ICSOC)","year":"2016","month":"October","editor":[{"firstnames":["Michael"],"propositions":[],"lastnames":["Sheng"],"suffixes":[]},{"firstnames":["Eleni"],"propositions":[],"lastnames":["Stroulia"],"suffixes":[]},{"firstnames":["Samir"],"propositions":[],"lastnames":["Tata"],"suffixes":[]}],"publisher":"Springer","note":"Short paper. 8 pages.","abstract":"Nowadays databases have become the backbone of cloud-based applications. Cloud-based applications are used in about every industry today. Despite their popularity and wide adoption, little is still known about the energy footprint of these applications and, in particular, of their databases. Yet, reducing the energy consumption of applications is a major objective for society and will continue to be so in the near to far future. In this paper, we study the energy consumption of three databases used by cloud-based applications: MySQL, PostgreSQL, and MongoDB, through a series of experiments with three cloud-based applications (a RESTful multi-threaded application, DVD Store, and JPetStore). We also study the impact of cloud patterns on the energy consumption because databases in cloud-based applications are often implemented in conjunction with patterns. We measure the energy consumption using the Power-API tool to keep track of the energy consumed at the process-level by the variants of the cloud-based applications. We report that the choice of the databases can reduce the energy consumption of a cloud-based application regardless of the cloud patterns that are implemented.","grant":"NSERC DG and CRC on Software Patterns","keywords":"Evolution patterns ; ICSOC","kind":"MISA","language":"english","url":"http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf","pdf":"http://www.ptidej.net/publications/documents/ICSOC16b.ppt.pdf","pages":"606–614","bibtex":"@INPROCEEDINGS{Bani16-ICSOC-CloudPatternEnergy,\n author = {B{\\'e}chir Bani and Foutse Khomh and Yann-Ga{\\\"e}l Gu{\\'e}h{\\'e}neuc},\n title = {A Study of the Energy Consumption of Databases and Cloud Patterns},\n booktitle = {Proceedings of the 14<sup>{th}</sup> International Conference on Service Oriented Computing ({ICSOC})},\n year = {2016},\n month = {October},\n editor = {Michael Sheng and Eleni Stroulia and Samir Tata},\n publisher = {Springer},\n note = {Short paper. 8 pages.},\n abstract = {\nNowadays databases have become the backbone of cloud-based applications.\nCloud-based applications are used in about every industry today. Despite\ntheir popularity and wide adoption, little is still known about the energy\nfootprint of these applications and, in particular, of their databases. Yet,\nreducing the energy consumption of applications is a major objective for\nsociety and will continue to be so in the near to far future. In this paper,\nwe study the energy consumption of three databases used by cloud-based\napplications: MySQL, PostgreSQL, and MongoDB, through a series of experiments\nwith three cloud-based applications (a RESTful multi-threaded application,\nDVD Store, and JPetStore). We also study the impact of cloud patterns on the\nenergy consumption because databases in cloud-based applications are often\nimplemented in conjunction with patterns. We measure the energy consumption\nusing the Power-API tool to keep track of the energy consumed at the\nprocess-level by the variants of the cloud-based applications. We report that\nthe choice of the databases can reduce the energy consumption of a\ncloud-based application regardless of the cloud patterns that are\nimplemented.},\n grant = {NSERC DG and CRC on Software Patterns},\n keywords = {Evolution patterns ; ICSOC},\n kind = {MISA},\n language = {english},\n url = {http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf},\n pdf = {http://www.ptidej.net/publications/documents/ICSOC16b.ppt.pdf},\n pages = {606--614}\n}\n\n","author_short":["Bani, B.","Khomh, F.","Guéhéneuc, Y."],"editor_short":["Sheng, M.","Stroulia, E.","Tata, S."],"key":"Bani16-ICSOC-CloudPatternEnergy","id":"Bani16-ICSOC-CloudPatternEnergy","bibbaseid":"bani-khomh-guhneuc-astudyoftheenergyconsumptionofdatabasesandcloudpatterns-2016","role":"author","urls":{"Paper":"http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf"},"keyword":["Evolution patterns ; ICSOC"],"metadata":{"authorlinks":{"gu�h�neuc, y":"https://bibbase.org/show?bib=http%3A%2F%2Fwww.yann-gael.gueheneuc.net%2FWork%2FPublications%2FBiblio%2Fcomplete-bibliography.bib&msg=embed","guéhéneuc, y":"https://bibbase.org/show?bib=http://www.yann-gael.gueheneuc.net/Work/BibBase/guehene%20(automatically%20cleaned).bib"}},"downloads":0,"html":""},"search_terms":["study","energy","consumption","databases","cloud","patterns","bani","khomh","guéhéneuc"],"keywords":["evolution patterns ; icsoc"],"authorIDs":["2tFXMaTSHJKEB5ebi","2wY5eBcsYmbPNfmMS","36dm7jaw5EK5Wrr4D","3NxaNKic3nkXi568L","3S5Dkpx7DNefzJrnf","3afmfmoPr4SHa8B5F","3wmHB7JoQbQz2ujun","4YBWWbao6RKgiyGJE","4jZj9tB4SJ8zEEgHk","5CvA2hsaib2bPMaef","5TFJbxqRDGFj2P8Rg","5a5fb236a39f2c3645000032","5a8f17e006df23bc34000020","5cx79LBmaWcihgM4J","5de9a6425b51bcde01000042","5dee1197584fb4df010000fc","5df228a41e4fe9df0100012c","5df617f72b34d0de0100008b","5dfa14782e791dde010000ea","5dfe3d5e68d95dde01000080","5e02525b6ffa15df0100009f","5e0662c07da1d1de0100021a","5e093e8b934cacdf0100008b","5e0a61673eccf6e001000016","5e0b75b7e73cd6de010000f9","5e0d4ca6ae5827df0100007f","5e0ddf08552b25df01000137","5e0e5c41ac7d11df010000a3","5e1268e7a4cabfdf0100002c","5e12c45a70e2c4f201000043","5e157809f1f31adf01000006","5e162ca1df1bb4de01000123","5e185cff809b84f201000091","5e1a6c39b16ec5df0100000f","5e21b27e96aea7de01000084","5e22c57e49e2b4df0100000f","5e23c2aeb93b51de01000030","5e245835079bb2df0100007d","5e24fa3e2e79a1f201000027","5e26252f408641df01000161","5e26bfbd8535cedf0100005c","5e280fd1f860fcde0100006a","5e2a827f881468de01000080","5e2eb321b84405df01000128","5e2ef635e374eede0100001a","5e2fd6a74e91a9df01000010","5e3266bb5633c9de01000068","5e32ab0ee17accde0100012a","5e32bdec466076df010000d9","5e32d603150c84df01000068","5e34fb145978bef2010000a6","5e36bc8e7b975dde0100009a","5e389940030bcadf010001b4","5e39dd9a3687dddf010000a4","5e3ad173f2a00cdf01000206","5e3dcd50d51253de0100003d","5e3e8713666d79df010000a6","5e3ed80986a596de010000b9","5e3fefe1add5fbde01000087","5e409c79d668c6de010000c7","5e41795ed9f47bee01000194","5e41cd5be7c67ade010000eb","5e42ef1ca6f4a6f2010001eb","5e46dcb342fb31df01000113","5e46f12c461d04f201000078","5e478c9e27a0c8de010000ef","5e47fb06385298df010000b2","5e4add1941072bdf01000011","5e4c1c792dc400de0100011a","5e4c6262271596df010001b9","5e4f0360338acfde01000156","5e4f11b0e5389bde0100007e","5e530b976d68b8df010000a5","5e54ad6d929495df0100007c","5e57161b429006de0100005a","5e57839fcef9b7de0100003c","5e580f5a6a456fde0100004f","5e5afa78038583de010000f7","5e5b477174a3e7df010000b7","5e5d370173eb2edf01000038","5e5fca336b32b0f20100011b","5e60e7f0839e59df010000e8","5e6377cfae1c4dde0100011e","5e657007de41b9df0100017a","5e676f0910be53de0100001a","5gPbX6aQJFjpv2Na9","6eE2yRdMDQr2WGXuA","6iHE5tuM7yTfLd2pA","7BPWyvMr5e6bzbk7T","7RFwhpGkpZRsLwnmB","7amRA4ALcR2mksheF","7mkQL8eiftj5bGMzB","8jPjKehCMsj7ncvxN","8peLXfWtCSic5n7oz","95eRgTcabnJwF46f3","9Ba9JxkjQBCeGBZKg","9DjgvzQrx27uxbyJj","9HD56d3k5yrB9H9oq","9RtPuXNyeS3k8LM9J","9diLYpd8cMmjBh54T","9nx6Yv3XREwJDyRms","AfJhKcg96muyPdu7S","BGvchZsjW7Wejj9Cz","BYwdHpGr6xT5vmE5C","Bah6LM7GXdXTy8GGA","BmH2ytt7sXwPHcrse","CqJYxtqe6qBbtd5yz","D4kEZ2JcWCoMvRPy7","DFWW7D6Y7X57n4cbM","DSorPqHDfrFiNM5Ew","DWXisKXaQArvre3QL","DwBm6isMpKSHHkhAd","E88raoktD8ANF92Yu","EAjLox7ycbofcCXce","F8rzFhY9yWA7pBX4j","G3iynDKjz9BHJbrdg","GJw6mQETXADSCZuuk","GWK5669HLqPyYMQ5J","GibAXjj4xXdFT8qWh","HzFZpgGcfabjAp9x6","KJ4eYziy6hanF9kr9","Kcyu7uncEFiYzYP2D","N4zzhqcywSzDDYsdh","NCDg3xE2mPcNAu7LX","NvgbTAz3hZ9SevZvd","QbcDS3wK43sRASvgu","S3b7Bb9wwfpByQgbo","SXJaeFCgBDJ5HAHtj","T5nL8TGrggoLAF8Dj","W9vT8YcCNFEcp9mWQ","WZ5CpBEFNsb2ivfah","XxviSwRxhwgNwsraH","Z2Zs662GpXqKBEAMc","ZKYFgjHGm7PE4Y2kv","a5qpGirN3B5BLKdMh","ahGA65oGDChNYp7Mb","bA7pGCMS9AB2RBo2p","bTQb3TcrbBShtqFPS","cYnqisf4wzBsM7MF5","cjHpaYiWD5eX7btH4","ckrbesqi3pWqfF2nP","dH8EsWHZtCFuQk5bq","dS5kvBMnk3LMQe56w","eXsFRMzE7WfbHbBL4","fmmsBu4m6ayKtuopf","hdXr3PD8cHNWyAdCe","hgZxckC87u2A57teF","juvCjffHJaPQf44im","keQBT2Apb9yaev8AH","myHdF8zARwW5uGmFs","nJLfaznnYgFqWQQrv","onghitNWSvN2FpCaN","osgPwDW2y5KDXRa2i","pAWFMDHu5dNixqPAq","pLvmgrCjMeDYJiJxB","q4azvWakEjp2TQM7S","qBee6Md9YwRKwkeW3","qQky2Csek4mroLn2P","tJz4YBCqAzZAzek5d","tLtjttw8dEqF6YQ4s","uQ6jCrPijzAmZyfXz","vGEaFNt7mm92Z7GXc","vRkMmE65HSFpCk6FW","vsEsf8FR3Fxb6z7fJ","x5ejzvDeXCc89Dukv","xEQyC5shxpYySSJJm","xhwDdvQ7MYxa6keXm","xkviMnkrGBneANvMr","y64rFMcyp7tDsBrJQ","yBYJWSShoKkMG8aPE","yQPghCwQv22kf6dFq","yd5sCxaEiu5vWizTq"],"dataSources":["Sed98LbBeGaXxenrM","8vn5MSGYWB4fAx9Z4"]}