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.

Grandi, F., Mandreoli, F., Martoglia, R., Penzo, W. (2017). A Relational Algebra for Streaming Tables Living in a Temporal Database World. Saarbrücken/Wadern : Dagstuhl Publishing [10.4230/LIPIcs.TIME.2017.15].

A Relational Algebra for Streaming Tables Living in a Temporal Database World

GRANDI, FABIO;PENZO, WILMA
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)
15:1
15:17
Grandi, F., Mandreoli, F., Martoglia, R., Penzo, W. (2017). A Relational Algebra for Streaming Tables Living in a Temporal Database World. Saarbrücken/Wadern : Dagstuhl Publishing [10.4230/LIPIcs.TIME.2017.15].
Grandi, Fabio; Mandreoli, Federica; Martoglia, Riccardo; Penzo, Wilma
File in questo prodotto:
Eventuali allegati, non sono esposti

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11585/608095
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus ND
  • ???jsp.display-item.citation.isi??? ND
social impact