Beyond Worst-case Analysis for Joins with Minesweeper

被引:34
作者
Ngo, Hung Q. [1 ]
Nguyen, Dung T. [1 ]
Re, Christopher [1 ]
Rudra, Atri [1 ]
机构
[1] SUNY Buffalo, Buffalo, NY 14260 USA
来源
PODS'14: PROCEEDINGS OF THE 33RD ACM SIGMOD-SIGACT-SIGART SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS | 2014年
关键词
Join Algorithms; Adaptive Algorithm; Instance Optimality; Certificate; Beta-acyclic queries; Bounded Treewidth; Triangle query; ALGORITHMS; BOUNDS;
D O I
10.1145/2594538.2594547
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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 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. We present empirical results that certificates can be much smaller than the input size, which suggests that ideas in minesweeper might lead to faster algorithms in practice.
引用
收藏
页码:234 / 245
页数:12
相关论文
共 52 条
[1]  
Abiteboul S., 1995, Foundations of databases, V8
[2]  
ADLER I., 2007, EUROPEAN J COMBIN, V28
[3]  
AFSHANI P, 2009, FOCS, P129, DOI DOI 10.1109/FOCS.2009.34
[4]   SELF-IMPROVING ALGORITHMS [J].
Ailon, Nir ;
Chazelle, Bernard ;
Clarkson, Kenneth L. ;
Liu, Ding ;
Mulzer, Wolfgang ;
Seshadhri, C. .
SIAM JOURNAL ON COMPUTING, 2011, 40 (02) :350-375
[5]  
ALON N., 1981, ISRAEL J MATH, V38
[6]  
[Anonymous], 2011, P INT C WORLD WID WE, DOI DOI 10.1145/1963405.1963491
[7]  
[Anonymous], 2012, INFORM PROCESSING LE, V112
[8]  
[Anonymous], 1972, SIAM J COMPUT, DOI 10.1137/0201004
[9]  
[Anonymous], 1985, GRAPHS HYPERGRAPHS
[10]  
[Anonymous], 1977, STOC