Skip to main content
Article
Memory-adaptive external sorting
19th International Conference on Very Large Data Bases: August 24-27 1993, Dublin, Ireland: Proceedings
  • 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
8-1993
Abstract
In real-time and goal-oriented database systems, the amount of memory assigned to queries that sort or join large relations may fluctuate due to contention from other higher priority transactions. This study focuses on techniques that enable external sorts both to reduce their buffer usage when they lose memory, and to effectively utilize any additional buffers that are given to them. We also show how these techniques can be extended to work with sort-merge joins. A series of experiments confirms that our proposed techniques are useful for sorting and joining large relations in the face of memory fluctuations.
ISBN
9781558601529
Publisher
VLDB Endowment
City or Country
Palo Alto, CA
Creative Commons License
Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International
Additional URL
http://www.vldb.org/conf/1993/P618.PDF
Citation Information
Hwee Hwa PANG, Michael J. CAREY and Miron LIVNY. "Memory-adaptive external sorting" 19th International Conference on Very Large Data Bases: August 24-27 1993, Dublin, Ireland: Proceedings (1993) p. 618 - 629
Available at: http://works.bepress.com/hweehwa-pang/48/