<?xml version="1.0" encoding="utf-8"?>
<TEI xmlns="http://www.tei-c.org/ns/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:hal="http://hal.archives-ouvertes.fr/" xmlns:gml="http://www.opengis.net/gml/3.3/" xmlns:gmlce="http://www.opengis.net/gml/3.3/ce" version="1.1" xsi:schemaLocation="http://www.tei-c.org/ns/1.0 http://api.archives-ouvertes.fr/documents/aofr-sword.xsd">
  <teiHeader>
    <fileDesc>
      <titleStmt>
        <title>HAL TEI export of hal-03758493</title>
      </titleStmt>
      <publicationStmt>
        <distributor>CCSD</distributor>
        <availability status="restricted">
          <licence target="https://creativecommons.org/publicdomain/zero/1.0/">CC0 1.0 - Universal</licence>
        </availability>
        <date when="2026-05-02T13:09:34+02:00"/>
      </publicationStmt>
      <sourceDesc>
        <p part="N">HAL API Platform</p>
      </sourceDesc>
    </fileDesc>
  </teiHeader>
  <text>
    <body>
      <listBibl>
        <biblFull>
          <titleStmt>
            <title xml:lang="en">Data Warehousing Process Modeling from Classical Approaches to New Trends: Main Features and Comparisons</title>
            <author role="aut">
              <persName>
                <forename type="first">Asma</forename>
                <surname>Dhaouadi</surname>
              </persName>
              <email type="md5">57a894bd57bacd7c546a7e0707b43942</email>
              <email type="domain">univ-smb.fr</email>
              <idno type="idhal" notation="numeric">1157659</idno>
              <idno type="halauthorid" notation="string">1727360-1157659</idno>
              <idno type="ORCID">https://orcid.org/0000-0002-9832-5000</idno>
              <idno type="IDREF">https://www.idref.fr/284368504</idno>
              <affiliation ref="#struct-207896"/>
              <affiliation ref="#struct-7118"/>
              <affiliation ref="#struct-193244"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Khadija</forename>
                <surname>Bousselmi</surname>
              </persName>
              <email type="md5">35d0d6c2bc44d2f246f2913ac2190dc2</email>
              <email type="domain">univ-smb.fr</email>
              <idno type="idhal" notation="string">khadija-bousalmi</idno>
              <idno type="idhal" notation="numeric">747501</idno>
              <idno type="halauthorid" notation="string">2497785-747501</idno>
              <idno type="ORCID">https://orcid.org/0000-0002-9477-3455</idno>
              <affiliation ref="#struct-7118"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Mohamed Mohsen</forename>
                <surname>Gammoudi</surname>
              </persName>
              <idno type="halauthorid">607397-0</idno>
              <affiliation ref="#struct-193244"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Sébastien</forename>
                <surname>Monnet</surname>
              </persName>
              <idno type="halauthorid">125784-0</idno>
              <affiliation ref="#struct-7118"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Slimane</forename>
                <surname>Hammoudi</surname>
              </persName>
              <idno type="halauthorid">433854-0</idno>
              <affiliation ref="#struct-534763"/>
            </author>
            <editor role="depositor">
              <persName>
                <forename>Asma</forename>
                <surname>Dhaouadi</surname>
              </persName>
              <email type="md5">46f6bb3d2e95a94955b99b8c119733a9</email>
              <email type="domain">gmail.com</email>
            </editor>
          </titleStmt>
          <editionStmt>
            <edition n="v1" type="current">
              <date type="whenSubmitted">2022-08-23 11:24:31</date>
              <date type="whenModified">2025-03-26 17:36:09</date>
              <date type="whenReleased">2022-08-23 11:35:59</date>
              <date type="whenProduced">2022</date>
              <date type="whenEndEmbargoed">2022-08-23</date>
              <ref type="file" target="https://hal.science/hal-03758493v1/document">
                <date notBefore="2022-08-23"/>
              </ref>
              <ref type="file" subtype="greenPublisher" n="1" target="https://hal.science/hal-03758493v1/file/data-07-00113%20%284%29-1.pdf" id="file-3758493-3285389">
                <date notBefore="2022-08-23"/>
              </ref>
            </edition>
            <respStmt>
              <resp>contributor</resp>
              <name key="734024">
                <persName>
                  <forename>Asma</forename>
                  <surname>Dhaouadi</surname>
                </persName>
                <email type="md5">46f6bb3d2e95a94955b99b8c119733a9</email>
                <email type="domain">gmail.com</email>
              </name>
            </respStmt>
          </editionStmt>
          <publicationStmt>
            <distributor>CCSD</distributor>
            <idno type="halId">hal-03758493</idno>
            <idno type="halUri">https://hal.science/hal-03758493</idno>
            <idno type="halBibtex">dhaouadi:hal-03758493</idno>
            <idno type="halRefHtml">&lt;i&gt;Data&lt;/i&gt;, 2022, 7 (8), pp.113. &lt;a target="_blank" href="https://dx.doi.org/10.3390/data7080113"&gt;&amp;#x27E8;10.3390/data7080113&amp;#x27E9;&lt;/a&gt;</idno>
            <idno type="halRef">Data, 2022, 7 (8), pp.113. &amp;#x27E8;10.3390/data7080113&amp;#x27E9;</idno>
            <availability status="restricted">
              <licence target="https://about.hal.science/hal-authorisation-v1/">HAL Authorization<ref corresp="#file-3758493-3285389"/></licence>
            </availability>
          </publicationStmt>
          <seriesStmt>
            <idno type="stamp" n="UNIV-SAVOIE">Université Savoie Mont Blanc</idno>
            <idno type="stamp" n="ESEO-TECH">ESEO</idno>
            <idno type="stamp" n="LISTIC" corresp="UNIV-SAVOIE">Laboratoire d’Informatique, Systèmes, Traitement de l’Information et de la Connaissance</idno>
            <idno type="stamp" n="ESEO-ERIS" corresp="ESEO-TECH">ESEO-ERIS</idno>
          </seriesStmt>
          <notesStmt>
            <note type="audience" n="2">International</note>
            <note type="popular" n="0">No</note>
            <note type="peer" n="1">Yes</note>
          </notesStmt>
          <sourceDesc>
            <biblStruct>
              <analytic>
                <title xml:lang="en">Data Warehousing Process Modeling from Classical Approaches to New Trends: Main Features and Comparisons</title>
                <author role="aut">
                  <persName>
                    <forename type="first">Asma</forename>
                    <surname>Dhaouadi</surname>
                  </persName>
                  <email type="md5">57a894bd57bacd7c546a7e0707b43942</email>
                  <email type="domain">univ-smb.fr</email>
                  <idno type="idhal" notation="numeric">1157659</idno>
                  <idno type="halauthorid" notation="string">1727360-1157659</idno>
                  <idno type="ORCID">https://orcid.org/0000-0002-9832-5000</idno>
                  <idno type="IDREF">https://www.idref.fr/284368504</idno>
                  <affiliation ref="#struct-207896"/>
                  <affiliation ref="#struct-7118"/>
                  <affiliation ref="#struct-193244"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Khadija</forename>
                    <surname>Bousselmi</surname>
                  </persName>
                  <email type="md5">35d0d6c2bc44d2f246f2913ac2190dc2</email>
                  <email type="domain">univ-smb.fr</email>
                  <idno type="idhal" notation="string">khadija-bousalmi</idno>
                  <idno type="idhal" notation="numeric">747501</idno>
                  <idno type="halauthorid" notation="string">2497785-747501</idno>
                  <idno type="ORCID">https://orcid.org/0000-0002-9477-3455</idno>
                  <affiliation ref="#struct-7118"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Mohamed Mohsen</forename>
                    <surname>Gammoudi</surname>
                  </persName>
                  <idno type="halauthorid">607397-0</idno>
                  <affiliation ref="#struct-193244"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Sébastien</forename>
                    <surname>Monnet</surname>
                  </persName>
                  <idno type="halauthorid">125784-0</idno>
                  <affiliation ref="#struct-7118"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Slimane</forename>
                    <surname>Hammoudi</surname>
                  </persName>
                  <idno type="halauthorid">433854-0</idno>
                  <affiliation ref="#struct-534763"/>
                </author>
              </analytic>
              <monogr>
                <idno type="halJournalId" status="VALID">142206</idno>
                <idno type="issn">2306-5729</idno>
                <title level="j">Data</title>
                <imprint>
                  <publisher>MDPI</publisher>
                  <biblScope unit="volume">7</biblScope>
                  <biblScope unit="issue">8</biblScope>
                  <biblScope unit="pp">113</biblScope>
                  <date type="datePub">2022</date>
                </imprint>
              </monogr>
              <idno type="doi">10.3390/data7080113</idno>
            </biblStruct>
          </sourceDesc>
          <profileDesc>
            <langUsage>
              <language ident="en">English</language>
            </langUsage>
            <textClass>
              <keywords scheme="author">
                <term xml:lang="en">graphical flow</term>
                <term xml:lang="en">systematic review</term>
                <term xml:lang="en">MDA</term>
                <term xml:lang="en">ontology</term>
                <term xml:lang="en">BPMN</term>
                <term xml:lang="en">UML</term>
                <term xml:lang="en">Big Data</term>
                <term xml:lang="en">ETL modeling</term>
                <term xml:lang="en">data warehouse</term>
                <term xml:lang="en">ETL process</term>
              </keywords>
              <classCode scheme="halDomain" n="info">Computer Science [cs]</classCode>
              <classCode scheme="halTypology" n="ART">Journal articles</classCode>
              <classCode scheme="halOldTypology" n="ART">Journal articles</classCode>
              <classCode scheme="halTreeTypology" n="ART">Journal articles</classCode>
            </textClass>
            <abstract xml:lang="en">
              <p>The extract, transform, and load (ETL) process is at the core of data warehousing architectures. As such, the success of data warehouse (DW) projects is essentially based on the proper modeling of the ETL process. As there is no standard model for the representation and design of this process, several researchers have made efforts to propose modeling methods based on different formalisms, such as unified modeling language (UML), ontology, model-driven architecture (MDA), model-driven development (MDD), and graphical flow, which includes business process model notation (BPMN), colored Petri nets (CPN), Yet Another Workflow Language (YAWL), CommonCube, entity modeling diagram (EMD), and so on. With the emergence of Big Data, despite the multitude of relevant approaches proposed for modeling the ETL process in classical environments, part of the community has been motivated to provide new data warehousing methods that support Big Data specifications. In this paper, we present a summary of relevant works related to the modeling of data warehousing approaches, from classical ETL processes to ELT design approaches. A systematic literature review is conducted and a detailed set of comparison criteria are defined in order to allow the reader to better understand the evolution of these processes. Our study paints a complete picture of ETL modeling approaches, from their advent to the era of Big Data, while comparing their main characteristics. This study allows for the identification of the main challenges and issues related to the design of Big Data warehousing systems, mainly involving the lack of a generic design model for data collection, storage, processing, querying, and analysis.</p>
            </abstract>
          </profileDesc>
        </biblFull>
      </listBibl>
    </body>
    <back>
      <listOrg type="structures">
        <org type="regroupinstitution" xml:id="struct-207896" status="VALID">
          <idno type="IdRef">112859585</idno>
          <idno type="ISNI">0000000122959819</idno>
          <idno type="ROR">https://ror.org/029cgt552</idno>
          <idno type="Wikidata">Q3551684</idno>
          <orgName>Tunis El Manar University [University of Tunis El Manar] [Tunisia] = Université de Tunis El Manar [Tunisie] = جامعة تونس المنار (ar)</orgName>
          <orgName type="acronym">UTM</orgName>
          <date type="start">1987-01-01</date>
          <desc>
            <address>
              <addrLine>Campus Universitaire Farhat Hached B.P. n° 94 - ROMMANA 1068 Tunis</addrLine>
              <country key="TN"/>
            </address>
            <ref type="url">http://www.utm.rnu.tn/</ref>
          </desc>
        </org>
        <org type="laboratory" xml:id="struct-7118" status="VALID">
          <orgName>Laboratoire d'Informatique, Systèmes, Traitement de l'Information et de la Connaissance</orgName>
          <orgName type="acronym">LISTIC</orgName>
          <desc>
            <address>
              <addrLine>BP 80439 74944 ANNECY LE VIEUX Cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.listic.univ-savoie.fr</ref>
          </desc>
          <listRelation>
            <relation name="EA3703" active="#struct-432896" type="direct"/>
          </listRelation>
        </org>
        <org type="regroupinstitution" xml:id="struct-193244" status="VALID">
          <idno type="ROR">https://ror.org/0503ejf32</idno>
          <orgName>Université de la Manouba [Tunisie]</orgName>
          <orgName type="acronym">UMA</orgName>
          <desc>
            <address>
              <addrLine>Campus Universitaire de la Manouba - la Manouba 2010</addrLine>
              <country key="TN"/>
            </address>
            <ref type="url">http://www.uma.rnu.tn</ref>
          </desc>
        </org>
        <org type="researchteam" xml:id="struct-534763" status="VALID">
          <orgName>ESEO-ÉRIS</orgName>
          <orgName type="acronym">ÉRIS</orgName>
          <desc>
            <address>
              <country key="FR"/>
            </address>
          </desc>
          <listRelation>
            <relation active="#struct-188843" type="direct"/>
            <relation active="#struct-469973" type="indirect"/>
            <relation active="#struct-499274" type="indirect"/>
          </listRelation>
        </org>
        <org type="institution" xml:id="struct-432896" status="VALID">
          <idno type="ROR">https://ror.org/04gqg1a07</idno>
          <orgName>Université Savoie Mont Blanc</orgName>
          <orgName type="acronym">USMB [Université de Savoie] [Université de Chambéry]</orgName>
          <date type="start">1979-10-01</date>
          <desc>
            <address>
              <addrLine>27, rue Marcoz - 73000 Chambéry</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">https://www.univ-smb.fr</ref>
          </desc>
        </org>
        <org type="laboratory" xml:id="struct-188843" status="VALID">
          <orgName>ESEO-Tech</orgName>
          <desc>
            <address>
              <addrLine>10 boulevard JeanneteauCS 9071749107 Angers cedex 2</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.eseo.fr/</ref>
          </desc>
          <listRelation>
            <relation active="#struct-469973" type="direct"/>
            <relation active="#struct-499274" type="direct"/>
          </listRelation>
        </org>
        <org type="regroupinstitution" xml:id="struct-469973" status="VALID">
          <idno type="IdRef">191639044</idno>
          <idno type="ROR">https://ror.org/04x1a4s97</idno>
          <orgName>Université Bretagne Loire</orgName>
          <orgName type="acronym">UBL</orgName>
          <date type="start">2016-04-01</date>
          <desc>
            <address>
              <addrLine>Cité Internationale, 1 place Paul Ricoeur - CS 54417 35044 RENNES CEDEX</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">https://u-bretagneloire.fr/</ref>
          </desc>
        </org>
        <org type="institution" xml:id="struct-499274" status="VALID">
          <idno type="ROR">https://ror.org/04nx9ps90</idno>
          <orgName>École supérieure d'électronique de l'ouest [Angers]</orgName>
          <orgName type="acronym">ESEO</orgName>
          <desc>
            <address>
              <addrLine>10 Boulevard Jean Jeanneteau, 49100 Angers</addrLine>
              <country key="FR"/>
            </address>
          </desc>
        </org>
      </listOrg>
    </back>
  </text>
</TEI>