@inproceedings{SchlagerSchildgen, author = {Schlager, Reinhold and Schildgen, Johannes}, title = {A Query-Rewriting-based Implementation for Temporal Data Management}, series = {LWDA'24: Lernen, Wissen, Daten, Analysen. September 23-25, 2024, W{\"u}rzburg, Germany}, booktitle = {LWDA'24: Lernen, Wissen, Daten, Analysen. September 23-25, 2024, W{\"u}rzburg, Germany}, pages = {14 Seiten}, abstract = {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.}, language = {en} }