TY - CHAP A1 - Schlager, Reinhold A1 - Schildgen, Johannes T1 - A Query-Rewriting-based Implementation for Temporal Data Management T2 - LWDA’24: Lernen, Wissen, Daten, Analysen. September 23–25, 2024, Würzburg, Germany N2 - 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. KW - Temporal data management KW - Data warehouse KW - Exasol KW - Database Y1 - 2024 UR - https://www.informatik.uni-wuerzburg.de/fileadmin/1003-lwda24/LWDA_Paper/DB_LWDA_CRC_164.pdf ER -