Computing Local Sensitivities of Counting Queries with Joins

04/09/2020
by   Yuchao Tao, et al.
0

Local sensitivity of a query Q given a database instance D, i.e. how much the output Q(D) changes when a tuple is added to D or deleted from D, has many applications including query analysis, outlier detection, and in differential privacy. However, it is NP-hard to find local sensitivity of a conjunctive query in terms of the size of the query, even for the class of acyclic queries. Although the complexity is polynomial when the query size is fixed, the naive algorithms are not efficient for large databases and queries involving multiple joins. In this paper, we present a novel approach to compute local sensitivity of counting queries involving join operations by tracking and summarizing tuple sensitivities – the maximum change a tuple can cause in the query result when it is added or removed. We give algorithms for the sensitivity problem for full acyclic join queries using join trees, that run in polynomial time in both the size of the database and query for an interesting sub-class of queries, which we call 'doubly acyclic queries' that include path queries, and in polynomial time in combined complexity when the maximum degree in the join tree is bounded. Our algorithms can be extended to certain non-acyclic queries using generalized hypertree decompositions. We evaluate our approach experimentally, and show applications of our algorithms to obtain better results for differential privacy by orders of magnitude.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
04/19/2023

Sensitivity estimation for differentially private query processing

Differential privacy has become a popular privacy-preserving method in d...
research
09/19/2021

Making the Most of Parallel Composition in Differential Privacy

We show that the `optimal' use of the parallel composition theorem corre...
research
12/07/2020

Local Dampening: Differential Privacy for Non-numeric Queries via Local Sensitivity

Differential privacy is the state-of-the-art formal definition for data ...
research
05/23/2019

Conjunctive Queries with Theta Joins Under Updates

Modern application domains such as Composite Event Recognition (CER) and...
research
07/23/2019

Generalized Deletion Propagation on Counting Conjunctive Query Answers

We investigate the computational complexity of minimizing the source sid...
research
06/21/2019

Learning to Sample: Counting with Complex Queries

In this paper we present a suite of methods to efficiently estimate coun...
research
05/25/2023

Efficient Computation of Quantiles over Joins

We present efficient algorithms for Quantile Join Queries, abbreviated a...

Please sign up or login with your details

Forgot password? Click here to reset