DBScholar

Back to papers

PrivateSQL: A Differentially Private SQL Query Engine

Summary: PrivateSQL is an end-to-end differentially private SQL engine for multi-relational schemas, accounting for foreign-key constraints and selectively protected entities. Workload-tuned private multi-view synopses provide accurate counting queries under a fixed privacy budget. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hf16ae6e7b02ada84
Venue
VLDB
Year
2019
Pagerank
0.00011687052
Overall Rank
1,170 | 92.16%
DOI
10.14778/3342263.3342274
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{kotsogiannis_vldb19,
        title = {{PrivateSQL: A Differentially Private SQL Query Engine}},
        author = {Kotsogiannis, Ios and Tao, Yuchao and He, Xi and Fanaeepour, Maryam and Machanavajjhala, Ashwin and Hay, Michael and Miklau, Gerome},
        journal = {PVLDB},
        series = {{VLDB} '19},
        volume = {12},
        number = {11},
        pages = {1371--1384},
        doi = {10.14778/3342263.3342274},
        url = {https://doi.org/10.14778/3342263.3342274},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 53 citing papers.

Rank Citing Paper Year Venue Pagerank
2,465 Towards Practical Oblivious Join 2022 SIGMOD 8.4071729e-05
2,497 Computing Local Sensitivities of Counting Queries with Joins 2020 SIGMOD 8.365674e-05
2,877 CryptEpsilon: Crypto-Assisted Differential Privacy on Untrusted Servers 2020 SIGMOD 7.8955405e-05
3,304 Kamino: Constraint-Aware Differentially Private Data Synthesis 2021 VLDB 7.4211095e-05
3,915 Adore: Differentially Oblivious Relational Database Operators 2023 VLDB 6.908248e-05
4,518 R2T: Instance-optimal Truncation for Differentially Private Query Evaluation with Foreign Keys 2022 SIGMOD 6.551704e-05
4,964 PrivLava: Synthesizing Relational Data with Foreign Keys under Differential Privacy 2023 SIGMOD 6.3234288e-05
5,076 IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022 SIGMOD 6.2720607e-05
5,740 Privacy Amplification via Shuffling: Unified, Simplified, and Tightened 2024 VLDB 5.9939789e-05
6,323 Longshot: Indexing Growing Databases using MPC and Differential Privacy 2023 VLDB 5.7958256e-05
6,520 DProvDB: Differentially Private Query Processing with Multi-Analyst Provenance 2023 SIGMOD 5.7391796e-05
6,538 PreFair: Privately Generating Justifiably Fair Synthetic Data 2023 VLDB 5.7352151e-05
6,677 Better than Composition: How to Answer Multiple Relational Queries under Differential Privacy 2023 SIGMOD 5.6958509e-05
6,823 Residual Sensitivity for Differentially Private Multi-Way Joins 2021 SIGMOD 5.656894e-05
6,916 Synthesizing Linked Data Under Cardinality and Integrity Constraints 2021 SIGMOD 5.6320169e-05
7,425 Compliant Geo-distributed Query Processing 2021 SIGMOD 5.5147937e-05
7,463 A Nearly Instance-optimal Differentially Private Mechanism for Conjunctive Queries 2022 PODS 5.505863e-05
7,506 DPGraph: A Benchmark Platform for Differentially Private Graph Analysis 2021 SIGMOD 5.4920201e-05
7,626 Privacy Amplification by Sampling under User-level Differential Privacy 2024 SIGMOD 5.4657865e-05
7,666 Disclosure-Compliant Query Answering 2024 SIGMOD 5.4565877e-05
7,815 Budget Sharing for Multi-Analyst Differential Privacy 2021 VLDB 5.4310381e-05
8,030 Differentially Private Data Release over Multiple Tables 2023 PODS 5.3871505e-05
8,103 Differentially Private Data Generation with Missing Data 2024 VLDB 5.3739121e-05
8,106 Saibot: A Differentially Private Data Search Platform 2023 VLDB 5.3739121e-05
8,351 Continual Observation of Joins under Differential Privacy 2024 SIGMOD 5.3325743e-05
8,385 Local Dampening: Differential Privacy for Non-numeric Queries via Local Sensitivity 2021 VLDB 5.3259308e-05
8,500 DP-Sync: Hiding Update Patterns in Secure Outsourced Databases with Differential Privacy 2021 SIGMOD 5.3131213e-05
8,910 DPXPlain: Privately Explaining Aggregate Query Answers 2023 VLDB 5.2369069e-05
9,016 Cache Me If You Can: Accuracy-Aware Inference Engine for Differentially Private Data Exploration 2023 VLDB 5.2232014e-05
9,380 DP-starJ: A Differential Private Scheme towards Analytical Star-Join Queries 2023 SIGMOD 5.1705808e-05
9,413 Secure and Policy-Compliant Query Processing on Heterogeneous Computational Storage Architectures 2022 SIGMOD 5.1672232e-05
9,929 HDPView: Differentially Private Materialized View for Exploring High Dimensional Relational Data 2022 VLDB 5.0966022e-05
10,003 Secure Sampling for Approximate Multi-party Query Processing 2023 SIGMOD 5.0845476e-05
10,069 Sypse: Privacy-first Data Management through Pseudonymization and Partitioning 2021 CIDR 5.0742132e-05
10,515 Differentially Oblivious Multi-way Join 2026 SIGMOD 4.9605343e-05
10,518 DP-S4S: Accurate and Scalable Select-Join-Aggregate Query Processing with User-Level Differential Privacy 2026 SIGMOD 4.9605343e-05
10,571 Prism: Private Relational Data Synthesis with Language Models 2026 SIGMOD 4.9605343e-05
10,600 Differentially Private Explanations for Clusters 2026 SIGMOD 4.9605343e-05
10,866 Measuring Database Unfairness via Dependency Quantification Under Differential Privacy 2026 VLDB 4.9605343e-05
11,269 Computing Inconsistency Measures Under Differential Privacy 2025 SIGMOD 4.9605343e-05
11,281 SPECIAL: SynoPsis AssistEd Secure CollaboratIve AnaLytics 2025 VLDB 4.9605343e-05
11,363 Alchemy: A Query Optimization Framework for Oblivious SQL 2025 VLDB 4.9605343e-05
11,370 Calibrating Noise for Group Privacy in Subsampled Mechanisms 2025 VLDB 4.9605343e-05
11,414 Privacy-Enhanced Database Synthesis for Benchmark Publishing 2025 VLDB 4.9605343e-05
11,599 Personalized Truncation for Personalized Privacy 2024 SIGMOD 4.9605343e-05
11,630 SWAT: A System-Wide Approach to Tunable Leakage Mitigation in Encrypted Data Stores 2024 VLDB 4.9605343e-05
11,658 Confidence Intervals for Private Query Processing 2024 VLDB 4.9605343e-05
11,689 DOP-SQL: A General-purpose, High-utility, and Extensible Private SQL System 2024 VLDB 4.9605343e-05
11,737 Universal Private Estimators 2023 PODS 4.9605343e-05
11,840 Explaining Differentially Private Query Results With DPXPlain 2023 VLDB 4.9605343e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
18 MAGIC SETS AND OTHER STRANGE WAYS TO IMPLEMENT LOGIC PROGRAMS (Extended Abstract) 1986 PODS 0.00058816744
64 Privacy Integrated Queries: An Extensible Platform for Privacy-Preserving Data Analysis 2009 SIGMOD 0.00038378358
123 Revealing Information while Preserving Privacy 2003 PODS 0.00030654879
134 Privacy, Accuracy, and Consistency Too: A Holistic Solution to Contingency Table Release 2007 PODS 0.00029947443
279 Towards Practical Differential Privacy for SQL Queries 2018 VLDB 0.00022277389
559 Understanding Hierarchical Methods for Differentially Private Histograms 2013 VLDB 0.00016409103
612 Private Analysis of Graph Structure 2011 VLDB 0.00015534022
858 Recursive Mechanism: Towards Node Differential Privacy and Unrestricted Joins 2013 SIGMOD 0.00013391977
1,160 PrivBayes: Private Data Release via Bayesian Networks 2014 SIGMOD 0.00011733273
1,533 A Data- and Workload-Aware Algorithm for Range Queries Under Differential Privacy 2014 VLDB 0.00010310932
1,620 PriView: Practical Differentially Private Release of Marginal Contingency Tables 2014 SIGMOD 0.00010041603
1,851 Publishing Graph Degree Distribution with Node Differential Privacy 2016 SIGMOD 9.4955175e-05
2,099 Optimizing error of high-dimensional statistical queries under differential privacy 2018 VLDB 9.0315525e-05
2,315 Principled Evaluation of Differentially Private Algorithms using DPBench 2016 SIGMOD 8.6412356e-05
2,383 Blowfish Privacy: Tuning Privacy-Utility Trade-offs using Policies 2014 SIGMOD 8.5292865e-05
4,434 ϵktelo: A Framework for Defining Differentially-Private Computations 2018 SIGMOD 6.5862354e-05
5,025 Utility Cost of Formal Privacy for Releasing National Employer-Employee Statistics 2017 SIGMOD 6.2966621e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,615 A General Framework for Per-record Differential Privacy 2026 SIGMOD
2 4,964 PrivLava: Synthesizing Relational Data with Foreign Keys under Differential Privacy 2023 SIGMOD
3 8,030 Differentially Private Data Release over Multiple Tables 2023 PODS
4 6,677 Better than Composition: How to Answer Multiple Relational Queries under Differential Privacy 2023 SIGMOD
5 6,520 DProvDB: Differentially Private Query Processing with Multi-Analyst Provenance 2023 SIGMOD
6 11,689 DOP-SQL: A General-purpose, High-utility, and Extensible Private SQL System 2024 VLDB
7 6,823 Residual Sensitivity for Differentially Private Multi-Way Joins 2021 SIGMOD
8 64 Privacy Integrated Queries: An Extensible Platform for Privacy-Preserving Data Analysis 2009 SIGMOD
9 279 Towards Practical Differential Privacy for SQL Queries 2018 VLDB
10 7,315 Architecting a Differentially Private SQL Engine 2019 CIDR