<!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Archiving and Interchange DTD v1.0 20120330//EN" "JATS-archivearticle1.dtd">
<article xmlns:xlink="http://www.w3.org/1999/xlink">
  <front>
    <journal-meta />
    <article-meta>
      <title-group>
        <article-title>PCFWebUI: Data-driven WebUI for holistic decarbonization based on PCF-Tracking⋆</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Ajay Kumar</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Marius Naumann</string-name>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Kevin Henne</string-name>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Mohamed Ahmed Sherif</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>Paderborn University, Data Science Group</institution>
          ,
          <addr-line>Pohlweg 51, D-33098 Paderborn</addr-line>
          ,
          <country country="DE">Germany</country>
        </aff>
        <aff id="aff1">
          <label>1</label>
          <institution>Paderborn University, Department of Energy System Technologies</institution>
          ,
          <addr-line>Warburger Straße 100, D-33098 Paderborn</addr-line>
          ,
          <country country="DE">Germany</country>
        </aff>
      </contrib-group>
      <abstract>
        <p>The pursuit of corporate greenhoue gas neutrality has become increasingly critical due to heightened sustainability expectations, rising energy and CO2e costs, and stricter regulatory requirements. Key drivers, such as the mandated reduction of greenhouse gas emissions by 65% by 2030 compared to 1990 levels and the goal of achieving climate neutrality by 2045, necessitate immediate action toward decarbonization. In this paper, we introduce PcfWebUI, a data-driven tool developed to support companies in their decarbonization journey. PcfWebUI is built on real company data integrated into a knowledge graph, enabling eficient tracking and management of product carbon footprints (PCF), facilitating strategic planning and accurate monitoring to help companies meet stringent climate targets and progress toward climate neutrality. A demo of our system is publicly available at https://climatebowl.demo.dice-research.org/.</p>
      </abstract>
      <kwd-group>
        <kwd>eol&gt;Knowledge Graphs</kwd>
        <kwd>PCF Tracking</kwd>
        <kwd>Energy Eficiency</kwd>
      </kwd-group>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>1. Introduction</title>
      <p>value network. This transparency is starting point for the development of decarbonization
measures.</p>
      <p>
        In this paper, we present PcfWebUI1 Based on real companies’ data integrated into knowledge
graph (KG), PcfWebUI enables eficient tracking and management of the Product Carbon
Footprints (PCF), helping companies to identify potentials to reduce GHG emission as well
as derive and assess specific measures. The system’s data-driven approach ensures accurate
monitoring and strategic planning, supporting companies in meeting stringent climate targets
and advancing toward GHG neutrality. PcfWebUI aims to simplify the process of identifying
and implementing energy eficiency (EE) measures. This is the focus of our collaborative project
Climate bOWL2.
2. PCF-Tracking in context of industrial decarbonization
The holistic decarbonization of corporate activities can be divided into the three phases: target
definition , carbon accounting and action planning [
        <xref ref-type="bibr" rid="ref2">2</xref>
        ]. Defining reduction targets and translating
them into a reduction pathway is the foundation of any decarbonisation strategy. It is necessary
to create transparency about the company’s product-specific greenhouse gas emissions through
carbon accounting. The general methodical procedure is defined in the Greenhouse Gas Protocol
(GHGP) or standard DIN EN ISO 14064, the product-specific accounting is specified in standard
DIN EN ISO 14067 [
        <xref ref-type="bibr" rid="ref3">3</xref>
        ]. The accounting of all input and output flows for the relevant process
modules of a product is recorded in a life cycle inventory and then subjected to an impact
assessment in order to quantify the GHG potential measured in GHG equivalents [
        <xref ref-type="bibr" rid="ref4">4</xref>
        ]. By analyzing the
PCF, it becomes clear which process modules in the life cycle inventory have the greatest GHG
potential. The aggregation of process modules according to criteria such as scope categories or
life cycle phases makes it possible to evaluate the influence of individual or aggregated process
modules on the overall PCF. This analysis is important because it defines the starting point for
the development of decarbonization measures by identifying the emission-intensive process
modules. In the third phase of action planning, measures for GHG reduction are derived for the
identified drivers of the PCF. In principle, decarbonization eforts can be strategically
implemented following the principles of avoidance, reduction, replacing and ofsetting [
        <xref ref-type="bibr" rid="ref5">5</xref>
        ]. There is
a need to automate the individual steps of PCF tracking and the development of measures in
order to ensure a holistic approach and accelerate industrial decarbonization [
        <xref ref-type="bibr" rid="ref2">2</xref>
        ]. The Climate
bOWL research project is therefore investigating the development of a digital support system
that automates the PCF accounting and analysis as well as the derivation of reduction measures
based on the methodological framework described.
3. Climate bOWL Knowledge Graph
The foundation of PcfWebUI’s robust functionality lies in its use of real companies’ data from
the Climate bOWL project, integrated into knowledge graph (KG). For generating our KG, we
1Demo: https://climatebowl.demo.dice-research.org. Please be aware that for data protection purposes, our public
demo exclusively utilizes synthetic data. This ensures that no real company data is used or exposed.
2https://dice-research.org/ClimatebOWL
      </p>
      <sec id="sec-1-1">
        <title>Product</title>
        <p>:
