<!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>Extraction of Object-Centric Event Logs through Virtual Knowledge Graphs</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Extended Abstract</string-name>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Jing Xiong</string-name>
          <email>jing.xiong@unibz.it</email>
          <xref ref-type="aff" rid="aff2">2</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Guohui Xiao</string-name>
          <email>guohui.xiao@uib.no</email>
          <xref ref-type="aff" rid="aff1">1</xref>
          <xref ref-type="aff" rid="aff3">3</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Tahir Emre Kalayci</string-name>
          <email>emre.kalayci@v2c2.at</email>
          <xref ref-type="aff" rid="aff4">4</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Marco Montali</string-name>
          <email>montali@inf.unibz.it</email>
          <xref ref-type="aff" rid="aff2">2</xref>
          <xref ref-type="aff" rid="aff3">3</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Zhenzhen Gu</string-name>
          <email>zhenzhen.gu@unibz.it</email>
          <xref ref-type="aff" rid="aff2">2</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Diego Calvanese</string-name>
          <email>calvanese@inf.unibz.it</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff2">2</xref>
          <xref ref-type="aff" rid="aff3">3</xref>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>Department of Computing Science, Umeå University</institution>
          ,
          <addr-line>901 87 Umeå</addr-line>
          ,
          <country country="SE">Sweden</country>
        </aff>
        <aff id="aff1">
          <label>1</label>
          <institution>Department of Information Science and Media Studies, University of Bergen</institution>
          ,
          <addr-line>5007 Bergen</addr-line>
          ,
          <country country="NO">Norway</country>
        </aff>
        <aff id="aff2">
          <label>2</label>
          <institution>KRDB Research Centre for Knowledge and Data, Free University of Bozen-Bolzano</institution>
          ,
          <addr-line>39100 Bolzano</addr-line>
          ,
          <country country="IT">Italy</country>
        </aff>
        <aff id="aff3">
          <label>3</label>
          <institution>Ontopic S.R.L.</institution>
          ,
          <addr-line>39100 Bolzano</addr-line>
          ,
          <country country="IT">Italy</country>
        </aff>
        <aff id="aff4">
          <label>4</label>
          <institution>Virtual Vehicle Research GmbH</institution>
          ,
          <addr-line>8010 Graz</addr-line>
          ,
          <country country="AT">Austria</country>
        </aff>
      </contrib-group>
      <abstract>
        <p>Process mining is a family of techniques that supports the analysis of operational processes based on event logs. Among the existing event log formats, the IEEE standard eXtensible Event Stream (XES) is the most widely adopted. In XES, each event must be related to a single case object, which may lead to convergence and divergence problems. To solve such issues, object-centric approaches become promising, where objects are the central notion, and one event may refer to multiple objects. In particular, the Object-Centric Event Logs (OCEL) standard has been proposed recently. However, the crucial problem of extracting OCEL logs from external sources is still largely unexplored. In this paper, we try to fill this gap by leveraging the Virtual Knowledge Graph (VKG) approach to access data in relational databases. We have implemented this approach in the OnProm system, extending it from XES to OCEL support. The full version of this article has been submitted to an international conference.</p>
      </abstract>
      <kwd-group>
        <kwd>eol&gt;Process mining</kwd>
        <kwd>object-centric event logs</kwd>
        <kwd>virtual knowledge graph</kwd>
        <kwd>ontology-based data access</kwd>
      </kwd-group>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>1. Introduction</title>
      <p>
        Process mining [
        <xref ref-type="bibr" rid="ref1 ref2">1, 2</xref>
        ] is a family of techniques relating the fields of data science and process
management to support the analysis of operational processes based on event logs. To perform
process mining, normally the algorithms and tools expect that the event logs are following
certain standards. However, in reality, most IT systems in companies and organizations do
not directly produce such logs, and the relevant information is spread in legacy systems, in
particular, relational databases. Hence, event log extraction from legacy systems is a key enabler
for process mining [
        <xref ref-type="bibr" rid="ref3 ref4 ref5 ref6">3, 4, 5, 6</xref>
        ].
      </p>
      <p>
        There have been several proposals for the representation of event logs, e.g., eXtensible Event
Stream (XES) [
        <xref ref-type="bibr" rid="ref7">7</xref>
        ], JSON Support for XES (JXES) [
        <xref ref-type="bibr" rid="ref8">8</xref>
        ], Open SQL Log Exchange (OpenSLEX) [
        <xref ref-type="bibr" rid="ref9">9</xref>
        ],
