Skip to main content
Article
Partially preemptible hash joins
SIGMOD '93: Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data: May 26-28, 1993, Washington, DC
  • Hwee Hwa PANG, Singapore Management University
  • Michael J. CAREY, University of Wisconsin-Madison
  • Miron LIVNY, University of Wisconsin-Madison
Publication Type
Conference Proceeding Article
Version
publishedVersion
Publication Date
5-1993
Abstract

With the advent of real-time and goal-oriented database systems, priority scheduling is likely to be an important feature in future database management systems. A consequence of priority scheduling is that a transaction may lose its buffers to higher-priority transactions, and may be given additional memory when transactions leave the system. Due to their heavy reliance on main memory, hash joins are especially vulnerable to fluctuations in memory availability. Previous studies have proposed modifications to the hash join algorithm to cope with these fluctuations, but the proposed algorithms have not been extensively evaluated or compared with each other. This paper contains a performance study of these algorithms. In addition, we introduce a family of memory-adaptive hash join algorithms that turns out to offer even better solutions to the memory fluctuation problem that hash joins experience.

ISBN
9780897915922
Identifier
10.1145/170036.170051
Publisher
ACM
City or Country
New York
Creative Commons License
Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International
Additional URL
http://doi.org/10.1145/170036.170051
Citation Information
Hwee Hwa PANG, Michael J. CAREY and Miron LIVNY. "Partially preemptible hash joins" SIGMOD '93: Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data: May 26-28, 1993, Washington, DC (1993) p. 59 - 68
Available at: http://works.bepress.com/hweehwa-pang/58/