h
a
s
P
r
o
c
e
s
s</p>
      </sec>
      <sec id="sec-1-2">
        <title>Process :hasDocumentation</title>
      </sec>
      <sec id="sec-1-3">
        <title>Documentation</title>
        <p>:
h
a
s
A
ll
o
c
a
it
o
n
:hasDatavalidation
:
h
a
s
R
:hasAnotherTimesampReferenceFlow f
e
e
r
e
n
c
e
F
l
o
w
:
h
a
s
littyauaaADQ tt:suapuhO It:spanuh
s
s
e
s
s
m
e
n
t
:
h
a
s
C
a
t
e
g
o
r
y
:hasEmissionsfactor</p>
      </sec>
      <sec id="sec-1-4">
        <title>Material</title>
        <p>:
h
a
s
C
a
t
e
g
o
r
y</p>
      </sec>
      <sec id="sec-1-5">
        <title>Flow</title>
        <p>:
h
a
s
E
m
i
s
s
i
o
n
s
f
a
c
tr
o</p>
      </sec>
      <sec id="sec-1-6">
        <title>Energy :hasCategory</title>
      </sec>
      <sec id="sec-1-7">
        <title>Company</title>
        <p>:hasProduct</p>
      </sec>
      <sec id="sec-1-8">
        <title>Transport</title>
        <p>:hasEmissionsfactor</p>
      </sec>
      <sec id="sec-1-9">
        <title>THGEmissions</title>
      </sec>
      <sec id="sec-1-10">
        <title>Allocation</title>
      </sec>
      <sec id="sec-1-11">
        <title>DataValidation</title>
      </sec>
      <sec id="sec-1-12">
        <title>ReferenceFlow</title>
      </sec>
      <sec id="sec-1-13">
        <title>DataQualityAssessment</title>
        <p>deployed Python scripts to convert data from Excel files into the KG triples. Our KG conversion
scripts are available from the project Github3. The resulted triples is then hosted using Apache
Jena4. To facilitate advanced querying, we also provided a SPARQL endpoint to our KG, allowing
users to perform complex queries and extract more specific information.</p>
        <p>The Climate Bowl Ontology (CLBO), see Figure 1, is designed to facilitate the aggregation,
evaluation, and prioritization of GHG emission reduction measures throughout the value chain
in industrial settings. CLBO defines key concepts and their relationships relevant to industrial
GHG emission reduction. Key entities include companies, products, processes, flows, and
documentation standards. Properties describe the relationships between these entities, enabling
a structured approach to tracking and analyzing GHG emissions and identifying potential
reduction measures. For more details see the climatebowl ontology online resource5.</p>
      </sec>
    </sec>
    <sec id="sec-2">
      <title>4. PcfWebUI</title>
      <p>We introduce PcfWebUI, a data-driven tool developed to support companies in their
decarbonization journey. The system emphasizes improving material and energy eficiency as the
ifrst step, followed by substituting energy sources and compensating for residual emissions.
PcfWebUI enables eficient tracking and management of PCF facilitating strategic planning
and accurate monitoring to help companies meet stringent climate targets and progress toward
climate neutrality. The key components of PcfWebUI are:
1. Query Component. The query component is designed to allow users to eficiently search
and retrieve specific information related to their PCF data. This component includes a
3https://github.com/dice-group/ClimateBowl-KGConverter
4https://jena.apache.org/
5http://w3id.org/dice-research/climatebowl/ontology
ifeld for SPARQL queries that utilizes our integrated KG to get detailed data for a product.
We built the query component using React6 for the front-end and Apache-Jena for the
back-end. The query component provides instantaneous feedback, displaying results as
users refine their queries.
2. PCF Tracking Component. The PCF tracking component enables users to monitor and
manage PCF comprehensively. This component presents a table with diferent parameters
for a single product, where the data for this table comes from the KG using the SPARQL
query in the query component. As shown in Figure 2, the Flow column ("fluss" in
German), there is a drop-down feature that allows users to choose for diferent materials
or energy sources. The Flow column includes a searchable drop-down that retrieves data
from our KG, allowing users to find materials or energy sources quickly. This component
dynamically reflects changes in emission factors in real-time, indicated by a green arrow
if emissions decrease and a red arrow if emissions increase.
3. Analytics Component. The analytics component of PcfWebUI responsible for analyzing
PCF data and generating insights. This component uses the updated data from the PCF
Tracking table, including all user updates, to display various analytical graphs. One of
the key graphs is the life cycle phases graph, where emission data is divided into diferent
life-cycle phases of the product and compares old and new emissions (See an example in
the lower part of Figure 2). Another important chart is the scope graph that shows data
grouped by scopes, providing a view of emissions according to diferent scope categories.
5. Conclusions and Future Work
Corporate climate neutrality is imperative due to strict regulations, rising energy and CO2e costs,
and increased sustainability expectations. PcfWebUI is a pivotal tool, enabling eficient tracking
and management of product carbon footprints with a data-driven approach. By integrating real
company data into a KG, PcfWebUI enhances material and energy eficiency, energy source
substitution, and residual emissions compensation. Despite challenges in data availability, secure
exchange, and PCF tracking complexity, PcfWebUI ofers a robust foundation for companies to
meet decarbonization targets and achieve GHG neutrality.</p>
      <p>
        In future work, we will enhance PcfWebUI by developing advanced features for EE
