Modern trends in data collection are bringing current mainstream techniques for database query processing to their limits. Consequently, various novel approaches for efficient query processing are being actively studied. One such approach is based on hypertree decompositions (HDs), which have been shown to carry great potential to process complex queries more efficiently and with stronger theoretical guarantees. However, using HDs for query execution relies on the difficult task of computing decompositions of the query structure, which guides the efficient execution of the query. From theoretical results we know that the performance of purely sequential methods is inherently limited, yet the problem is susceptible to parallelisation. In this paper we propose the first algorithm for computing hypertree decompositions that is well-suited for parallelisation. The proposed algorithm log-k-decomp requires only a logarithmic number of recursion levels and additionally allows for highly parallelised pruning of the search space by restriction to balanced separators. We provide detailed experimental evaluation over the HyperBench benchmark and demonstrate that our approach is highly effective especially for complex queries.
翻译:现代数据收集趋势正在将当前数据库查询处理的主流技术提高到极限,因此,正在积极研究各种高效查询处理的新办法,其中一种办法是基于超树分解法(HDs),这证明极树分解法极有可能更高效地处理复杂的查询,并具有更强的理论保障。然而,使用HDs进行查询执行取决于对查询结构进行计算分解的困难任务,这指导了查询的有效执行。根据理论结果,我们知道纯顺序方法的性能必然有限,但问题容易发生平行化。在本文件中,我们提出了计算极树分解法的首个算法,该算法非常适合平行化。提议的log-k-decomp只需要对数的递合率,并额外允许通过限制平衡的分隔器对搜索空间进行高度平行的剪裁。我们提供了对超贝辛基准的详细实验性评估,并表明我们的方法特别对复杂的查询非常有效。