<?xml version="1.0" encoding="utf-8"?>
<export-example>
  <doc>
    <id>7857</id>
    <completedYear/>
    <publishedYear>2024</publishedYear>
    <thesisYearAccepted/>
    <language>eng</language>
    <pageFirst/>
    <pageLast/>
    <pageNumber>14 Seiten</pageNumber>
    <edition/>
    <issue/>
    <volume/>
    <type>conferenceobject</type>
    <publisherName/>
    <publisherPlace/>
    <creatingCorporation/>
    <contributingCorporation/>
    <belongsToBibliography>0</belongsToBibliography>
    <completedDate>2024-12-13</completedDate>
    <publishedDate>--</publishedDate>
    <thesisDateAccepted>--</thesisDateAccepted>
    <title language="eng">A Query-Rewriting-based Implementation for Temporal Data Management</title>
    <abstract language="eng">Temporal data management is used to query historical data, identify trends and changes, and make forecasts for the future. This paper provides a query-rewriting approach to implement temporal data management in the data-warehouse system Exasol by using so-called preprocessor scripts. Preprocessor scripts allow for executing custom Lua code and modifying SQL commands. Our approach does not need to undertake additional manual effort by the user. History tables and associated views are created in the background. Data records are automatically archived if they are updated or deleted, and the SELECT command is extended with the AS OF SYSTEM TIME clause as proposed by the SQL Standard.</abstract>
    <parentTitle language="deu">LWDA’24: Lernen, Wissen, Daten, Analysen. September 23–25, 2024, Würzburg, Germany</parentTitle>
    <identifier type="url">https://www.informatik.uni-wuerzburg.de/fileadmin/1003-lwda24/LWDA_Paper/DB_LWDA_CRC_164.pdf</identifier>
    <enrichment key="opus.source">publish</enrichment>
    <enrichment key="opus.doi.autoCreate">false</enrichment>
    <enrichment key="opus.urn.autoCreate">true</enrichment>
    <licence>Creative Commons - CC BY - Namensnennung 4.0 International</licence>
    <author>Reinhold Schlager</author>
    <author>Johannes Schildgen</author>
    <subject>
      <language>eng</language>
      <type>uncontrolled</type>
      <value>Temporal data management</value>
    </subject>
    <subject>
      <language>eng</language>
      <type>uncontrolled</type>
      <value>Data warehouse</value>
    </subject>
    <subject>
      <language>eng</language>
      <type>uncontrolled</type>
      <value>Exasol</value>
    </subject>
    <subject>
      <language>eng</language>
      <type>uncontrolled</type>
      <value>Database</value>
    </subject>
    <collection role="institutes" number="FakIM">Fakultät Informatik und Mathematik</collection>
    <collection role="othforschungsschwerpunkt" number="16311">Digitalisierung</collection>
  </doc>
</export-example>
