RPJ: Producing Fast Join Results on Streams through Rate-based Optimization

Summary: RPJ is a rate-based progressive join for streaming relations over unreliable networks, to start output quickly and maintain high throughput. A theoretical framework guides optimization by adapting to data distribution and arrival patterns, yielding faster results than prior work. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3712
Venue: SIGMOD
Year: 2005
Pagerank: 6.0443263e-05
Overall Rank: 5,911 | 59.45%
DOI: 10.1145/1066157.1066200

Incoming Non-self Citations Over Time

Authors

1. Yufei Tao (City University of Hong Kong)
2. Man Lung Yiu (University of Hong Kong)
3. Dimitris Papadias (Hong Kong University of Science and Technology)
4. Marios Hadjieleftheriou (University of California Riverside)
5. Nikos Mamoulis (University of Hong Kong)

BibTeX Citation

@inproceedings{tao_sigmod05,
        title = {{RPJ: Producing Fast Join Results on Streams through Rate-based Optimization}},
        author = {Tao, Yufei and Yiu, Man Lung and Papadias, Dimitris and Hadjieleftheriou, Marios and Mamoulis, Nikos},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066200},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066200},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,892	Scalable and Adaptive Online Joins	2014	VLDB	7.9852178e-05
4,630	Efficient Join Synopsis Maintenance for Data Warehouse	2020	SIGMOD	6.5955933e-05
6,762	SquirrelJoin: Network-Aware Distributed Join Processing with Lazy Partitioning	2017	VLDB	5.7814194e-05
7,820	Parallelizing Intra-Window Join on Multicores: An Experimental Study	2021	SIGMOD	5.5373345e-05
7,967	Thrifty Query Execution via Incrementability	2020	SIGMOD	5.5169373e-05
9,017	PR-Join: A Non-Blocking Join Achieving Higher Early Result Rate with Statistical Guarantees	2010	SIGMOD	5.3311284e-05

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
26	Models and Issues in Data Stream Systems	2002	PODS	0.00052982574
136	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00030123303
671	Load Shedding in a Data Stream Manager	2003	VLDB	0.00015154516
1,016	Rate-Based Query Optimization for Streaming Information Sources	2002	SIGMOD	0.00012645699
1,093	Maximizing the Output Rate of Multi-Way Join Queries over Streaming Information Sources	2003	VLDB	0.00012218435
1,397	Approximate Join Processing Over Data Streams	2003	SIGMOD	0.00010906135
2,787	Progressive Merge Join: A Generic and Non-Blocking Sort-Based Join Algorithm	2002	VLDB	8.1205738e-05
3,255	Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams	2003	VLDB	7.591663e-05
3,657	Memory-Limited Execution of Windowed Stream Joins	2004	VLDB	7.2217692e-05
5,467	On Producing Join Results Early	2003	PODS	6.2074577e-05
5,490	XWAVE: Optimal and Approximate Extended Wavelets for Streaming Data	2004	VLDB	6.200262e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,364	Fast Join Project Query Evaluation using Matrix Multiplication	2020	SIGMOD
2	5,138	Robust and Efficient Algorithms for Rank Join Evaluation	2009	SIGMOD
3	3,011	Design and Evaluation of Parallel Pipelined Join Algorithms	1987	SIGMOD
4	2,787	Progressive Merge Join: A Generic and Non-Blocking Sort-Based Join Algorithm	2002	VLDB
5	3,255	Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams	2003	VLDB
6	1,740	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
7	2,892	Scalable and Adaptive Online Joins	2014	VLDB
8	1,397	Approximate Join Processing Over Data Streams	2003	SIGMOD
9	1,093	Maximizing the Output Rate of Multi-Way Join Queries over Streaming Information Sources	2003	VLDB
10	9,017	PR-Join: A Non-Blocking Join Achieving Higher Early Result Rate with Statistical Guarantees	2010	SIGMOD