Saved in:
| Main Author: | |
|---|---|
| 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!
|
| _version_ | 1866901522614321152 |
|---|---|
| author | Stormacq, Florian |
| author_facet | Stormacq, Florian |
| 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> |
| format | Recurso digital |
| id | zenodo_https___doi_org_10_5281_zenodo_19385754 |
| institution | Zenodo |
| language | eng |
| publishDate | 2026 |
| publisher | Zenodo |
| record_format | zenodo |
| spellingShingle | Energy Consumption of SQL Queries with and without LIMIT clause in Python Stormacq, Florian <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> |
| title | Energy Consumption of SQL Queries with and without LIMIT clause in Python |
| url | https://doi.org/10.5281/zenodo.19385754 |