Saved in:
Bibliographic Details
Main Author: Stormacq, Florian
Format: Recurso digital
Language:English
Published: Zenodo 2026
Online Access:https://doi.org/10.5281/zenodo.19385754
Tags: Add Tag
No Tags, Be the first to tag this record!
Table of Contents:
  • <p>This dataset contains energy consumption measurements collected using <a href="https://github.com/fstormacq/energyTracer">EnergyTracer</a>. It compares the execution of a Python script containing a specific code smell (SQL query without <code>LIMIT</code>) against a refactored version with a <code>LIMIT</code> clause.</p> <h3>Research Question</h3> <p>How significant is the energy consumption difference between a SQL query executed without any limit and the same query executed with a <code>LIMIT</code> clause, in Python?</p> <h3>Measurement</h3> <p>Tool: EnergyTracer. Statistical analysis: Welch's t-test (α = 0.05) and Cohen's d effect size.</p> <h3>Instances</h3> <table> <tbody> <tr> <th>Instance</th> <th>Hardware</th> <th>OS</th> <th>Architecture</th> </tr> <tr> <td>Apple Mac Mini</td> <td>Apple M4</td> <td>Darwin 25.3.0</td> <td>arm64</td> </tr> <tr> <td>aws-c8a.large</td> <td>AMD EPYC 9R45</td> <td>Amazon Linux 2023</td> <td>x86_64</td> </tr> <tr> <td>aws-m7a.large</td> <td>AMD EPYC 9R14</td> <td>Amazon Linux 2023</td> <td>x86_64</td> </tr> <tr> <td>aws-r8a.large</td> <td>AMD EPYC 9R45</td> <td>Amazon Linux 2023</td> <td>x86_64</td> </tr> </tbody> </table> <p>Full reproduction instructions are available in the <a href="https://github.com/fstormacq/energyTracer">EnergyTracer repository</a>. The <code>README.md</code> included in this dataset details the file structure and column dictionary.</p>