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: 6151
Venue: SIGMOD
Year: 2021
Pagerank: 8.4015654e-05
Overall Rank: 2,573 | 82.35%
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,417	Towards Practical Oblivious Join	2022	SIGMOD	8.6061949e-05
3,131	HEDA: Multi-Attribute Unbounded Aggregation over Homomorphically Encrypted Database	2023	VLDB	7.7249939e-05
3,906	FedKNN: Secure Federated k-Nearest Neighbor Search	2024	SIGMOD	7.0287643e-05
5,714	Hu-Fu: Efficient and Secure Spatial Queries over Data Federation	2022	VLDB	6.1117296e-05
6,301	Evaluating Datalog over Semirings: A Grounding-based Approach	2024	PODS	5.9213518e-05
6,398	Query Evaluation by Circuits	2022	PODS	5.8867918e-05
6,434	Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees	2025	SIGMOD	5.8799421e-05
6,444	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS	5.8774519e-05
7,195	Space-Time Tradeoffs for Conjunctive Queries with Access Patterns	2023	PODS	5.6765621e-05
7,503	Disclosure-Compliant Query Answering	2024	SIGMOD	5.6029996e-05
8,449	Veil: A Storage and Communication Efficient Volume-Hiding Algorithm	2023	SIGMOD	5.4233579e-05
9,720	Avoiding Materialisation for Guarded Aggregate Queries	2025	VLDB	5.2319816e-05
9,785	Secure Sampling for Approximate Multi-party Query Processing	2023	SIGMOD	5.2209769e-05
10,221	Differentially Oblivious Multi-way Join	2026	SIGMOD	5.093636e-05
10,289	Sketch-based Secure Query Processing for Streaming Data	2026	SIGMOD	5.093636e-05
10,475	NSHEDB: Noise-Sensitive Homomorphic Encrypted Database Query Engine	2026	SIGMOD	5.093636e-05
10,542	Secure Multi-Party Sampling over Joins	2026	VLDB	5.093636e-05
10,762	Fast Hypertree Decompositions via Linear Programming: Fractional and Generalized	2025	SIGMOD	5.093636e-05
10,803	SPECIAL: SynoPsis AssistEd Secure CollaboratIve AnaLytics	2025	VLDB	5.093636e-05
10,816	Jodes: Efficient Oblivious Join in the Distributed Setting	2025	VLDB	5.093636e-05
10,905	Alchemy: A Query Optimization Framework for Oblivious SQL	2025	VLDB	5.093636e-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
281	Towards Practical Differential Privacy for SQL Queries	2018	VLDB	0.00022445849
412	Processing Analytical Queries over Encrypted Data	2013	VLDB	0.00018901853
526	TrustedDB: A Trusted Hardware based Database with Privacy and Data Confidentiality	2011	SIGMOD	0.00017112934
1,459	SMCQL: Secure Querying for Federated Databases	2017	VLDB	0.00010717725
1,549	AJAR: Aggregations and Joins over Annotated Relations	2016	PODS	0.00010390168
1,984	Shrinkwrap: Efficient SQL Query Processing in Differentially Private Data Federations	2019	VLDB	9.3540912e-05
2,045	Efficient Oblivious Database Joins	2020	VLDB	9.2632279e-05
2,133	Two Can Keep a Secret: A Distributed Architecture for Secure Database Services	2005	CIDR	9.1164075e-05
2,537	Secure Database-as-a-Service with Cipherbase	2013	SIGMOD	8.4549061e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,885	Fast Matrix Multiplication for Query Processing	2024	PODS
2	4,371	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS
3	2,045	Efficient Oblivious Database Joins	2020	VLDB
4	10,289	Sketch-based Secure Query Processing for Streaming Data	2026	SIGMOD
5	7,386	Instance-Optimal Acyclic Join Processing Without Regret: Engineering the Yannakakis Algorithm in Column Stores	2025	VLDB
6	816	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD
7	6,678	Output-sensitive Conjunctive Query Evaluation	2024	PODS
8	6,444	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS
9	6,434	Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees	2025	SIGMOD
10	10,542	Secure Multi-Party Sampling over Joins	2026	VLDB