SHARq: sharing recursive queries in relational databases

LC Scabora, G Spadon, MT Cazzolato…�- Proceedings of the 36th�…, 2021 - dl.acm.org
Proceedings of the 36th Annual ACM Symposium on Applied Computing, 2021dl.acm.org
Processing navigational graph-like queries in relational databases requires executing
several recursive join operations, which are computationally costly. However, when the
need for graph-like queries arises, applications often execute a sequence of related queries
in a single session. We argue that it is possible to reduce the total cost of a set of related
queries, by expanding individual intermediate results and sharing them among multiple
queries. SHARq is our framework that enables sharing intermediate results of the common�…
Processing navigational graph-like queries in relational databases requires executing several recursive join operations, which are computationally costly. However, when the need for graph-like queries arises, applications often execute a sequence of related queries in a single session. We argue that it is possible to reduce the total cost of a set of related queries, by expanding individual intermediate results and sharing them among multiple queries. SHARq is our framework that enables sharing intermediate results of the common graph-like queries Single-Source Shortest Paths (SSSP), Connected Components (CC), and PageRank (PR). Our solution prepares result tables expanded with additional columns to store partial results of graph-like query combinations, such as multiple SSSP, or a sequence of queries comprising SSSP, CC, and PR. Experimental results on 9 datasets show query speedups of up to ten times when combining multiple SSSP queries, and up to two times when combining SSSP, CC, and PR queries. The results reveal a significant reduction in the query time, providing timely results for analyses relying on multiple navigational graph-like queries.
ACM Digital Library
Showing the best result for this search. See all results