Partially Preemptible Hash Joins

Summary: Evaluates partially preemptible memory effects on in-memory hash joins in real-time/goal-oriented DBs; benchmarks existing memory-fluctuation techniques. Introduces memory-adaptive hash-join algorithms with improved resilience to memory variability. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2688
Venue: SIGMOD
Year: 1993
Pagerank: 7.6256187e-05
Overall Rank: 3,223 | 77.89%
DOI: 10.1145/170035.170051

Incoming Non-self Citations Over Time

Authors

1. HweeHwa Pang (University of Wisconsin)
2. Michael J. Carey (University of Wisconsin)
3. Miron Livny (University of Wisconsin)

BibTeX Citation

@inproceedings{pang_sigmod93,
        title = {{Partially Preemptible Hash Joins}},
        author = {Pang, HweeHwa and Carey, Michael J. and Livny, Miron},
        series = {{SIGMOD} '93},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/170035.170051},
        url = {https://dl.acm.org/doi/10.1145/170035.170051},
        year = {1993}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
523	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00017133451
781	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00014085674
2,184	Managing Memory to Meet Multiclass Workload Response Time Goals	1993	VLDB	9.0045033e-05
4,104	Memory-Contention Responsive Hash Joins	1994	VLDB	6.8987972e-05
4,241	Dynamic Multi-Resource Load Balancing in Parallel Database Systems	1995	VLDB	6.8094303e-05
4,462	Dynamic Resource Brokering for Multi-User Query Execution	1995	SIGMOD	6.6883778e-05
4,708	Memory-Adaptive External Sorting	1993	VLDB	6.5519325e-05
4,955	Dynamic Memory Adjustment for External Mergesort	1997	VLDB	6.4297637e-05
7,271	Managing Memory For Real-Time Queries	1994	SIGMOD	5.6595838e-05
7,800	Design Trade-offs for a Robust Dynamic Hybrid Hash Join	2022	VLDB	5.5420279e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
7	Implementation Techniques For Main Memory Database Systems	1984	SIGMOD	0.00083340894
270	Disk Shadowing	1988	VLDB	0.00022768303
844	Hash-Partitioned Join Method Using Dynamic Destaging Strategy	1988	VLDB	0.00013664056
1,779	An Adaptive Hash Join Algorithm for Multiuser Environments	1990	VLDB	9.7764427e-05
2,230	The Effect of Bucket Size Tuning in the Dynamic Hybrid GRACE Hash Join Method	1989	VLDB	8.9026958e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,668	Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor	1991	VLDB
2	1,785	A Scalable Hash Ripple Join Algorithm	2002	SIGMOD
3	959	Memory-Efficient Hash Joins	2015	VLDB
4	8,904	A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory	2023	VLDB
5	2,470	Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory	1990	VLDB
6	904	Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines	1990	VLDB
7	5,663	Early Hash Join: A Configurable Algorithm for the Efficient and Early Production of Join Results	2005	VLDB
8	360	Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs	2011	SIGMOD
9	1,779	An Adaptive Hash Join Algorithm for Multiuser Environments	1990	VLDB
10	4,104	Memory-Contention Responsive Hash Joins	1994	VLDB