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.2282707e-05
Overall Rank: 2,593 | 82.63%
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,465	Towards Practical Oblivious Join	2022	SIGMOD	8.4071729e-05
3,202	HEDA: Multi-Attribute Unbounded Aggregation over Homomorphically Encrypted Database	2023	VLDB	7.5231322e-05
3,319	FedKNN: Secure Federated k-Nearest Neighbor Search	2024	SIGMOD	7.4141554e-05
4,909	Hu-Fu: Efficient and Secure Spatial Queries over Data Federation	2022	VLDB	6.3469778e-05
5,911	Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees	2025	SIGMOD	5.9338021e-05
6,443	Evaluating Datalog over Semirings: A Grounding-based Approach	2024	PODS	5.7666211e-05
6,545	Query Evaluation by Circuits	2022	PODS	5.7329641e-05
6,585	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS	5.7238683e-05
7,361	Space-Time Tradeoffs for Conjunctive Queries with Access Patterns	2023	PODS	5.528228e-05
7,666	Disclosure-Compliant Query Answering	2024	SIGMOD	5.4565877e-05
7,936	Avoiding Materialisation for Guarded Aggregate Queries	2025	VLDB	5.4070923e-05
8,647	Veil: A Storage and Communication Efficient Volume-Hiding Algorithm	2023	SIGMOD	5.2816403e-05
10,003	Secure Sampling for Approximate Multi-party Query Processing	2023	SIGMOD	5.0845476e-05
10,515	Differentially Oblivious Multi-way Join	2026	SIGMOD	4.9605343e-05
10,578	Sketch-based Secure Query Processing for Streaming Data	2026	SIGMOD	4.9605343e-05
10,734	NSHEDB: Noise-Sensitive Homomorphic Encrypted Database Query Engine	2026	SIGMOD	4.9605343e-05
10,795	Secure Multi-Party Sampling over Joins	2026	VLDB	4.9605343e-05
11,253	Fast Hypertree Decompositions via Linear Programming: Fractional and Generalized	2025	SIGMOD	4.9605343e-05
11,281	SPECIAL: SynoPsis AssistEd Secure CollaboratIve AnaLytics	2025	VLDB	4.9605343e-05
11,289	Jodes: Efficient Oblivious Join in the Distributed Setting	2025	VLDB	4.9605343e-05
11,363	Alchemy: A Query Optimization Framework for Oblivious SQL	2025	VLDB	4.9605343e-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
279	Towards Practical Differential Privacy for SQL Queries	2018	VLDB	0.00022277389
421	Processing Analytical Queries over Encrypted Data	2013	VLDB	0.00018470619
539	TrustedDB: A Trusted Hardware based Database with Privacy and Data Confidentiality	2011	SIGMOD	0.00016701521
1,499	SMCQL: Secure Querying for Federated Databases	2017	VLDB	0.00010445281
1,568	AJAR: Aggregations and Joins over Annotated Relations	2016	PODS	0.00010178045
2,032	Shrinkwrap: Efficient SQL Query Processing in Differentially Private Data Federations	2019	VLDB	9.1412376e-05
2,086	Efficient Oblivious Database Joins	2020	VLDB	9.0498577e-05
2,194	Two Can Keep a Secret: A Distributed Architecture for Secure Database Services	2005	CIDR	8.8822913e-05
2,583	Secure Database-as-a-Service with Cipherbase	2013	SIGMOD	8.2435615e-05

Semantically Similar Papers

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