Examples for SCER Reference Applications and Technical Integration & Visualisation

[ArneTR]

First Issue, yaay! 🥳

Disclaimer: I could not open a discussion, since this feature is not active atm. If you want to enable discussions for this repo I am happy to post there again, or you can also migrate the issue.

Following a dicussion with (@Henry-WattTime) on LinkedIn I wanted to propose some already existing benchmarks for applications and if they can be used for the SCER and also showcase a possible technical integration and if this is useful for this GSF project.

Example applications

Since the SCER is a rating concept for applications that shall allow for comparability it needs a standard test that it must execute so that applications become comparable.

In Green-Software-Foundation/projects#44 this idea was already outlined and Henry (@Henry-WattTime) mentioned TPC-C Benchmarks.

Since we are currently also looking for such standard benchmarks I pinged Henry on LinkedIn with other examples. He encouraged me to open a discussion here.

Other than TPC-C we have identified these interesting projects:

• Web Frameworks: https://github.com/TechEmpower/FrameworkBenchmarks
  Example data here: https://www.techempower.com/benchmarks/#section=data-r21

• Browsers: https://browserbench.org/Speedometer2.0/

Technical integrations and visualisations

We are part of the Blauer Engel Working group mentioned in Green-Software-Foundation/projects#44 and have since been working on creating an automation around these so called usage scenarios.

We have also identified TPC-C as a valuable candidated and integrated this with Hammer-DB in a test scenario with our Green Metrics Tool that can generate an SCI metric.

The tooling can also monitor this value over time (and thus release versions of the DB products) and show the changes in energy, CO2 and SCI.

Also we tried to integrate this into something like a "score card" which will show this value in a clean and digestable form as a snapshot. Link to the open source Energy ID project

Is that something that can be re-used by the GSF or is maybe helpful for this project?

Example for a TCP-C DB scorecard.