Secure Yannakakis: Join-Aggregate Queries over Private Data

Summary: Secure Yannakakis: secure two-party evaluation of free-connex join-aggregate queries. Linear-time in data, polynomial in query; outperforms garbled-circuit approaches, reducing practical runtimes from years to minutes on TPC-H. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h4408874e222d87b9
Venue: SIGMOD
Year: 2021
Pagerank: 8.2594787e-05
Overall Rank: 2,582 | 82.65%
DOI: 10.1145/3448016.3452808

Incoming Non-self Citations Over Time

Authors

1. Yilei Wang (Hong Kong University of Science and Technology)
2. Ke Yi (Hong Kong University of Science and Technology)

BibTeX Citation

@inproceedings{wang_sigmod21,
        title = {{Secure Yannakakis: Join-Aggregate Queries over Private Data}},
        author = {Wang, Yilei and Yi, Ke},
        series = {{SIGMOD} '21},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3448016.3452808},
        url = {https://dl.acm.org/doi/10.1145/3448016.3452808},
        year = {2021}
}

Incoming Citations (Sorted by Pagerank)

Showing 21 of 21 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,455	Towards Practical Oblivious Join	2022	SIGMOD	8.4390594e-05
3,191	HEDA: Multi-Attribute Unbounded Aggregation over Homomorphically Encrypted Database	2023	VLDB	7.5516658e-05
3,306	FedKNN: Secure Federated k-Nearest Neighbor Search	2024	SIGMOD	7.4422756e-05
4,883	Hu-Fu: Efficient and Secure Spatial Queries over Data Federation	2022	VLDB	6.3710505e-05
5,902	Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees	2025	SIGMOD	5.9536872e-05
6,429	Evaluating Datalog over Semirings: A Grounding-based Approach	2024	PODS	5.7884926e-05
6,531	Query Evaluation by Circuits	2022	PODS	5.754708e-05
6,573	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS	5.7455776e-05
7,338	Space-Time Tradeoffs for Conjunctive Queries with Access Patterns	2023	PODS	5.5491953e-05
7,647	Disclosure-Compliant Query Answering	2024	SIGMOD	5.4772833e-05
7,917	Avoiding Materialisation for Guarded Aggregate Queries	2025	VLDB	5.4276002e-05
8,618	Veil: A Storage and Communication Efficient Volume-Hiding Algorithm	2023	SIGMOD	5.3016723e-05
9,966	Secure Sampling for Approximate Multi-party Query Processing	2023	SIGMOD	5.1038322e-05
10,437	Differentially Oblivious Multi-way Join	2026	SIGMOD	4.9793485e-05
10,501	Sketch-based Secure Query Processing for Streaming Data	2026	SIGMOD	4.9793485e-05
10,662	NSHEDB: Noise-Sensitive Homomorphic Encrypted Database Query Engine	2026	SIGMOD	4.9793485e-05
10,724	Secure Multi-Party Sampling over Joins	2026	VLDB	4.9793485e-05
11,185	Fast Hypertree Decompositions via Linear Programming: Fractional and Generalized	2025	SIGMOD	4.9793485e-05
11,216	SPECIAL: SynoPsis AssistEd Secure CollaboratIve AnaLytics	2025	VLDB	4.9793485e-05
11,225	Jodes: Efficient Oblivious Join in the Distributed Setting	2025	VLDB	4.9793485e-05
11,301	Alchemy: A Query Optimization Framework for Oblivious SQL	2025	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
276	Towards Practical Differential Privacy for SQL Queries	2018	VLDB	0.0002234348
420	Processing Analytical Queries over Encrypted Data	2013	VLDB	0.00018540576
538	TrustedDB: A Trusted Hardware based Database with Privacy and Data Confidentiality	2011	SIGMOD	0.00016764769
1,495	SMCQL: Secure Querying for Federated Databases	2017	VLDB	0.00010484897
1,570	AJAR: Aggregations and Joins over Annotated Relations	2016	PODS	0.0001020855
2,017	Shrinkwrap: Efficient SQL Query Processing in Differentially Private Data Federations	2019	VLDB	9.1758131e-05
2,074	Efficient Oblivious Database Joins	2020	VLDB	9.0841817e-05
2,175	Two Can Keep a Secret: A Distributed Architecture for Secure Database Services	2005	CIDR	8.9159708e-05
2,576	Secure Database-as-a-Service with Cipherbase	2013	SIGMOD	8.2748237e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,463	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS
2	2,074	Efficient Oblivious Database Joins	2020	VLDB
3	11,027	Instance-Optimal Acyclic Joins: From Theory to Systems	2026	VLDB
4	10,501	Sketch-based Secure Query Processing for Streaming Data	2026	SIGMOD
5	6,805	Instance-Optimal Acyclic Join Processing Without Regret: Engineering the Yannakakis Algorithm in Column Stores	2025	VLDB
6	812	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD
7	6,467	Output-sensitive Conjunctive Query Evaluation	2024	PODS
8	6,573	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS
9	5,902	Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees	2025	SIGMOD
10	10,724	Secure Multi-Party Sampling over Joins	2026	VLDB