Skip to main content
Journal cover image

Differentially private explanations for aggregate query answers

Publication ,  Journal Article
Tao, Y; Gilad, A; Machanavajjhala, A; Roy, S
Published in: VLDB Journal
March 1, 2025

Differential privacy (DP) is the state-of-the-art and rigorous notion of privacy for answering aggregate database queries while preserving the privacy of sensitive information in the data. In today’s era of data analysis, however, it poses new challenges for users to understand the trends and anomalies observed in the query results: Is the unexpected answer due to the data itself, or is it due to the extra noise that must be added to preserve DP? In the second case, even the observation made by the users on query results may be wrong. In the first case, can we still mine interesting explanations from the sensitive data while protecting its privacy? To address these challenges, we present a three-phase framework DPXPlain, which is the first system to the best of our knowledge for explaining group-by aggregate query answers with DP. In its three phases, DPXPlain (a) answers a group-by aggregate query with DP, (b) allows users to compare aggregate values of two groups and with high probability assesses whether this comparison holds or is flipped by the DP noise, and (c) eventually provides an explanation table containing the approximately ‘top-k’ explanation predicates along with their relative influences and ranks in the form of confidence intervals, while guaranteeing DP in all steps. We perform an extensive experimental analysis of DPXPlain with multiple use-cases on real and synthetic data showing that DPXPlain efficiently provides insightful explanations with good accuracy and utility.

Duke Scholars

Published In

VLDB Journal

DOI

EISSN

0949-877X

ISSN

1066-8888

Publication Date

March 1, 2025

Volume

34

Issue

2

Related Subject Headings

  • Information Systems
  • 4605 Data management and data science
  • 0806 Information Systems
  • 0805 Distributed Computing
  • 0804 Data Format
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Tao, Y., Gilad, A., Machanavajjhala, A., & Roy, S. (2025). Differentially private explanations for aggregate query answers. VLDB Journal, 34(2). https://doi.org/10.1007/s00778-024-00895-4
Tao, Y., A. Gilad, A. Machanavajjhala, and S. Roy. “Differentially private explanations for aggregate query answers.” VLDB Journal 34, no. 2 (March 1, 2025). https://doi.org/10.1007/s00778-024-00895-4.
Tao Y, Gilad A, Machanavajjhala A, Roy S. Differentially private explanations for aggregate query answers. VLDB Journal. 2025 Mar 1;34(2).
Tao, Y., et al. “Differentially private explanations for aggregate query answers.” VLDB Journal, vol. 34, no. 2, Mar. 2025. Scopus, doi:10.1007/s00778-024-00895-4.
Tao Y, Gilad A, Machanavajjhala A, Roy S. Differentially private explanations for aggregate query answers. VLDB Journal. 2025 Mar 1;34(2).
Journal cover image

Published In

VLDB Journal

DOI

EISSN

0949-877X

ISSN

1066-8888

Publication Date

March 1, 2025

Volume

34

Issue

2

Related Subject Headings

  • Information Systems
  • 4605 Data management and data science
  • 0806 Information Systems
  • 0805 Distributed Computing
  • 0804 Data Format