Not logged in.

Contribution Details

Type Conference or Workshop Paper
Scope Discipline-based scholarship
Published in Proceedings Yes
Title Query Results over Ongoing Databases that Remain Valid as Time Passes By
Organization Unit
Authors
  • Yvonne Mülle
  • Michael Hanspeter Böhlen
Presentation Type paper
Item Subtype Original Work
Refereed Yes
Status Published in final form
Language
  • English
Page Range 1429 - 1440
Event Title 36th IEEE International Conference on Data Engineering, ICDE 2020April 20-24, 2020
Event Type conference
Event Location Dallas, TX, USA
Event Start Date April 20 - 2020
Event End Date April 24 - 2020
Publisher IEEE
Abstract Text Ongoing time point now is used to state that a tuple is valid from the start point onward. For database systems ongoing time points have far-reaching implications since they change continuously as time passes by. State-of-the-art approaches deal with ongoing time points by instantiating them to the reference time. The instantiation yields query results that are only valid at the chosen time and get invalidated as time passes by. We propose a solution that keeps ongoing time points uninstantiated during query processing. We do so by evaluating predicates and functions at all possible reference times. This renders query results independent of a specific reference time and yields results that remain valid as time passes by. As query results, we propose ongoing relations that include a reference time attribute. The value of the reference time attribute is restricted by predicates and functions on ongoing attributes. We describe and evaluate an efficient implementation of ongoing data types and operations in PostgreSQL.
Digital Object Identifier 10.1109/ICDE48307.2020.00127
Other Identification Number merlin-id:20731
PDF File Download from ZORA
Export BibTeX
EP3 XML (ZORA)