<!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>
      <issn pub-type="ppub">1613-0073</issn>
    </journal-meta>
    <article-meta>
      <title-group>
        <article-title>Qualification Services Knowledge Graph: A Leap towards Enhanced Data Management</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Raed Awill</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Wajahat Ali Khan</string-name>
          <email>w.khan@derby.ac.uk</email>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Maqbool Hussain</string-name>
          <email>m.hussain@derby.ac.uk</email>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Sadiq Zada</string-name>
          <email>sadiq.zada@addqual.com</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Ben Anderson</string-name>
          <email>ben.anderson@addqual.com</email>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="editor">
          <string-name>Knowledge Graph, Data Heterogeneity, Relational Model, Aerospace Industry, Semantic Mapping</string-name>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>AddQual LTD</institution>
          ,
          <addr-line>Derby</addr-line>
          ,
          <country country="UK">UK</country>
        </aff>
        <aff id="aff1">
          <label>1</label>
          <institution>University of Derby</institution>
          ,
          <addr-line>Derby</addr-line>
          ,
          <country country="UK">UK</country>
        </aff>
      </contrib-group>
      <abstract>
        <p>In the field of aerospace product qualification services, AddQual's operation relies on the efective coordination of data from diverse sources. This is presently achieved through a relational model, which has displayed numerous limitations, including the lack of semantic enrichment, data heterogeneity, and horizontal data evolution. To overcome these challenges, we meticulously designed, developed, and implemented an Aerospace Qualification Services Knowledge Graph (AQS-KG), moving from the existing relational model of AddQual. During this transition, we devised OwlFly, an in-house tool specifically designed to facilitate the mapping between the two models. This solution adeptly manages complex aerospace data, precisely aligning with AddQual's strategic objectives, which include a plan to increase from 1000 scanned parts with AQS-KG in 2022 to 20000 parts by 2026, a substantial reduction in carbon emissions, and introducing automation in the repair procedures. This research paves the way for forthcoming innovations, driving AddQual's transition to adapt a digital twin framework.</p>
      </abstract>
      <kwd-group>
        <kwd>Management</kwd>
      </kwd-group>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>-</title>
      <p>CEUR
ceur-ws.org</p>
    </sec>
    <sec id="sec-2">
      <title>1. Introduction</title>
      <p>
        AddQual receives shipments of various jet engine parts from diferent clients for feature
measurement and reporting. The clients had numerous engine sets of blades that had sufered
significant wear. Consequently, they require further information to assess dimensional criteria
and understand defects. They seek insights on causes and solutions for comprehensive part
analysis. To respond to their needs, the aim is to identify repairable parts based on the gathered
data. AddQual serves diverse clients globally, resulting in varying data representations.
Heterogeneity arises as clients use diferent terms; e.g., ’Bucket’ or ’NGV’ for a nozzle vane blade and
’airfoil’ for an aerofoil in America. The current approach of detailed inspection plans within the
relational model leads to conflicts in data storage. Its lack of semantic enrichment and trouble
handling data heterogeneity, especially with diverse component features, necessitate frequent
schema updates and horizontal database expansion. The designed AQS-KG outperforms the
limitations of the relational model [
        <xref ref-type="bibr" rid="ref1">1</xref>
        ] by streamlining data integration and accommodating diverse
formats. Its flexible, self-evolving design promotes horizontal development and interoperability.
SemREC’23: THE 22ND INTERNATIONAL SEMANTIC WEB CONFERENCE, City of Athens, Greece
nEvelop-O
CEUR
Workshop
Proceedings
      </p>
    </sec>
    <sec id="sec-3">
      <title>2. Methods</title>
      <p>Our application of AQS-KG followed an iterative, four-phase process, designed for continuous
refinement of the graph. The process incorporated Data Acquisition (DA), Knowledge
modeling and Representation (KMR), Data Persistence (DP), and Data Visualization (DV), with an
emphasis on graph validation across the KMR phase. Throughout the DA phase, we prepared
the company’s data by examining the existing model and collaborating with individuals across
various departments. This stage involved defining the project’s scope and identifying data
sources. In the KMR phase, we created a robust, semantically organized AQS-KG. Concurrently,
we developed OwlFly in Java and Apache Jena, which creates a KG model and uploads instances
from any data source. It establishes a connection with databases, e.g., PostgreSQL, and extracts
triples to form the AQS-KG model. The data extracted is used to define an intermediate data
model (IDM), map it to the triples, and load individuals into RDF, enabling precise and eficient
integration of data into the graph structure. To enhance the capabilities of AddQual, we utilized
a graph database during the DP and DV phases. This not only secured the data storage but also
granted us the capacity to visualize it in graphs. Such a strategic approach equipped AddQual to
generate insightful reports about their data, such as pinpointing parts susceptible to significant
defects.</p>
    </sec>
    <sec id="sec-4">
      <title>3. Results and Conclusion</title>
      <p>Since the inception of AQS-KG at AddQual, we’ve noticed a cut in the time needed to execute
complex queries by an impressive 35%, enhancing the data querying process. This eficiency
increase is crucial as we plan to increase the number of processed parts from 1,000 in 2022 to
20,000 by 2026. It becomes even more significant when considering the rich semantics of the
34 entities and the 31 relationships we have established within the graph, in contrast to the 12
relations and 5000 tuples present in the previous relational model. Notably, we identified 100
features with difering names but identical meanings. To address this data heterogeneity, rather
than using disparate fields in the relational model, we employed the graph’s semantic labeling
to unify similar entities and individuals. When considering future integration with machine
learning and artificial intelligence techniques, we anticipate an additional 20% increase in the
accuracy of our predictive capabilities. This could potentially lead to a reduction in downtime
and unnecessary expenditure. Furthermore, the current yield for complex component repair
parts stands at approximately 50%. We anticipate that integrating the knowledge graph with
our robotics systems could potentially increase this yield to 70-75% and concurrently achieve a
20% reduction in associated costs. Additionally, we foresee that integration of the graph model
will improve AddQual’s digital twin repair approach, leading to the maximization of operating
performance and reducing fuel consumption by 0.5%.</p>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          [1]
          <string-name>
            <given-names>S.</given-names>
            <surname>Batra</surname>
          </string-name>
          ,
          <string-name>
            <given-names>C.</given-names>
            <surname>Tyagi</surname>
          </string-name>
          ,
          <article-title>Comparative analysis of relational and graph databases</article-title>
          ,
          <source>International Journal of Soft Computing and Engineering (IJSCE) 2</source>
          (
          <year>2012</year>
          )
          <fpage>509</fpage>
          -
          <lpage>512</lpage>
          .
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>