and eXtensible Object-Centric (XOC) [
        <xref ref-type="bibr" rid="ref10">10</xref>
        ], where XES is the most adopted one, being the IEEE
standard for interoperability in event logs [
        <xref ref-type="bibr" rid="ref11">11</xref>
        ]. In XES (and other similar proposals), each event
is related to a single case object, which leads to problems with convergence (when an event is
related to multiple cases and occurs repetitively) and divergence (when multiple events are in
a single case and are hard to separate) [
        <xref ref-type="bibr" rid="ref12">12</xref>
        ]. To solve these issues, object-centric approaches
become promising, where objects are the central notion, and one event may refer to multiple
objects. In particular, along this direction, the Object-Centric Event Logs (OCEL) standard [
        <xref ref-type="bibr" rid="ref13">13</xref>
        ]
has been proposed recently.
      </p>
      <p>To the best of our knowledge, the crucial problem of extracting OCEL logs from external
sources is still largely unexplored. The only exception is [14], where OCEL logs are extracted by
identifying the so-called master and relevant tables in the underlying database and building a
Graph of Relations (GoR). Though promising, this approach might be dificult to adopt when the
underlying tables are complex and the GoR is hard to model, because it does not separate the
storage level (i.e., the database) from the concept level (i.e., domain knowledge about events).</p>
      <p>
        In this work, we try to lfil this gap by leveraging the OnProm (http://onprom.inf.unibz.it/)
framework [
        <xref ref-type="bibr" rid="ref4 ref5">4, 5</xref>
        ] for extracting event logs from legacy information systems. OnProm v1 was already
relying on the technology of Virtual Knowledge Graphs (VKG) [15] to expose databases as
Knowledge Graphs that conform to a conceptual model, and to query this conceptual model
and eventually generate logs by using ontology and mapping-based query processing. It came
with a toolchain to process the conceptual model, and to automatically extract XES event logs,
by relying on the VKG system Ontop [16]. We present here OnProm v2, which we have
modularized so that it becomes easier to extend, and in which we have implemented OCEL-specific
features to extract OCEL logs.
2. The OnProm Framework for Event Log Extraction
We describe now the OnProm approach for event log extraction, as shown in Figure 1. To
extract from a legacy information system ℐ = ⟨ℛ, ⟩, with relational schema ℛ and database ,
event logs that conform to an event log standard , OnProm works as follows:
(1) A domain ontology is a high-level abstraction of business logic concerned in a domain of
interest. The user can design a domain ontology  using the standard ontology language
OWL 2 QL using any ontology editing tool, e.g., the Ontology Editor of the OnProm tool chain.
Then the user creates a VKG mapping ℳ (using, e.g., the Ontop plugin for Protégé [17]) to
declare how the instances of classes and properties in  are populated from ℐ. This step
is only concerned with modeling the domain of interest and is agnostic to the event log
standard.
(2) OnProm assumes that for the event log standard , a specific (domain-independent) event
ontology ℰ is available. The Annotation Editor of OnProm imports ℰ , and allows the
user to create annotations ℒ , which are based on the classes in ℰ , over the classes in  .
(3) OnProm assumes that for the standard  also a set of SPARQL queries for extracting the
log information is defined. By relying on a conceptual schema transformation approach [
        <xref ref-type="bibr" rid="ref6">6</xref>
        ]
XES event ontology ℰXES
refers to
      </p>
      <p>XES annotation ℒXES</p>
      <p>VKGDomain ontology</p>
      <p>OCEL annotation
ℒOCEL</p>
      <p>OCEL event ontology ℰOCEL
refers to
XES log mapping specification</p>
      <p>OCEL log mapping specification
Mapping specification ℳ
Information system ℐ</p>
      <p>DB schema ℛ</p>
      <p>RDB 
and query reformulation of Ontop, using ℒ ,  , ℳ, and ℛ, these SPARQL queries are
internally translated to SQL queries over ℐ. OnProm evaluates the generated SQL queries
to construct corresponding Java objects and serialize them into log files compliant with .
As mentioned, OnProm v1 only supported the XES standard. In this work, we have first
modularized the system, by separating the above steps in diferent software components, so
as to make it more extensible. Then we have introduced OCEL-specific features in Steps (2)
and (3). Hence, OnProm v2 is now able to extract OCEL logs from relational databases.</p>
      <p>Next we illustrate the functionality of OnProm for extracting OCEL logs through an example.
The OCEL event ontology ℰOCEL is a very simple ontology with only three classes: Object,
Event, and Attribute. We consider Dolibarr [18] v14, a popular open source Enterprise Resource
Planning (ERP) system. We have designed a Sale Orders domain ontology and the mapping in
the Ontop system (Figure 2). We have then used the Annotation Editor of OnProm to annotate
this ontology with ℰOCEL classes (Figure 3). Based on the provided information, OnProm is able
to extract OCEL logs automatically. Figure 4 shows a fragment of the extracted log in XML, and
its graphical visualization.</p>
    </sec>
    <sec id="sec-2">
      <title>Acknowledgments</title>
      <p>This research has been supported by the Wallenberg AI, Autonomous Systems and Software
Program (WASP) funded by the Knut and Alice Wallenberg Foundation, by the Italian PRIN
project HOPE, and by the EU H2020 project INODE, grant n. 863410.
centric event logs, in: ADBIS 2021 Short Papers, Doctoral Consortium and Workshops:
DOING, SIMPDA, MADEISD, MegaData, CAoNS, volume 1450 of Communications in
Computer and Information Science, Springer, 2021, pp. 169–175.
[14] A. Berti, G. Park, M. Rafiei, W. van der Aalst, An Event Data Extraction Approach from
SAP ERP for Process Mining, CoRR Technical Report arXiv:2110.03467, arXiv.org e-Print
archive, 2021. URL: https://arxiv.org/abs/2110.03467.
[15] G. Xiao, L. Ding, B. Cogrel, D. Calvanese, Virtual Knowledge Graphs: An overview of
systems and use cases, Data Intelligence 1 (2019) 201–223. doi:10.1162/dint_a_00011.
[16] G. Xiao, D. Lanti, R. Kontchakov, S. Komla-Ebri, E. Güzel-Kalayci, L. Ding, J. Corman,
B. Cogrel, D. Calvanese, E. Botoeva, The virtual knowledge graph system Ontop, in: Proc.
of the 19th Int. Semantic Web Conf. (ISWC), volume 12507 of Lecture Notes in Computer
Science, Springer, 2020, pp. 259–277. doi:10.1007/978-3-030-62466-8_17.
[17] A. Poggi, M. Rodriguez-Muro, M. Ruzzi, Ontology-based database access with DIG-Mastro
and the OBDA Plugin for Protégé, in: K. Clark, P. F. Patel-Schneider (Eds.), Proc. of the
4th Int. Workshop on OWL: Experiences and Directions (OWLED), 2008.
[18] Dolibarr Open Source ERP CRM, Web suite for business, https://www.dolibarr.org/, 2021.
(Last accessed on 5 May 2022).</p>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          [1]
          <string-name>
            <surname>W. M. P. van der Aalst</surname>
          </string-name>
          , et al.,
          <source>Process Mining Manifesto, in: Proc. of the Business Process Management Workshops (BPM-WS)</source>
          ,
          <source>volume 99 of Lecture Notes in Business Information Processing</source>
          , Springer,
          <year>2011</year>
          , pp.
          <fpage>169</fpage>
          -
          <lpage>194</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>642</fpage>
          -28108-2_
          <fpage>19</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref2">
        <mixed-citation>
          [2]
          <string-name>
            <surname>W. van der Aalst</surname>
          </string-name>
          , Process Mining - Data Science in Action, 2nd ed., Springer,
          <year>2016</year>
          .
        </mixed-citation>
      </ref>
      <ref id="ref3">
        <mixed-citation>
          [3]
          <string-name>
            <given-names>D.</given-names>
            <surname>Calvanese</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M.</given-names>
            <surname>Montali</surname>
          </string-name>
          ,
          <string-name>
            <given-names>A.</given-names>
            <surname>Syamsiyah</surname>
          </string-name>
          ,
          <string-name>
            <surname>W. M. P. van der Aalst</surname>
          </string-name>
          ,
          <article-title>Ontology-driven extraction of event logs from relational databases</article-title>
          ,
          <source>in: Proc. of the 11th Int. Workshop on Business Process Intelligence (BPI)</source>
          ,
          <source>volume 256 of Lecture Notes in Business Information Processing</source>
          , Springer,
          <year>2016</year>
          , pp.
          <fpage>140</fpage>
          -
          <lpage>153</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>319</fpage>
          -42887-1_
          <fpage>12</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref4">
        <mixed-citation>
          [4]
          <string-name>
            <given-names>D.</given-names>
            <surname>Calvanese</surname>
          </string-name>
          ,
          <string-name>
            <given-names>T. E.</given-names>
            <surname>Kalayci</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M.</given-names>
            <surname>Montali</surname>
          </string-name>
          ,
          <string-name>
            <given-names>A.</given-names>
            <surname>Santoso</surname>
          </string-name>
          ,
          <article-title>The onprom toolchain for extracting business process logs using ontology-based data access</article-title>
          ,
          <source>in: Proc. of the BPM Demo Track and BPM Dissertation Award (BPM-D&amp;DA)</source>
          , volume
          <volume>1920</volume>
          <source>of CEUR Workshop Proceedings, CEUR-WS.org</source>
          ,
          <year>2017</year>
          . URL: http://ceur-ws.
          <source>org/</source>
          Vol-1920/BPM_2017_paper_207.pdf.
        </mixed-citation>
      </ref>
      <ref id="ref5">
        <mixed-citation>
          [5]
          <string-name>
            <given-names>D.</given-names>
            <surname>Calvanese</surname>
          </string-name>
          ,
          <string-name>
            <given-names>T. E.</given-names>
            <surname>Kalayci</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M.</given-names>
            <surname>Montali</surname>
          </string-name>
          ,
          <string-name>
            <given-names>S.</given-names>
            <surname>Tinella</surname>
          </string-name>
          ,
          <article-title>Ontology-based data access for extracting event logs from legacy data: The onprom tool and methodology</article-title>
          ,
          <source>in: Proc. of the 20th Int. Conf. on Business Information Systems (BIS)</source>
          ,
          <source>volume 288 of Lecture Notes in Business Information Processing</source>
          , Springer,
          <year>2017</year>
          , pp.
          <fpage>220</fpage>
          -
          <lpage>236</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>319</fpage>
          -59336-416.
        </mixed-citation>
      </ref>
      <ref id="ref6">
        <mixed-citation>
          [6]
          <string-name>
            <given-names>D.</given-names>
            <surname>Calvanese</surname>
          </string-name>
          ,
          <string-name>
            <given-names>T. E.</given-names>
            <surname>Kalayci</surname>
          </string-name>
          ,
          <string-name>
            <given-names>M.</given-names>
            <surname>Montali</surname>
          </string-name>
          ,
          <string-name>
            <given-names>A.</given-names>
            <surname>Santoso</surname>
          </string-name>
          , W. van der Aalst,
          <article-title>Conceptual schema transformation in ontology-based data access</article-title>
          ,
          <source>in: Proc. of the 21st Int. Conf. on Knowledge Engineering and Knowledge Management (EKAW)</source>
          , volume
          <volume>11313</volume>
          of Lecture Notes in Computer Science, Springer,
          <year>2018</year>
          , pp.
          <fpage>50</fpage>
          -
          <lpage>67</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>030</fpage>
          -03667-
          <issue>6</issue>
          _
          <fpage>4</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref7">
        <mixed-citation>
          [7]
          <string-name>
            <given-names>H. M. W.</given-names>
            <surname>Verbeek</surname>
          </string-name>
          ,
          <string-name>
            <given-names>J. C. A. M.</given-names>
            <surname>Buijs</surname>
          </string-name>
          ,
          <string-name>
            <surname>B. F. van Dongen</surname>
          </string-name>
          ,
          <string-name>
            <surname>W. M. P. van der Aalst</surname>
          </string-name>
          , XES, XESame, and
          <article-title>ProM 6</article-title>
          ,
          <source>in: Information Systems Evolution: Selected Extended Papers of CAiSE Forum</source>
          <year>2010</year>
          , volume
          <volume>72</volume>
          <source>of Lecture Notes in Business Information Processing</source>
          , Springer,
          <year>2010</year>
          , pp.
          <fpage>60</fpage>
          -
          <lpage>75</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>642</fpage>
          -17722-
          <issue>4</issue>
          _
          <fpage>5</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref8">
        <mixed-citation>
          [8]
          <string-name>
            <surname>M. B. Shankara Narayana</surname>
            ,
            <given-names>H.</given-names>
          </string-name>
          <string-name>
            <surname>Khalifa</surname>
            ,
            <given-names>W. M. P. van der Aalst</given-names>
          </string-name>
          ,
          <article-title>JXES: JSON Support for the XES Event Log Standard</article-title>
          ,
          <source>CoRR Technical Report arXiv:2009</source>
          .
          <volume>06363</volume>
          , arXiv.org e-Print archive,
          <year>2020</year>
          . URL: https://arxiv.org/abs/
          <year>2009</year>
          .06363.
        </mixed-citation>
      </ref>
      <ref id="ref9">
        <mixed-citation>
          [9]
          <string-name>
            <given-names>E. G.</given-names>
            <surname>L. de Murillas</surname>
          </string-name>
          ,
          <string-name>
            <given-names>H. A.</given-names>
            <surname>Reijers</surname>
          </string-name>
          ,
          <string-name>
            <surname>W. M. P. van der Aalst</surname>
          </string-name>
          ,
          <article-title>Connecting databases with process mining: A meta model and toolset</article-title>
          ,
          <source>Software and System Modeling</source>
          <volume>18</volume>
          (
          <year>2019</year>
          )
          <fpage>1209</fpage>
          -
          <lpage>1247</lpage>
          . doi:
          <volume>10</volume>
          .1007/s10270-018-0664-7.
        </mixed-citation>
      </ref>
      <ref id="ref10">
        <mixed-citation>
          [10]
          <string-name>
            <given-names>G.</given-names>
            <surname>Li</surname>
          </string-name>
          ,
          <string-name>
            <given-names>E. G.</given-names>
            <surname>López de Murillas</surname>
          </string-name>
          ,
          <string-name>
            <surname>R. M. de Carvalho</surname>
            ,
            <given-names>W. M. P. van der Aalst</given-names>
          </string-name>
          ,
          <article-title>Extracting objectcentric event logs to support process mining on databases</article-title>
          , in: J.
          <string-name>
            <surname>Mendling</surname>
          </string-name>
          , H. Mouratidis (Eds.),
          <source>Proc. of CAiSE Forum</source>
          , volume
          <volume>317</volume>
          <source>of Lecture Notes in Business Information Processing</source>
          , Springer,
          <year>2018</year>
          , pp.
          <fpage>182</fpage>
          -
          <lpage>199</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>319</fpage>
          -92901-9_
          <fpage>16</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref11">
        <mixed-citation>
          [11]
          <string-name>
            <surname>XES</surname>
          </string-name>
          , 1849
          <article-title>-2016 - IEEE Standard for eXtensible Event Stream (XES) for Achieving Interoperability in Event Logs and Event Streams</article-title>
          , IEEE Computer Society,
          <year>2016</year>
          . doi:
          <volume>10</volume>
          .1109/ IEEESTD.
          <year>2016</year>
          .
          <volume>7740858</volume>
          .
        </mixed-citation>
      </ref>
      <ref id="ref12">
        <mixed-citation>
          [12]
          <string-name>
            <surname>W. M. P. van der Aalst</surname>
          </string-name>
          ,
          <article-title>Object-centric process mining: Dealing with divergence and convergence in event data</article-title>
          ,
          <source>in: Proc. of the 17th Int. Conf. on Software Engineering and Formal Methods (SEFM)</source>
          , volume
          <volume>11724</volume>
          of Lecture Notes in Computer Science, Springer,
          <year>2019</year>
          , pp.
          <fpage>3</fpage>
          -
          <lpage>25</lpage>
          . doi:
          <volume>10</volume>
          .1007/978-3-
          <fpage>030</fpage>
          -30446-
          <issue>1</issue>
          _
          <fpage>1</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref13">
        <mixed-citation>
          [13]
          <string-name>
            <given-names>A. F.</given-names>
            <surname>Ghahfarokhi</surname>
          </string-name>
          ,
          <string-name>
            <given-names>G.</given-names>
            <surname>Park</surname>
          </string-name>
          ,
          <string-name>
            <given-names>A.</given-names>
            <surname>Berti</surname>
          </string-name>
          ,
          <string-name>
            <surname>W. M. P. van der Aalst</surname>
          </string-name>
          ,
          <article-title>OCEL: A standard for object-</article-title>
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>