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.00011731286
Overall Rank: 1,166 | 92.17%
DOI: 10.14778/3342263.3342274

Incoming Non-self Citations Over Time

Authors

1. Ios Kotsogiannis (Duke University)
2. Yuchao Tao (Duke University)
3. Xi He (University of Waterloo)
4. Maryam Fanaeepour (Duke University)
5. Ashwin Machanavajjhala (Duke University)
6. Michael Hay (Colgate University)
7. Gerome Miklau (University of Massachusetts Amherst)

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 3 of 53 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
11,989	Practical Security and Privacy for Database Systems	2021	SIGMOD	4.9793485e-05
12,016	ATLANTIC: Making Database Differentially Private and Faster with Accuracy Guarantee	2021	VLDB	4.9793485e-05
12,028	Catch a Blowfish Alive: A Demonstration of Policy-Aware Differential Privacy for Interactive Data Exploration	2021	VLDB	4.9793485e-05

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.00059023577
64	Privacy Integrated Queries: An Extensible Platform for Privacy-Preserving Data Analysis	2009	SIGMOD	0.00038522486
122	Revealing Information while Preserving Privacy	2003	PODS	0.00030770793
133	Privacy, Accuracy, and Consistency Too: A Holistic Solution to Contingency Table Release	2007	PODS	0.0003006035
276	Towards Practical Differential Privacy for SQL Queries	2018	VLDB	0.0002234348
558	Understanding Hierarchical Methods for Differentially Private Histograms	2013	VLDB	0.00016470707
609	Private Analysis of Graph Structure	2011	VLDB	0.00015591971
854	Recursive Mechanism: Towards Node Differential Privacy and Unrestricted Joins	2013	SIGMOD	0.00013441869
1,155	PrivBayes: Private Data Release via Bayesian Networks	2014	SIGMOD	0.00011777587
1,528	A Data- and Workload-Aware Algorithm for Range Queries Under Differential Privacy	2014	VLDB	0.00010349919
1,609	PriView: Practical Differentially Private Release of Marginal Contingency Tables	2014	SIGMOD	0.00010079578
1,838	Publishing Graph Degree Distribution with Node Differential Privacy	2016	SIGMOD	9.5315245e-05
2,090	Optimizing error of high-dimensional statistical queries under differential privacy	2018	VLDB	9.0657103e-05
2,298	Principled Evaluation of Differentially Private Algorithms using DPBench	2016	SIGMOD	8.6731734e-05
2,370	Blowfish Privacy: Tuning Privacy-Utility Trade-offs using Policies	2014	SIGMOD	8.5616358e-05
4,412	ϵktelo: A Framework for Defining Differentially-Private Computations	2018	SIGMOD	6.6112155e-05
4,999	Utility Cost of Formal Privacy for Releasing National Employer-Employee Statistics	2017	SIGMOD	6.3205439e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,539	A General Framework for Per-record Differential Privacy	2026	SIGMOD
2	4,944	PrivLava: Synthesizing Relational Data with Foreign Keys under Differential Privacy	2023	SIGMOD
3	8,008	Differentially Private Data Release over Multiple Tables	2023	PODS
4	6,661	Better than Composition: How to Answer Multiple Relational Queries under Differential Privacy	2023	SIGMOD
5	6,505	DProvDB: Differentially Private Query Processing with Multi-Analyst Provenance	2023	SIGMOD
6	11,636	DOP-SQL: A General-purpose, High-utility, and Extensible Private SQL System	2024	VLDB
7	6,803	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	276	Towards Practical Differential Privacy for SQL Queries	2018	VLDB
10	7,295	Architecting a Differentially Private SQL Engine	2019	CIDR