English

Maintaining Triangle Queries under Updates

Databases 2020-04-09 v1

Abstract

We consider the problem of incrementally maintaining the triangle queries with arbitrary free variables under single-tuple updates to the input relations. We introduce an approach called IVMϵ^\epsilon that exhibits a trade-off between the update time, the space, and the delay for the enumeration of the query result, such that the update time ranges from the square root to linear in the database size while the delay ranges from constant to linear time. IVMϵ^\epsilon achieves Pareto worst-case optimality in the update-delay space conditioned on the Online Matrix-Vector Multiplication conjecture. It is strongly Pareto optimal for the triangle queries with zero or three free variables and weakly Pareto optimal for the triangle queries with one or two free variables.

Cite

@article{arxiv.2004.03716,
  title  = {Maintaining Triangle Queries under Updates},
  author = {Ahmet Kara and Milos Nikolic and Hung Q. Ngo and Dan Olteanu and Haozhe Zhang},
  journal= {arXiv preprint arXiv:2004.03716},
  year   = {2020}
}

Comments

47 pages, 18 figures

R2 v1 2026-06-23T14:43:36.077Z