<?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-01228962</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-20T10:37:43+02:00"/>
      </publicationStmt>
      <sourceDesc>
        <p part="N">HAL API Platform</p>
      </sourceDesc>
    </fileDesc>
  </teiHeader>
  <text>
    <body>
      <listBibl>
        <biblFull>
          <titleStmt>
            <title xml:lang="en">Bi-temporal Query Optimization Techniques in Decision Insight</title>
            <author role="aut">
              <persName>
                <forename type="first">Azhar</forename>
                <surname>Ait Ouassarah</surname>
              </persName>
              <email type="md5">3f61432019535f0492a0296a0fd9e962</email>
              <email type="domain">gmail.com</email>
              <idno type="idhal" notation="string">azharait-ouassarah</idno>
              <idno type="idhal" notation="numeric">4574</idno>
              <idno type="halauthorid" notation="string">26133-4574</idno>
              <idno type="IDREF">https://www.idref.fr/197427642</idno>
              <affiliation ref="#struct-401125"/>
              <affiliation ref="#struct-446243"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Nicolas</forename>
                <surname>Averseng</surname>
              </persName>
              <idno type="halauthorid">922482-0</idno>
              <affiliation ref="#struct-446243"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Xavier</forename>
                <surname>Fournet</surname>
              </persName>
              <idno type="halauthorid">922483-0</idno>
              <affiliation ref="#struct-446243"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Jean-Marc</forename>
                <surname>Petit</surname>
              </persName>
              <email type="md5">d0febb70cc7c769fb5d2ddd749dcd7cc</email>
              <email type="domain">insa-lyon.fr</email>
              <idno type="idhal" notation="string">jean-marc-petit</idno>
              <idno type="idhal" notation="numeric">4224</idno>
              <idno type="halauthorid" notation="string">6358-4224</idno>
              <idno type="ORCID">https://orcid.org/0000-0002-0015-745X</idno>
              <affiliation ref="#struct-301232"/>
              <affiliation ref="#struct-401125"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Romain</forename>
                <surname>Revol</surname>
              </persName>
              <idno type="halauthorid">922484-0</idno>
              <affiliation ref="#struct-446243"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Vasile-Marian</forename>
                <surname>Scuturici</surname>
              </persName>
              <email type="md5">7f84dddf8ac0aaf83d221950791a6b5b</email>
              <email type="domain">insa-lyon.fr</email>
              <idno type="idhal" notation="string">vasile-marian-scuturici</idno>
              <idno type="idhal" notation="numeric">3040</idno>
              <idno type="halauthorid" notation="string">19146-3040</idno>
              <idno type="ORCID">https://orcid.org/0000-0001-8139-0212</idno>
              <idno type="IDREF">https://www.idref.fr/059677465</idno>
              <affiliation ref="#struct-401125"/>
              <affiliation ref="#struct-301232"/>
            </author>
            <editor role="depositor">
              <persName>
                <forename>Azhar</forename>
                <surname>AIT OUASSARAH</surname>
              </persName>
              <email type="md5">3f61432019535f0492a0296a0fd9e962</email>
              <email type="domain">gmail.com</email>
            </editor>
            <funder>Thèse CIFRE financée par l'entreprise Axway</funder>
          </titleStmt>
          <editionStmt>
            <edition n="v1" type="current">
              <date type="whenSubmitted">2016-01-21 15:53:12</date>
              <date type="whenModified">2025-09-03 10:37:49</date>
              <date type="whenReleased">2016-01-22 10:59:23</date>
              <date type="whenProduced">2015-09-29</date>
              <date type="whenEndEmbargoed">2016-01-21</date>
              <ref type="file" target="https://hal.science/hal-01228962v1/document">
                <date notBefore="2016-01-21"/>
              </ref>
              <ref type="file" subtype="author" n="1" target="https://hal.science/hal-01228962v1/file/Bi-temporal%20Query%20Optimization%20Techniques%20in%20Decision%20Insight.pdf" id="file-1259798-1339432">
                <date notBefore="2016-01-21"/>
              </ref>
            </edition>
            <respStmt>
              <resp>contributor</resp>
              <name key="318183">
                <persName>
                  <forename>Azhar</forename>
                  <surname>AIT OUASSARAH</surname>
                </persName>
                <email type="md5">3f61432019535f0492a0296a0fd9e962</email>
                <email type="domain">gmail.com</email>
              </name>
            </respStmt>
          </editionStmt>
          <publicationStmt>
            <distributor>CCSD</distributor>
            <idno type="halId">hal-01228962</idno>
            <idno type="halUri">https://hal.science/hal-01228962</idno>
            <idno type="halBibtex">aitouassarah:hal-01228962</idno>
            <idno type="halRefHtml">&lt;i&gt;Bases de Données Avancées (BDA)&lt;/i&gt;, Sep 2015, Île de Porquerolles, France</idno>
            <idno type="halRef">Bases de Données Avancées (BDA), Sep 2015, Île de Porquerolles, France</idno>
            <availability status="restricted">
              <licence target="https://creativecommons.org/licenses/by-nc-nd/4.0/">CC BY-NC-ND 4.0 - Attribution - Non-commercial use - No Derivative Works<ref corresp="#file-1259798-1339432"/></licence>
            </availability>
          </publicationStmt>
          <seriesStmt>
            <idno type="stamp" n="CNRS">CNRS - Centre national de la recherche scientifique</idno>
            <idno type="stamp" n="UNIV-LYON1">Université Claude Bernard - Lyon I</idno>
            <idno type="stamp" n="UNIV-LYON2">Université Lumière Lyon 2</idno>
            <idno type="stamp" n="INSA-LYON">Institut National des Sciences Appliquées de Lyon</idno>
            <idno type="stamp" n="EC-LYON">Ecole Centrale de Lyon</idno>
            <idno type="stamp" n="LIRIS" corresp="UNIV-LYON1">Laboratoire d'InfoRmatique en Image et Systèmes d'information</idno>
            <idno type="stamp" n="LABEXIMU">Laboratoire d’Excellence Intelligences des Mondes Urbains</idno>
            <idno type="stamp" n="INSA-GROUPE">Groupe INSA</idno>
            <idno type="stamp" n="UDL">UDL</idno>
            <idno type="stamp" n="UNIV-LYON">Université de Lyon</idno>
            <idno type="stamp" n="HAL-LYON-2-NOUVELLE-VERSION">Nouvelle version portail </idno>
          </seriesStmt>
          <notesStmt>
            <note type="audience" n="3">National</note>
            <note type="invited" n="0">No</note>
            <note type="popular" n="0">No</note>
            <note type="peer" n="1">Yes</note>
            <note type="proceedings" n="0">No</note>
          </notesStmt>
          <sourceDesc>
            <biblStruct>
              <analytic>
                <title xml:lang="en">Bi-temporal Query Optimization Techniques in Decision Insight</title>
                <author role="aut">
                  <persName>
                    <forename type="first">Azhar</forename>
                    <surname>Ait Ouassarah</surname>
                  </persName>
                  <email type="md5">3f61432019535f0492a0296a0fd9e962</email>
                  <email type="domain">gmail.com</email>
                  <idno type="idhal" notation="string">azharait-ouassarah</idno>
                  <idno type="idhal" notation="numeric">4574</idno>
                  <idno type="halauthorid" notation="string">26133-4574</idno>
                  <idno type="IDREF">https://www.idref.fr/197427642</idno>
                  <affiliation ref="#struct-401125"/>
                  <affiliation ref="#struct-446243"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Nicolas</forename>
                    <surname>Averseng</surname>
                  </persName>
                  <idno type="halauthorid">922482-0</idno>
                  <affiliation ref="#struct-446243"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Xavier</forename>
                    <surname>Fournet</surname>
                  </persName>
                  <idno type="halauthorid">922483-0</idno>
                  <affiliation ref="#struct-446243"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Jean-Marc</forename>
                    <surname>Petit</surname>
                  </persName>
                  <email type="md5">d0febb70cc7c769fb5d2ddd749dcd7cc</email>
                  <email type="domain">insa-lyon.fr</email>
                  <idno type="idhal" notation="string">jean-marc-petit</idno>
                  <idno type="idhal" notation="numeric">4224</idno>
                  <idno type="halauthorid" notation="string">6358-4224</idno>
                  <idno type="ORCID">https://orcid.org/0000-0002-0015-745X</idno>
                  <affiliation ref="#struct-301232"/>
                  <affiliation ref="#struct-401125"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Romain</forename>
                    <surname>Revol</surname>
                  </persName>
                  <idno type="halauthorid">922484-0</idno>
                  <affiliation ref="#struct-446243"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Vasile-Marian</forename>
                    <surname>Scuturici</surname>
                  </persName>
                  <email type="md5">7f84dddf8ac0aaf83d221950791a6b5b</email>
                  <email type="domain">insa-lyon.fr</email>
                  <idno type="idhal" notation="string">vasile-marian-scuturici</idno>
                  <idno type="idhal" notation="numeric">3040</idno>
                  <idno type="halauthorid" notation="string">19146-3040</idno>
                  <idno type="ORCID">https://orcid.org/0000-0001-8139-0212</idno>
                  <idno type="IDREF">https://www.idref.fr/059677465</idno>
                  <affiliation ref="#struct-401125"/>
                  <affiliation ref="#struct-301232"/>
                </author>
              </analytic>
              <monogr>
                <meeting>
                  <title>Bases de Données Avancées (BDA)</title>
                  <date type="start">2015-09-29</date>
                  <date type="end">2015-10-02</date>
                  <settlement>Île de Porquerolles</settlement>
                  <country key="FR">France</country>
                </meeting>
                <imprint/>
              </monogr>
              <ref type="publisher">http://bda2015.univ-tln.fr/</ref>
            </biblStruct>
          </sourceDesc>
          <profileDesc>
            <langUsage>
              <language ident="en">English</language>
            </langUsage>
            <textClass>
              <keywords scheme="author">
                <term xml:lang="en">Business Intelligence</term>
                <term xml:lang="en">Business Activity Monitoring</term>
                <term xml:lang="en">Temporal Databases</term>
              </keywords>
              <classCode scheme="acm" n="H">H.: Information Systems</classCode>
              <classCode scheme="acm" n="H.2">H.: Information Systems/H.2: DATABASE MANAGEMENT</classCode>
              <classCode scheme="acm" n="H.2.4.5">H.: Information Systems/H.2: DATABASE MANAGEMENT/H.2.4: Systems/H.2.4.5: Query processing</classCode>
              <classCode scheme="halDomain" n="info.info-db">Computer Science [cs]/Databases [cs.DB]</classCode>
              <classCode scheme="halTypology" n="COMM">Conference papers</classCode>
              <classCode scheme="halOldTypology" n="COMM">Conference papers</classCode>
              <classCode scheme="halTreeTypology" n="COMM">Conference papers</classCode>
            </textClass>
            <abstract xml:lang="en">
              <p>The complexity of dynamic environments in which companies work requires their managers to take rapid and relevant decisions. A business activity monitoring application should be able to implement complex bi-temporal queries on real-time data and historical data in order to detect business trends and anomalies. However, accessing both real-time and historical data is costly and can hardly meet the application’s requirements of fast responses for analysts.In this paper, we propose Decision Insight, a platform developed by a French software editor, that solves this problem. It consists in redefining such a complex bi-temporal query into: 1) a set of continuous queries in charge of handling real-time data (whose results are materialized) and 2) a query that accesses both historical and materialized results of the previous continuous queries. Thus, Decision Insight can provide analysts with timely answers through a convenient GUI.Decision Insight is based on a column-store bi-temporal DBMS that handles these two types of data and implements a simple and efficient bi-temporal query optimization technique. We demonstrate the interest of our approach using an adapted version of TPCBiH, a bi-temporal extension of the TPC-H benchmark. Extensive experiments have been conducted, pointing out the interest of Decision Insight for delivering timely information based on historical and real-time data.</p>
            </abstract>
            <abstract xml:lang="fr">
              <p>La complexité de l’environnement dynamique dans lequel évoluent les entreprises requiert de la part de leurs managers de prendre des décisions pertinente en un laps de temps très court. Les systèmes de supervision des activités métiers devraient supporter des requêtes bitemporelles complexes qui accèdent aussi bien à des données historiques qu’à des données temps réel afin de détecter des anomalies ou bien des tendances dans l’activité de l’entreprise. Cependant, il s’avère que l’accès à ces deux types de données peutêtre lent, ce qui ne convient pas aux applications de supervision.Dans ce papier, nous présentons Decision Insight, une plateforme développée par un éditeur de logiciels français pour aborder ce problème. Elle est basée sur un SGBD orienté colonnes qui redéfinit les requêtes bi-temporelles en: 1) un ensemble de requêtes continues pour gérer les données temps réel et dont les résultats sont matérialisés, et 2) une requête qui accède aussi bien aux données historiques qu’aux résultats des requêtes continues.Nous démontrons l’intérêt de notre approche en utilisant une version adaptée du benchmark TPC-BiH qui est une extension bi-temporelle du benchmark TPC-H.</p>
            </abstract>
          </profileDesc>
        </biblFull>
      </listBibl>
    </body>
    <back>
      <listOrg type="structures">
        <org type="researchteam" xml:id="struct-401125" status="VALID">
          <orgName>Base de Données</orgName>
          <orgName type="acronym">BD</orgName>
          <desc>
            <address>
              <country key="FR"/>
            </address>
          </desc>
          <listRelation>
            <relation active="#struct-2003" type="direct"/>
            <relation active="#struct-33804" type="indirect"/>
            <relation active="#struct-126765" type="indirect"/>
            <relation active="#struct-301088" type="indirect"/>
            <relation active="#struct-194495" type="indirect"/>
            <relation active="#struct-219748" type="indirect"/>
            <relation active="#struct-301232" type="indirect"/>
            <relation name="UMR5205" active="#struct-441569" type="indirect"/>
          </listRelation>
        </org>
        <org type="institution" xml:id="struct-446243" status="INCOMING">
          <orgName>Axway Software</orgName>
          <desc>
            <address>
              <addrLine>Pae Des Glaisins 3 r Pré Faucon, 74940 ANNECY LE VIEUX</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">https://www.axway.com</ref>
          </desc>
        </org>
        <org type="regroupinstitution" xml:id="struct-301232" status="VALID">
          <idno type="IdRef">162105150</idno>
          <orgName>Institut National des Sciences Appliquées</orgName>
          <orgName type="acronym">INSA</orgName>
          <desc>
            <address>
              <country key="FR"/>
            </address>
          </desc>
        </org>
        <org type="laboratory" xml:id="struct-2003" status="VALID">
          <idno type="IdRef">149705271</idno>
          <idno type="ISNI">0000000122577669</idno>
          <idno type="RNSR">200511875R</idno>
          <idno type="ROR">https://ror.org/04dv4he91</idno>
          <orgName>Laboratoire d'InfoRmatique en Image et Systèmes d'information</orgName>
          <orgName type="acronym">LIRIS</orgName>
          <date type="start">2003-01-01</date>
          <desc>
            <address>
              <addrLine>Bâtiment Blaise Pascal - 20, avenue Albert Einstein - 69621 Villeurbanne cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">https://liris.cnrs.fr/</ref>
          </desc>
          <listRelation>
            <relation active="#struct-33804" type="direct"/>
            <relation active="#struct-126765" type="direct"/>
            <relation active="#struct-301088" type="indirect"/>
            <relation active="#struct-194495" type="direct"/>
            <relation active="#struct-219748" type="direct"/>
            <relation active="#struct-301232" type="indirect"/>
            <relation name="UMR5205" active="#struct-441569" type="direct"/>
          </listRelation>
        </org>
        <org type="institution" xml:id="struct-33804" status="VALID">
          <idno type="IdRef">02640334X</idno>
          <idno type="ISNI">0000 0001 2188 0906</idno>
          <idno type="ROR">https://ror.org/03rth4p18</idno>
          <idno type="Wikidata">Q4041</idno>
          <orgName>Université Lumière - Lyon 2</orgName>
          <orgName type="acronym">UL2</orgName>
          <desc>
            <address>
              <addrLine>86, rue Pasteur - 69007 Lyon</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.univ-lyon2.fr</ref>
          </desc>
        </org>
        <org type="institution" xml:id="struct-126765" status="VALID">
          <idno type="ROR">https://ror.org/05s6rge65</idno>
          <orgName>École Centrale de Lyon</orgName>
          <orgName type="acronym">ECL</orgName>
          <desc>
            <address>
              <addrLine>36 avenue Guy de Collongue - 69134 Ecully cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.ec-lyon.fr</ref>
          </desc>
          <listRelation>
            <relation active="#struct-301088" type="direct"/>
          </listRelation>
        </org>
        <org type="regroupinstitution" xml:id="struct-301088" status="VALID">
          <idno type="ROR">https://ror.org/01rk35k63</idno>
          <orgName>Université de Lyon</orgName>
          <desc>
            <address>
              <addrLine>92 rue Pasteur - CS 30122, 69361 Lyon Cedex 07</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">https://www.universite-lyon.fr/</ref>
          </desc>
        </org>
        <org type="institution" xml:id="struct-194495" status="VALID">
          <idno type="IdRef">026402823</idno>
          <idno type="ISNI">0000000121686185</idno>
          <idno type="ROR">https://ror.org/029brtt94</idno>
          <orgName>Université Claude Bernard Lyon 1</orgName>
          <orgName type="acronym">UCBL</orgName>
          <desc>
            <address>
              <addrLine>43, boulevard du 11 novembre 1918, 69622 Villeurbanne cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.univ-lyon1.fr/</ref>
          </desc>
          <listRelation>
            <relation active="#struct-301088" type="direct"/>
          </listRelation>
        </org>
        <org type="institution" xml:id="struct-219748" status="VALID">
          <idno type="IdRef">052444724</idno>
          <idno type="ISNI">0000 0001 2292 0228</idno>
          <orgName>Institut National des Sciences Appliquées de Lyon</orgName>
          <orgName type="acronym">INSA Lyon</orgName>
          <date type="start">1957-03-18</date>
          <desc>
            <address>
              <addrLine>20 Avenue Albert Einstein, 69621 Villeurbanne cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.insa-lyon.fr/</ref>
          </desc>
          <listRelation>
            <relation active="#struct-301088" type="direct"/>
            <relation active="#struct-301232" type="direct"/>
          </listRelation>
        </org>
        <org type="regroupinstitution" xml:id="struct-441569" status="VALID">
          <idno type="IdRef">02636817X</idno>
          <idno type="ISNI">0000000122597504</idno>
          <idno type="ROR">https://ror.org/02feahw73</idno>
          <orgName>Centre National de la Recherche Scientifique</orgName>
          <orgName type="acronym">CNRS</orgName>
          <date type="start">1939-10-19</date>
          <desc>
            <address>
              <country key="FR"/>
            </address>
            <ref type="url">https://www.cnrs.fr/</ref>
          </desc>
        </org>
      </listOrg>
    </back>
  </text>
</TEI>