This paper shows how to uplift wco join algorithms so as to incorporate such filtering natively, improving efficiency and demonstrates the superiority of this approach by extending the Ring -- a compact index that provides wco resolution of BGPs within almost no extra space on top of the graph -- so as to handle property graphs using new techniques while retaining compactness.
Abstract
Worst-case-optimal (wco) join algorithms have demonstrated their power -- in both theory and practice -- to efficiently solve complex Basic Graph Patterns (BGPs). Modern graph query languages, such as SPARQL and GQL, have BGPs at their core, but also have a wide range of other features, including filters (aka.\ selections). Such conditions are typically handled via pre- or post-filtering, before or after processing the BGPs. In this paper we show how to uplift wco join algorithms so as to incorporate such filtering natively, improving efficiency. We demonstrate the superiority of this approach by extending the \textit{Ring} -- a compact index that provides wco resolution of BGPs within almost no extra space on top of the graph -- so as to handle property graphs using our new techniques while retaining compactness. We implement this extension and experimentally show that it outperforms various baseline systems.
This paper combines Qdags with a Generalized Hypertree Decomposition of the query, into subqueries with fewer variables, and implements algorithms that find the optimal GHD according to the AGM bounds of the subqueries and the specificities of the Qdag cost model.
Diego Arroyuelo, Gabriel Carmona, Gonzalo Navarro et al.· 0 citations
This tutorial revisits Yannakakis algorithm (YA) as a central example of how database theory can guide practical query processing and discusses how these ideas extend to query optimization and general queries beyond the multi-way joins.
Paraschos Koutris, Stijn Vansummeren, Qichen Wang et al.· Proceedings of the VLDB Endo...· 0 citations
It is proved that Minimal-to-Maximal Conversion Search is in fact not output-polynomial and the lower bound construction motivates a more detailed analysis of how certain heuristic choices in the algorithm design affect the running time.
This study analyzes the practical considerations for WCOJ adoption across three core query engine layers: interpretation, optimization, and execution, before extending to distributed environments and indicates that the primary bottlenecks delaying widespread adoption are architectural rather than algorithmic.
Ayoub Berdai, Kawtar Younsi Dahbi, D. Chiadmi et al.· International Journal of Adv...· 0 citations
SKYPQ is demonstrated, a system that employs a novel, dominance-based data reduction method for package queries under updates that maintains a K-skyband index, a small, correctness-preserving subset of candidates, and applies a resolve checker to skip re-optimization when updates cannot affect the optimal package.
Vasileios Vittis, Azza Abouzied, Peter J. Haas et al.· Proceedings of the VLDB Endo...· 0 citations
This paper shows how to enhance this approach through the addition of parallelism, thereby allowing even larger problem instances to be solved in practice, and demonstrates the potential of parallelism when applied to the bounded tree search phase of FPT algorithms.
F. Dehne, A. Rau-Chaplin, U. Stege et al.· 0 citations
We use cookies to run the site and, with your consent, for analytics and to show ads.
See our Cookie Policy.