benchmarking, measure derivation, and prioritization to guide companies in decarbonization. We
will also integrate a recommendation system for energy reduction and decarbonization based
on PCF and energy eficiency benchmarking data. Finally, We will integrate our novel SPARQL
query generation approach into PcfWebUI for a more user-friendly experience [
        <xref ref-type="bibr" rid="ref6">6</xref>
        ].
Acknowledgments. This work has been supported by the Ministry for Economic Afairs,
Innovation, Digitalisation and Energy of North Rhine-Westphalia (MWIDE NRW) within the
project Climate bOWL under the grant no 005-2111-0020, and by the German Research
Foundation (DFG) within the project INGRID under the grant no NG 105/7-3. This work has been
supported within the project "WHALE" (LFN 1-04) funded under the Lamarr Fellow Network
programme by the Ministry of Culture and Science of North Rhine-Westphalia (MKW NRW).
      </p>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          [1]
          <string-name>
            <given-names>European</given-names>
            <surname>Commission</surname>
          </string-name>
          , European climate law,
          <year>2021</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref2">
        <mixed-citation>
          [2]
          <string-name>
            <given-names>M.</given-names>
            <surname>Naumann</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M.</given-names>
            <surname>Ostermann</surname>
          </string-name>
          ,
          <string-name>
            <given-names>N.</given-names>
            <surname>Buchenau</surname>
          </string-name>
          ,
          <string-name>
            <given-names>J.</given-names>
            <surname>Oetzel</surname>
          </string-name>
          ,
          <string-name>
            <given-names>F.</given-names>
            <surname>Schlosser</surname>
          </string-name>
          ,
          <string-name>
            <given-names>H.</given-names>
            <surname>Meschede</surname>
          </string-name>
          , T. Tröster,
          <article-title>Energy eficiency improvement in manufacturing industry: A review based on a framework for holistic decarbonization (not published), submitted in Renewable and Sustainable Energy Reviews (</article-title>
          <year>2024</year>
          ).
        </mixed-citation>
      </ref>
      <ref id="ref3">
        <mixed-citation>
          [3]
          <string-name>
            <given-names>R.-H.</given-names>
            <surname>Hechelmann</surname>
          </string-name>
          ,
          <string-name>
            <surname>A</surname>
          </string-name>
          . Paris,
          <string-name>
            <given-names>N.</given-names>
            <surname>Buchenau</surname>
          </string-name>
          ,
          <string-name>
            <given-names>F.</given-names>
            <surname>Ebersold</surname>
          </string-name>
          ,
          <article-title>Decarbonisation strategies for manufacturing: A technical and economic comparison</article-title>
          ,
          <source>Renewable and Sustainable Energy Reviews</source>
          <volume>188</volume>
          (
          <year>2023</year>
          )
          <article-title>113797</article-title>
          . doi:
          <volume>10</volume>
          .1016/j.rser.
          <year>2023</year>
          .
          <volume>113797</volume>
          .
        </mixed-citation>
      </ref>
      <ref id="ref4">
        <mixed-citation>
          [4]
          <string-name>
            <given-names>International</given-names>
            <surname>Organization</surname>
          </string-name>
          for Standardization,
          <article-title>Din en iso 14040: Environmental management - life cycle assessment: Principles and framework, 2009</article-title>
          . URL: https://www.iso.org/ standard/37456.html.
        </mixed-citation>
      </ref>
      <ref id="ref5">
        <mixed-citation>
          [5]
          <string-name>
            <given-names>M.</given-names>
            <surname>Finkbeiner</surname>
          </string-name>
          ,
          <string-name>
            <given-names>V.</given-names>
            <surname>Bach</surname>
          </string-name>
          ,
          <article-title>Life cycle assessment of decarbonization options-towards scientifically robust carbon neutrality</article-title>
          ,
          <source>The International Journal of Life Cycle Assessment</source>
          <volume>26</volume>
          (
          <year>2021</year>
          )
          <fpage>635</fpage>
          -
          <lpage>639</lpage>
          . doi:
          <volume>10</volume>
          .1007/s11367-021-01902-4.
        </mixed-citation>
      </ref>
      <ref id="ref6">
        <mixed-citation>
          [6]
          <string-name>
            <given-names>H. M.</given-names>
            <surname>Zahera</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M.</given-names>
            <surname>Ali</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M. A.</given-names>
            <surname>Sherif</surname>
          </string-name>
          ,
          <string-name>
            <given-names>D.</given-names>
            <surname>Moussallem</surname>
          </string-name>
          , A.
          <string-name>
            <surname>-C. Ngonga Ngomo</surname>
          </string-name>
          ,
          <article-title>Generating sparql from natural language using chain-of-thoughts prompting</article-title>
          , in: SEMANTiCS,
          <year>2024</year>
          .
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>