Towards a Dichotomy for Minimally Factorizing the Provenance of Self-Join Free Conjunctive Queries

05/29/2021
by   Neha Makhija, et al.
0

We consider the problem of finding the minimal-size factorization of the provenance of self-join-free conjunctive queries, i.e., we want to find an equivalent propositional formula that minimizes the number of variable occurrences. Our work is partly motivated from probabilistic inference where read-once formulas are known to allow exact PTIME solutions and non-read-once formulas allow approximate solutions with an error that depends on the number of repetitions of variables. We embark on the challenge of characterizing the data complexity of this problem and show its connection to the query resilience problem. While the problem is NP-complete in general, we develop an encoding as max-flow problem that is guaranteed to give the exact solution for several queries (and otherwise approximate minimizations). We show that our encoding is guaranteed to return a read-once factorization if it exists. Our problem and approach is a complete solution that naturally recovers exact solutions for all known PTIME cases, as well as identifying additional queries for which the problem can be solved in PTIME.

READ FULL TEXT
research
12/17/2022

A Unified Approach for Resilience and Causal Responsibility with Integer Linear Programming (ILP) and LP Relaxations

Resilience is one of the key algorithmic problems underlying various for...
research
07/02/2019

New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins

The resilience of a Boolean query is the minimum number of tuples that n...
research
08/25/2023

Discovering Dichotomies for Problems in Database Theory

Dichotomy theorems, which characterize the conditions under which a prob...
research
09/21/2022

Downward Self-Reducibility in TFNP

A problem is downward self-reducible if it can be solved efficiently giv...
research
12/17/2021

Counting Database Repairs Entailing a Query: The Case of Functional Dependencies

A key task in the context of consistent query answering is to count the ...
research
04/01/2019

A More General Theory of Static Approximations for Conjunctive Queries

Conjunctive query (CQ) evaluation is NP-complete, but becomes tractable ...
research
12/28/2020

Square-Cut Pizza Sharing is PPA-complete

We study the computational complexity of computing solutions for the squ...

Please sign up or login with your details

Forgot password? Click here to reset