Skip to main content

R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys

Publication ,  Journal Article
Dong, W; Fang, J; Yi, K; Tao, Y; Machanavajjhala, A
Published in: SIGMOD Record
June 8, 2023

Answering SPJA queries under differential privacy (DP), including graph pattern counting under node-DP as an important special case, has received considerable attention in recent years. The dual challenge of foreign-key constraints and self-joins is particularly tricky to deal with, and no existing DP mechanisms can correctly handle both. For the special case of graph pattern counting under node-DP, the existing mechanisms are correct (i.e., satisfy DP), but they do not offer nontrivial utility guarantees or are very complicated and costly. In this paper, we propose the first DP mechanism for answering arbitrary SPJA queries in a database with foreign-key constraints. Meanwhile, it achieves a fairly strong notion of optimality, which can be considered as a small and natural relaxation of instance optimality. Finally, our mechanism is simple enough that it can be easily implemented on top of any RDBMS and an LP solver. Experimental results show that it offers order-of-magnitude improvements in terms of utility over existing techniques, even those specifically designed for graph pattern counting.

Duke Scholars

Published In

SIGMOD Record

DOI

ISSN

0163-5808

Publication Date

June 8, 2023

Volume

52

Issue

1

Start / End Page

115 / 123

Related Subject Headings

  • Information Systems
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Dong, W., Fang, J., Yi, K., Tao, Y., & Machanavajjhala, A. (2023). R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys. SIGMOD Record, 52(1), 115–123. https://doi.org/10.1145/3604437.3604462
Dong, W., J. Fang, K. Yi, Y. Tao, and A. Machanavajjhala. “R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys.” SIGMOD Record 52, no. 1 (June 8, 2023): 115–23. https://doi.org/10.1145/3604437.3604462.
Dong W, Fang J, Yi K, Tao Y, Machanavajjhala A. R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys. SIGMOD Record. 2023 Jun 8;52(1):115–23.
Dong, W., et al. “R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys.” SIGMOD Record, vol. 52, no. 1, June 2023, pp. 115–23. Scopus, doi:10.1145/3604437.3604462.
Dong W, Fang J, Yi K, Tao Y, Machanavajjhala A. R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys. SIGMOD Record. 2023 Jun 8;52(1):115–123.

Published In

SIGMOD Record

DOI

ISSN

0163-5808

Publication Date

June 8, 2023

Volume

52

Issue

1

Start / End Page

115 / 123

Related Subject Headings

  • Information Systems