A Study of the Energy Consumption of Databases and Cloud Patterns

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 14th 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�chir Bani and Foutse Khomh and Yann-Ga�l Gu�h�neuc},
   BOOKTITLE    = {Proceedings of the 14<sup>th</sup> International Conference on Service Oriented Computing (ICSOC)},
   TITLE        = {A Study of the Energy Consumption of Databases and Cloud 
      Patterns},
   YEAR         = {2016},
   OPTADDRESS   = {},
   OPTCROSSREF  = {},
   EDITOR       = {Michael Sheng and Eleni Stroulia and Samir Tata},
   MONTH        = {October},
   NOTE         = {Short paper. 8 pages.},
   OPTNUMBER    = {},
   OPTORGANIZATION = {},
   PAGES        = {606--614},
   PUBLISHER    = {Springer},
   OPTSERIES    = {},
   OPTVOLUME    = {},
   KEYWORDS     = {Topic: <b>Evolution patterns</b>, Venue: <c>ICSOC</c>},
   URL          = {http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf},
   PDF          = {http://www.ptidej.net/publications/documents/ICSOC16b.ppt.pdf},
   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.}
}

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/Publications/Biblio/complete-bibliography.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":[]}],"booktitle":"Proceedings of the 14th International Conference on Service Oriented Computing (ICSOC)","title":"A Study of the Energy Consumption of Databases and Cloud Patterns","year":"2016","optaddress":"","optcrossref":"","editor":[{"firstnames":["Michael"],"propositions":[],"lastnames":["Sheng"],"suffixes":[]},{"firstnames":["Eleni"],"propositions":[],"lastnames":["Stroulia"],"suffixes":[]},{"firstnames":["Samir"],"propositions":[],"lastnames":["Tata"],"suffixes":[]}],"month":"October","note":"Short paper. 8 pages.","optnumber":"","optorganization":"","pages":"606–614","publisher":"Springer","optseries":"","optvolume":"","keywords":"Topic: Evolution patterns, Venue: <c>ICSOC</c>","url":"http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf","pdf":"http://www.ptidej.net/publications/documents/ICSOC16b.ppt.pdf","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.","bibtex":"@INPROCEEDINGS{Bani16-ICSOC-CloudPatternEnergy,\r\n AUTHOR = {B�chir Bani and Foutse Khomh and Yann-Ga�l Gu�h�neuc},\r\n BOOKTITLE = {Proceedings of the 14th International Conference on Service Oriented Computing (ICSOC)},\r\n TITLE = {A Study of the Energy Consumption of Databases and Cloud \r\n Patterns},\r\n YEAR = {2016},\r\n OPTADDRESS = {},\r\n OPTCROSSREF = {},\r\n EDITOR = {Michael Sheng and Eleni Stroulia and Samir Tata},\r\n MONTH = {October},\r\n NOTE = {Short paper. 8 pages.},\r\n OPTNUMBER = {},\r\n OPTORGANIZATION = {},\r\n PAGES = {606--614},\r\n PUBLISHER = {Springer},\r\n OPTSERIES = {},\r\n OPTVOLUME = {},\r\n KEYWORDS = {Topic: Evolution patterns, Venue: <c>ICSOC</c>},\r\n URL = {http://www.ptidej.net/publications/documents/ICSOC16b.doc.pdf},\r\n PDF = {http://www.ptidej.net/publications/documents/ICSOC16b.ppt.pdf},\r\n ABSTRACT = {Nowadays databases have become the backbone of \r\n cloud-based applications. Cloud-based applications are used in about \r\n every industry today. Despite their popularity and wide adoption, \r\n little is still known about the energy footprint of these \r\n applications and, in particular, of their databases. Yet, reducing \r\n the energy consumption of applications is a major objective for \r\n society and will continue to be so in the near to far future. In this \r\n paper, we study the energy consumption of three databases used by \r\n cloud-based applications: MySQL, PostgreSQL, and MongoDB, through a \r\n series of experiments with three cloud-based applications (a RESTful \r\n multi-threaded application, DVD Store, and JPetStore). We also study \r\n the impact of cloud patterns on the energy consumption because \r\n databases in cloud-based applications are often implemented in \r\n conjunction with patterns. We measure the energy consumption using \r\n the Power-API tool to keep track of the energy consumed at the \r\n process-level by the variants of the cloud-based applications. We \r\n report that the choice of the databases can reduce the energy \r\n consumption of a cloud-based application regardless of the cloud \r\n patterns that are implemented.}\r\n}\r\n\r\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":["Topic: Evolution patterns","Venue: <c>ICSOC</c>"],"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":"http://www.yann-gael.gueheneuc.net/"}}},"search_terms":["study","energy","consumption","databases","cloud","patterns","bani","khomh","gu�h�neuc"],"keywords":["topic: evolution patterns","venue: <c>icsoc</c>"],"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"]}