Skip to main content

Computing Local Sensitivities of Counting Queries with Joins

Publication ,  Journal Article
Tao, Y; He, X; MacHanavajjhala, A; Roy, S
Published in: Proceedings of the ACM SIGMOD International Conference on Management of Data
June 14, 2020

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 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. 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 and show applications of our algorithms to obtain better results for differential privacy by orders of magnitude.

Duke Scholars

Altmetric Attention Stats
Dimensions Citation Stats

Published In

Proceedings of the ACM SIGMOD International Conference on Management of Data

DOI

ISSN

0730-8078

Publication Date

June 14, 2020

Start / End Page

479 / 494
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Tao, Y., He, X., MacHanavajjhala, A., & Roy, S. (2020). Computing Local Sensitivities of Counting Queries with Joins. Proceedings of the ACM SIGMOD International Conference on Management of Data, 479–494. https://doi.org/10.1145/3318464.3389762
Tao, Y., X. He, A. MacHanavajjhala, and S. Roy. “Computing Local Sensitivities of Counting Queries with Joins.” Proceedings of the ACM SIGMOD International Conference on Management of Data, June 14, 2020, 479–94. https://doi.org/10.1145/3318464.3389762.
Tao Y, He X, MacHanavajjhala A, Roy S. Computing Local Sensitivities of Counting Queries with Joins. Proceedings of the ACM SIGMOD International Conference on Management of Data. 2020 Jun 14;479–94.
Tao, Y., et al. “Computing Local Sensitivities of Counting Queries with Joins.” Proceedings of the ACM SIGMOD International Conference on Management of Data, June 2020, pp. 479–94. Scopus, doi:10.1145/3318464.3389762.
Tao Y, He X, MacHanavajjhala A, Roy S. Computing Local Sensitivities of Counting Queries with Joins. Proceedings of the ACM SIGMOD International Conference on Management of Data. 2020 Jun 14;479–494.

Published In

Proceedings of the ACM SIGMOD International Conference on Management of Data

DOI

ISSN

0730-8078

Publication Date

June 14, 2020

Start / End Page

479 / 494