Space-Time Tradeoffs for Answering Boolean Conjunctive Queries

09/22/2021
by   Shaleen Deep, et al.
0

In this paper, we investigate space-time tradeoffs for answering boolean conjunctive queries. The goal is to create a data structure in an initial preprocessing phase and use it for answering (multiple) queries. Previous work has developed data structures that trade off space usage for answering time and has proved conditional space lower bounds for queries of practical interest such as the path and triangle query. However, most of these results cater to only those queries, lack a comprehensive framework, and are not generalizable. The isolated treatment of these queries also fails to utilize the connections with extensive research on related problems within the database community. The key insight in this work is to exploit the formalism of relational algebra by casting the problems as answering join queries over a relational database. Using the notion of boolean adorned queries and access patterns, we propose a unified framework that captures several widely studied algorithmic problems. Our main contribution is three-fold. First, we present an algorithm that recovers existing space-time tradeoffs for several problems. The algorithm is based on an application of the join size bound to capture the space usage of our data structure. We combine our data structure with query decomposition techniques to further improve the tradeoffs and show that it is readily extensible to queries with negation. Second, we falsify two conjectures proposed in the existing literature that relates to the space-time lower bound for path queries and triangle detection by proposing an unexpectedly better algorithm. This result opens a new avenue for improving several algorithmic results that have so far been assumed to be (conditionally) optimal. Finally, we prove new conditional space-time lower bounds for star and path queries.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
04/13/2023

Space-Time Tradeoffs for Conjunctive Queries with Access Patterns

In this paper, we investigate space-time tradeoffs for answering conjunc...
research
02/13/2019

Space-Efficient Data Structures for Lattices

A lattice is a partially-ordered set in which every pair of elements has...
research
03/01/2023

Towards Space Efficient Two-Point Shortest Path Queries in a Polygonal Domain

We devise a data structure that can answer shortest path queries for two...
research
08/13/2022

Intersection Searching amid Tetrahedra in Four Dimensions

We develop data structures for intersection queries in four dimensions t...
research
12/22/2018

On Functional Aggregate Queries with Additive Inequalities

Motivated by fundamental applications in databases and relational machin...
research
01/29/2020

Optimal and Perfectly Parallel Algorithms for On-demand Data-flow Analysis

Interprocedural data-flow analyses form an expressive and useful paradig...
research
09/18/2017

Compressed Representations of Conjunctive Query Results

Relational queries, and in particular join queries, often generate large...

Please sign up or login with your details

Forgot password? Click here to reset