Differentially Private SQL with Bounded User Contribution
Not on the map. Why?
Abstract (arXiv)
Differential privacy (DP) provides formal guarantees that the output of a database query does not reveal too much information about any individual present in the database. While many differentially private algorithms have been proposed in the scientific literature, there are only a few end-to-end implementations of differentially private query engines. Crucially, existing systems assume that each individual is associated with at most one database record, which is unrealistic in practice. We propose a generic and scalable method to perform differentially private aggregations on databases, even when individuals can each be associated with arbitrarily many rows. We express this method as an operator in relational algebra, and implement it in an SQL engine. To validate this system, we test the utility of typical queries on industry benchmarks, and verify its correctness with a stochastic test framework we developed. We highlight the promises and pitfalls learned when deploying such a system in practice, and we publish its core components as open-source software.
Key facts. Cited by 27 papers in the map (data through 7 Oct 2026). First posted on arXiv 4 Sep 2019.
Builds on
No reference list yet.
Built on by
Citing papers per year: 2021: 5; 2022: 5; 2023: 7; 2024: 4; 2025: 2; 2026: 4.
27 papers.
Sort:
By area:
- 2021Learning with User-Level Privacycited by 72
- 2021Covariance-Aware Private Mean Estimation Without Private Covariance Estimationcited by 46
- 2023From Robustness to Privacy and Backcited by 27
- 2021Tight and Robust Private Mean Estimation with Few Userscited by 26
- 2024Mind the Privacy Unit! User-Level Differential Privacy for Language Model Fine-Tuningcited by 21
- 2022OpBoost: A Vertical Federated Tree Boosting Framework Based on Order-Preserving Desensitizationcited by 12
- 2021User-Level Private Learning via Correlated Samplingcited by 9
- 2023ULDP-FL: Federated Learning with Across Silo User-Level Differential Privacycited by 9
- 2023Mean estimation in the add-remove model of differential privacycited by 9
- 2022Private Quantiles Estimation in the Presence of Atomscited by 5
- 2022Algorithms for bounding contribution for histogram estimation under user-level privacycited by 4
- 2021DP-XGBoost: Private Machine Learning at Scalecited by 3
15 more
- 2023Multi-Task Differential Privacy Under Distribution Skewcited by 3
- 2022Answering Private Linear Queries Adaptively using the Common Mechanismcited by 2
- 2023ResidualPlanner+: a scalable matrix mechanism for marginals and beyondcited by 2
- 2023Differentially Private Heavy Hitter Detection using Federated Analyticscited by 2
- 2024The Correlated Gaussian Sparse Histogram Mechanismcited by 2
- 2025A Case for Computing on Unstructured Datacited by 2
- 2022DPack: Efficiency-Oriented Privacy Budget Schedulingcited by 1
- 2024Qrlew: Rewriting SQL into Differentially Private SQLcited by 1
- 2024Membership Inference Attacks and Privacy in Topic Modelingcited by 1
- 2025Optimal Variance and Covariance Estimation under Differential Privacy in the Add-Remove Model and Beyondcited by 1
- 2023Differentially Private Distributed Estimation and Learningcited by 0
- 2026DPSQL+: A Differentially Private SQL Library with a Minimum Frequency Rulecited by 0
- 2026Lumberjack: Better Differentially Private Random Forests through Heavy Hitter Detection in Treescited by 0
- 2026Certified in Theory, Broken in Practice: Assumption Gaps in Cryptographic Model Certificationcited by 0
- 2026Trustworthy Data- and ML-Ops for Intelligent Transportation Systems and Logisticscited by 0
- 2026Trustworthy Data- and ML-Ops for Intelligent Transportation Systems and Logistics1 Oct 2026
- 2026Certified in Theory, Broken in Practice: Assumption Gaps in Cryptographic Model Certification23 Jul 2026
- 2026Lumberjack: Better Differentially Private Random Forests through Heavy Hitter Detection in Trees21 May 2026
- 2026DPSQL+: A Differentially Private SQL Library with a Minimum Frequency Rule26 Feb 2026
- 2025A Case for Computing on Unstructured Data18 Sep 2025
- 2025Optimal Variance and Covariance Estimation under Differential Privacy in the Add-Remove Model and Beyond5 Sep 2025
- 2024The Correlated Gaussian Sparse Histogram Mechanism13 Dec 2024
- 2024Mind the Privacy Unit! User-Level Differential Privacy for Language Model Fine-Tuning20 Jun 2024
- 2024Membership Inference Attacks and Privacy in Topic Modeling7 Mar 2024
- 2024Qrlew: Rewriting SQL into Differentially Private SQL11 Jan 2024
- 2023Mean estimation in the add-remove model of differential privacy11 Dec 2023
- 2023ULDP-FL: Federated Learning with Across Silo User-Level Differential Privacy23 Aug 2023
15 more
- 2023Differentially Private Heavy Hitter Detection using Federated Analytics21 Jul 2023
- 2023Differentially Private Distributed Estimation and Learning28 Jun 2023
- 2023ResidualPlanner+: a scalable matrix mechanism for marginals and beyond14 May 2023
- 2023Multi-Task Differential Privacy Under Distribution Skew15 Feb 2023
- 2023From Robustness to Privacy and Back3 Feb 2023
- 2022DPack: Efficiency-Oriented Privacy Budget Scheduling26 Dec 2022
- 2022Answering Private Linear Queries Adaptively using the Common Mechanism30 Nov 2022
- 2022OpBoost: A Vertical Federated Tree Boosting Framework Based on Order-Preserving Desensitization4 Oct 2022
- 2022Algorithms for bounding contribution for histogram estimation under user-level privacy7 Jun 2022
- 2022Private Quantiles Estimation in the Presence of Atoms15 Feb 2022
- 2021DP-XGBoost: Private Machine Learning at Scale25 Oct 2021
- 2021Tight and Robust Private Mean Estimation with Few Users22 Oct 2021
- 2021User-Level Private Learning via Correlated Sampling21 Oct 2021
- 2021Covariance-Aware Private Mean Estimation Without Private Covariance Estimation24 Jun 2021
- 2021Learning with User-Level Privacy23 Feb 2021
- 2021Learning with User-Level Privacycited by 72
- 2021Covariance-Aware Private Mean Estimation Without Private Covariance Estimationcited by 46
- 2023From Robustness to Privacy and Backcited by 27
- 2021Tight and Robust Private Mean Estimation with Few Userscited by 26
- 2024Mind the Privacy Unit! User-Level Differential Privacy for Language Model Fine-Tuningcited by 21
- 2022OpBoost: A Vertical Federated Tree Boosting Framework Based on Order-Preserving Desensitizationcited by 12
- 2021User-Level Private Learning via Correlated Samplingcited by 9
- 2023ULDP-FL: Federated Learning with Across Silo User-Level Differential Privacycited by 9
- 2023Mean estimation in the add-remove model of differential privacycited by 9
- 2022Private Quantiles Estimation in the Presence of Atomscited by 5
- 2022Algorithms for bounding contribution for histogram estimation under user-level privacycited by 4
- 2021DP-XGBoost: Private Machine Learning at Scalecited by 3
12 most cited of 26 All 26 (JSON)
- 2026Trustworthy Data- and ML-Ops for Intelligent Transportation Systems and Logistics1 Oct 2026
- 2026Certified in Theory, Broken in Practice: Assumption Gaps in Cryptographic Model Certification23 Jul 2026
- 2026Lumberjack: Better Differentially Private Random Forests through Heavy Hitter Detection in Trees21 May 2026
- 2026DPSQL+: A Differentially Private SQL Library with a Minimum Frequency Rule26 Feb 2026
- 2025A Case for Computing on Unstructured Data18 Sep 2025
- 2025Optimal Variance and Covariance Estimation under Differential Privacy in the Add-Remove Model and Beyond5 Sep 2025
- 2024The Correlated Gaussian Sparse Histogram Mechanism13 Dec 2024
- 2024Mind the Privacy Unit! User-Level Differential Privacy for Language Model Fine-Tuning20 Jun 2024
- 2024Qrlew: Rewriting SQL into Differentially Private SQL11 Jan 2024
- 2023Mean estimation in the add-remove model of differential privacy11 Dec 2023
- 2023ULDP-FL: Federated Learning with Across Silo User-Level Differential Privacy23 Aug 2023
- 2023Differentially Private Heavy Hitter Detection using Federated Analytics21 Jul 2023
12 newest of 26 All 26 (JSON)