Conjunctive queries with inequalities under updates

Publikation: Beitrag in FachzeitschriftKonferenzartikelBeigetragenBegutachtung

Beitragende

Abstract

Modern application domains such as Composite Event Recognition (CER) and real-time Analytics require the ability to dynamically refresh query results under high update rates. Traditional approaches to this problem are based either on the materialization of subresults (to avoid their recomputation) or on the recomputation of subresults (to avoid the space overhead of materialization). Both techniques have recently been shown suboptimal: instead of materializing results and subresults, one can maintain a data structure that supports efficient maintenance under updates and can quickly enumerate the full query output, as well as the changes produced under single updates. Unfortunately, these data structures have been developed only for aggregate-join queries composed of equi-joins, limiting their applicability in domains such as CER where temporal joins are commonplace. In this paper, we present a new approach for dynamically evaluating queries with multi-way θ-joins under updates that is effective in avoiding both materialization and recomputation of results, while supporting a wide range of applications. To do this we generalize Dynamic Yannakakis, an algorithm for dynamically processing acyclic equi-join queries. In tandem, and of independent interest, we generalize the notions of acyclicity and free-connexity to arbitrary θ-joins. We instantiate our framework to the case where θ-joins are only composed of equalities and inequalities (<,≤,=, >,≥) and experimentally compare this algorithm, called IEDyn, to state of the art CER systems as well as incremental view maintenance engines. IEDyn performs consistently better than the competitor systems with up to two orders of magnitude improvements in both time and memory consumption.

Details

OriginalspracheEnglisch
Aufsatznummer7
Seiten (von - bis)733-745
Seitenumfang13
FachzeitschriftProceedings of the VLDB Endowment
Jahrgang11
Ausgabenummer7
PublikationsstatusVeröffentlicht - 2018
Peer-Review-StatusJa

Konferenz

Titel44th International Conference on Very Large Data Bases, VLDB 2018
Dauer27 - 31 August 2018
StadtRio de Janeiro
LandBrasilien

Externe IDs

Scopus 85058009208
ORCID /0000-0001-8107-2775/work/142253503

Schlagworte