Efficient Execution of SPARQL Queries with OPTIONAL and UNION Expressions

03/24/2023
by   Lei Zou, et al.
0

The proliferation of RDF datasets has resulted in studies focusing on optimizing SPARQL query processing. Most existing work focuses on basic graph patterns (BGPs) and ignores other vital operators in SPARQL, such as UNION and OPTIONAL. SPARQL queries with these operators, which we abbreviate as SPARQL-UO, pose serious query plan generation challenges. In this paper, we propose techniques for executing SPARQL-UO queries using BGP execution as a building block, based on a novel BGP-based Evaluation (BE)-Tree representation of query plans. On top of this, we propose a series of cost-driven BE-tree transformations to generate more efficient plans by reducing the search space and intermediate result sizes, and a candidate pruning technique that further enhances efficiency at query time. Experiments confirm that our method outperforms the state-of-the-art by orders of magnitude.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
05/17/2017

The Odyssey Approach for Optimizing Federated SPARQL Queries

Answering queries over a federation of SPARQL endpoints requires combini...
research
01/21/2018

Learning to Speed Up Query Planning in Graph Databases

Querying graph structured data is a fundamental operation that enables i...
research
04/17/2018

Heuristic and Cost-based Optimization for Diverse Provenance Tasks

A well-established technique for capturing database provenance as annota...
research
05/03/2023

MaskSearch: Querying Image Masks at Scale

Machine learning tasks over image databases often generate masks that an...
research
04/28/2021

Fast Parallel Hypertree Decompositions in Logarithmic Recursion Depth

Modern trends in data collection are bringing current mainstream techniq...
research
03/20/2023

Less is More: Towards Lightweight Cost Estimator for Database Systems

We present FasCo, a simple yet effective learning-based estimator for th...
research
02/04/2020

Using Positional Sequence Patterns to Estimate the Selectivity of SQL LIKE Queries

With the dramatic increase in the amount of the text-based data which co...

Please sign up or login with your details

Forgot password? Click here to reset