English

Beyond Worst-Case Analysis for Joins with Minesweeper

Databases 2014-04-01 v5

Abstract

We describe a new algorithm, Minesweeper, that is able to satisfy stronger runtime guarantees than previous join algorithms (colloquially, `beyond worst-case guarantees') for data in indexed search trees. Our first contribution is developing a framework to measure this stronger notion of complexity, which we call {\it certificate complexity}, that extends notions of Barbay et al. and Demaine et al.; a certificate is a set of propositional formulae that certifies that the output is correct. This notion captures a natural class of join algorithms. In addition, the certificate allows us to define a strictly stronger notion of runtime complexity than traditional worst-case guarantees. Our second contribution is to develop a dichotomy theorem for the certificate-based notion of complexity. Roughly, we show that Minesweeper evaluates β\beta-acyclic queries in time linear in the certificate plus the output size, while for any β\beta-cyclic query there is some instance that takes superlinear time in the certificate (and for which the output is no larger than the certificate size). We also extend our certificate-complexity analysis to queries with bounded treewidth and the triangle query.

Keywords

Cite

@article{arxiv.1302.0914,
  title  = {Beyond Worst-Case Analysis for Joins with Minesweeper},
  author = {Hung Q. Ngo and Dung T. Nguyen and Christopher Ré and Atri Rudra},
  journal= {arXiv preprint arXiv:1302.0914},
  year   = {2014}
}

Comments

[This is the full version of our PODS'2014 paper.]

R2 v1 2026-06-21T23:20:50.154Z