Navigation auf zora.uzh.ch

Search ZORA

ZORA (Zurich Open Repository and Archive)

Migration von ZORA auf die Software DSpace

ZORA will change to a new software on 8th September 2025. Please note: deadline for new submissions is 21th July 2025!

Information & dates for training courses can be found here: Information on Software Migration.

Query Results over Ongoing Databases that Remain Valid as Time Passes By

Mülle, Yvonne; Böhlen, Michael Hanspeter (2020). Query Results over Ongoing Databases that Remain Valid as Time Passes By. In: 36th IEEE International Conference on Data Engineering, ICDE 2020April 20-24, 2020, Dallas, TX, USA, 20 April 2020 - 24 April 2020. IEEE, 1429-1440.

Abstract

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.

Additional indexing

Item Type:Conference or Workshop Item (Paper), refereed, original work
Communities & Collections:03 Faculty of Economics > Department of Informatics
Dewey Decimal Classification:000 Computer science, knowledge & systems
Scopus Subject Areas:Physical Sciences > Software
Physical Sciences > Signal Processing
Physical Sciences > Information Systems
Scope:Discipline-based scholarship (basic research)
Language:English
Event End Date:24 April 2020
Deposited On:01 Mar 2021 08:22
Last Modified:08 Jun 2025 03:40
Publisher:IEEE
OA Status:Green
Publisher DOI:https://doi.org/10.1109/ICDE48307.2020.00127
Other Identification Number:merlin-id:20731
Download PDF  'Query Results over Ongoing Databases that Remain Valid as Time Passes By'.
Preview
  • Content: Published Version

Metadata Export

Statistics

Citations

Dimensions.ai Metrics
1 citation in Web of Science®
1 citation in Scopus®
Google Scholar™

Altmetrics

Downloads

82 downloads since deposited on 01 Mar 2021
25 downloads since 12 months
Detailed statistics

Authors, Affiliations, Collaborations

Similar Publications