Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks
International audience Object-Relational Mapping (ORM) frameworks are the cornerstone of online services. To reply to incoming requests, these services often rely on these frameworks as a convenient data access layer. However, such frameworks might also be the source of performance inefficiency when...
Main Authors: | , , |
---|---|
Other Authors: | , , , , , , , , |
Format: | Conference Object |
Language: | English |
Published: |
HAL CCSD
2024
|
Subjects: | |
Online Access: | https://inria.hal.science/hal-04401643 https://inria.hal.science/hal-04401643/document https://inria.hal.science/hal-04401643/file/SANER_24-2.pdf |
id |
ftunivlille:oai:HAL:hal-04401643v1 |
---|---|
record_format |
openpolar |
spelling |
ftunivlille:oai:HAL:hal-04401643v1 2024-06-23T07:56:27+00:00 Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks Bonvoisin, Alexandre Quinton, Clément Rouvoy, Romain Self-adaptation for distributed services and large software systems (SPIRALS) Inria Lille - Nord Europe Institut National de Recherche en Informatique et en Automatique (Inria)-Institut National de Recherche en Informatique et en Automatique (Inria)-Centre de Recherche en Informatique, Signal et Automatique de Lille - UMR 9189 (CRIStAL) Centrale Lille-Université de Lille-Centre National de la Recherche Scientifique (CNRS)-Centrale Lille-Université de Lille-Centre National de la Recherche Scientifique (CNRS) Ipek Ozkaya Fabio Palomba ANR-21-CE25-0022,DISTILLER,Service de recommandation pour des logiciels en ligne plus durables(2021) ANR-19-CE25-0003,Koala,Configurations d'environnements fog large-échelle(2019) ANR-23-PECL-0003,CARECloud,Comprendre, Améliorer, Réduire les impacts Environnementaux du Cloud computing(2023) Rovaniemi, Finland 2024-03-12 https://inria.hal.science/hal-04401643 https://inria.hal.science/hal-04401643/document https://inria.hal.science/hal-04401643/file/SANER_24-2.pdf en eng HAL CCSD IEEE hal-04401643 https://inria.hal.science/hal-04401643 https://inria.hal.science/hal-04401643/document https://inria.hal.science/hal-04401643/file/SANER_24-2.pdf http://creativecommons.org/licenses/by/ info:eu-repo/semantics/OpenAccess SANER'24 - 31th IEEE International Conference on Software Analysis, Evolution and Reengineering https://inria.hal.science/hal-04401643 SANER'24 - 31th IEEE International Conference on Software Analysis, Evolution and Reengineering, Mar 2024, Rovaniemi, Finland. pp.11 https://conf.researchr.org/home/saner-2024 ORM Frameworks Energy consumption Performance [INFO]Computer Science [cs] info:eu-repo/semantics/conferenceObject Conference papers 2024 ftunivlille 2024-06-03T14:41:18Z International audience Object-Relational Mapping (ORM) frameworks are the cornerstone of online services. To reply to incoming requests, these services often rely on these frameworks as a convenient data access layer. However, such frameworks might also be the source of performance inefficiency when configured and used inappropriately. This paper, therefore, compares different configurations of state-of-the-art Java-based ORM frameworks to unveil their performance efficiency, traditionally evaluated through metrics such as execution time and memory usage. However, rising environmental concerns have brought energy consumption to the forefront of the conversation. Beyond performance-centric measurements, we shed light on the energy consumption of these building blocks and explore the trade-offs that conceal the expected quality of service and environmental concerns. Our empirical results, obtained with an ORM-based version of the reference Transaction Processing Performance Council benchmark C (TPC-C) benchmark, highlight that the adoption of an ORM should be carefully configured by developers to leverage the resources offered by underlying databases. Conference Object Rovaniemi LillOA (HAL Lille Open Archive, Université de Lille) Rovaniemi ENVELOPE(26.159,26.159,66.392,66.392) |
institution |
Open Polar |
collection |
LillOA (HAL Lille Open Archive, Université de Lille) |
op_collection_id |
ftunivlille |
language |
English |
topic |
ORM Frameworks Energy consumption Performance [INFO]Computer Science [cs] |
spellingShingle |
ORM Frameworks Energy consumption Performance [INFO]Computer Science [cs] Bonvoisin, Alexandre Quinton, Clément Rouvoy, Romain Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks |
topic_facet |
ORM Frameworks Energy consumption Performance [INFO]Computer Science [cs] |
description |
International audience Object-Relational Mapping (ORM) frameworks are the cornerstone of online services. To reply to incoming requests, these services often rely on these frameworks as a convenient data access layer. However, such frameworks might also be the source of performance inefficiency when configured and used inappropriately. This paper, therefore, compares different configurations of state-of-the-art Java-based ORM frameworks to unveil their performance efficiency, traditionally evaluated through metrics such as execution time and memory usage. However, rising environmental concerns have brought energy consumption to the forefront of the conversation. Beyond performance-centric measurements, we shed light on the energy consumption of these building blocks and explore the trade-offs that conceal the expected quality of service and environmental concerns. Our empirical results, obtained with an ORM-based version of the reference Transaction Processing Performance Council benchmark C (TPC-C) benchmark, highlight that the adoption of an ORM should be carefully configured by developers to leverage the resources offered by underlying databases. |
author2 |
Self-adaptation for distributed services and large software systems (SPIRALS) Inria Lille - Nord Europe Institut National de Recherche en Informatique et en Automatique (Inria)-Institut National de Recherche en Informatique et en Automatique (Inria)-Centre de Recherche en Informatique, Signal et Automatique de Lille - UMR 9189 (CRIStAL) Centrale Lille-Université de Lille-Centre National de la Recherche Scientifique (CNRS)-Centrale Lille-Université de Lille-Centre National de la Recherche Scientifique (CNRS) Ipek Ozkaya Fabio Palomba ANR-21-CE25-0022,DISTILLER,Service de recommandation pour des logiciels en ligne plus durables(2021) ANR-19-CE25-0003,Koala,Configurations d'environnements fog large-échelle(2019) ANR-23-PECL-0003,CARECloud,Comprendre, Améliorer, Réduire les impacts Environnementaux du Cloud computing(2023) |
format |
Conference Object |
author |
Bonvoisin, Alexandre Quinton, Clément Rouvoy, Romain |
author_facet |
Bonvoisin, Alexandre Quinton, Clément Rouvoy, Romain |
author_sort |
Bonvoisin, Alexandre |
title |
Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks |
title_short |
Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks |
title_full |
Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks |
title_fullStr |
Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks |
title_full_unstemmed |
Understanding the Performance-Energy Tradeoffs of Object-Relational Mapping Frameworks |
title_sort |
understanding the performance-energy tradeoffs of object-relational mapping frameworks |
publisher |
HAL CCSD |
publishDate |
2024 |
url |
https://inria.hal.science/hal-04401643 https://inria.hal.science/hal-04401643/document https://inria.hal.science/hal-04401643/file/SANER_24-2.pdf |
op_coverage |
Rovaniemi, Finland |
long_lat |
ENVELOPE(26.159,26.159,66.392,66.392) |
geographic |
Rovaniemi |
geographic_facet |
Rovaniemi |
genre |
Rovaniemi |
genre_facet |
Rovaniemi |
op_source |
SANER'24 - 31th IEEE International Conference on Software Analysis, Evolution and Reengineering https://inria.hal.science/hal-04401643 SANER'24 - 31th IEEE International Conference on Software Analysis, Evolution and Reengineering, Mar 2024, Rovaniemi, Finland. pp.11 https://conf.researchr.org/home/saner-2024 |
op_relation |
hal-04401643 https://inria.hal.science/hal-04401643 https://inria.hal.science/hal-04401643/document https://inria.hal.science/hal-04401643/file/SANER_24-2.pdf |
op_rights |
http://creativecommons.org/licenses/by/ info:eu-repo/semantics/OpenAccess |
_version_ |
1802649546947297280 |