The recently introduced streaming table concept, a fully native representation of streaming data inside a DBMS, enabled modern data-intensive applications with one-time queries (OTQs) and continuous queries (CQs) capabilities on both streaming and standard relational tables. In this paper, we fully acknowledge the temporal nature of streaming tables and we propose to go one step further and integrate them in a temporal DBMS context, where time management is native. Our aim is to break the traditional barrier between the streaming and the temporal worlds, offering complete interoperability between streams and temporal data. To this end, we present a continuous temporal algebra supporting both OTQs and CQs seamlessly on streaming, standard and temporal relational tables. We further show how the transition from continuous to one-time semantics can be managed by defining suitable translation rules, which can also be used as a basis for the implementation of the proposed continuous algebra in a temporal DBMS.

A relational algebra for streaming tables living in a temporal database world / Grandi, Fabio; Mandreoli, Federica; Martoglia, Riccardo; Penzo, Wilma. - 90:(2017). (Intervento presentato al convegno 24th International Symposium on Temporal Representation and Reasoning, TIME 2017 tenutosi a Mons; Belgium nel 2017) [10.4230/LIPIcs.TIME.2017.15].

A relational algebra for streaming tables living in a temporal database world

Mandreoli, Federica;Martoglia, Riccardo;
2017

Abstract

The recently introduced streaming table concept, a fully native representation of streaming data inside a DBMS, enabled modern data-intensive applications with one-time queries (OTQs) and continuous queries (CQs) capabilities on both streaming and standard relational tables. In this paper, we fully acknowledge the temporal nature of streaming tables and we propose to go one step further and integrate them in a temporal DBMS context, where time management is native. Our aim is to break the traditional barrier between the streaming and the temporal worlds, offering complete interoperability between streams and temporal data. To this end, we present a continuous temporal algebra supporting both OTQs and CQs seamlessly on streaming, standard and temporal relational tables. We further show how the transition from continuous to one-time semantics can be managed by defining suitable translation rules, which can also be used as a basis for the implementation of the proposed continuous algebra in a temporal DBMS.
2017
24th International Symposium on Temporal Representation and Reasoning, TIME 2017
Mons; Belgium
2017
90
Grandi, Fabio; Mandreoli, Federica; Martoglia, Riccardo; Penzo, Wilma
A relational algebra for streaming tables living in a temporal database world / Grandi, Fabio; Mandreoli, Federica; Martoglia, Riccardo; Penzo, Wilma. - 90:(2017). (Intervento presentato al convegno 24th International Symposium on Temporal Representation and Reasoning, TIME 2017 tenutosi a Mons; Belgium nel 2017) [10.4230/LIPIcs.TIME.2017.15].
File in questo prodotto:
File Dimensione Formato  
p15-grandi.pdf

Open access

Tipologia: Versione pubblicata dall'editore
Dimensione 580.9 kB
Formato Adobe PDF
580.9 kB Adobe PDF Visualizza/Apri
Pubblicazioni consigliate

Licenza Creative Commons
I metadati presenti in IRIS UNIMORE sono rilasciati con licenza Creative Commons CC0 1.0 Universal, mentre i file delle pubblicazioni sono rilasciati con licenza Attribuzione 4.0 Internazionale (CC BY 4.0), salvo diversa indicazione.
In caso di violazione di copyright, contattare Supporto Iris

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11380/1148308
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 3
  • ???jsp.display-item.citation.isi??? ND
social impact