Abstract
The Bounded Disorder file is a file organization method that consists of an index and multi-bucket data leaves which are partially expanded before being split. It guarantees good performance for single-key operations (e.g. search, insert, and delete), similar to that of hash based methods, and in addition, good performance for subrange operations, and reasonable performance for sequential-key operations. To obtain these capabilities, the index must be entirely stored in main memory.
In this paper, we consider the problem of implementing Bounded Disorder files in multiprocessor multi-disk environments which consist of P processor-disk pairs. The processors are either tightly coupled (communicate via shared memory) or loosely coupled (communicate via a local network).
The straightforward solution is to equally partition the file records among processors, each of which maintains its part as a “local” Bounded Disorder file (stored in the processor's main memory and disk). This method is highly parallel (up to P single-key operations can be executed in parallel) and achieves good performance due to the use of Bounded Disorder files.
We present an alternative method, called Conceptual Bounded Disorder file, which obtains performance similar to the above straightforward method, and in addition, obtains a significant cut down in main memory space consumption. Thus, in on-line systems, the number of files that can be concurrently opened for access is much larger when files are maintained as Conceptual Bounded Disorder files.
This research was supported by the E. & J. Bishop Fund at the Technion.
Preview
Unable to display preview. Download preview PDF.
References
D. Comer, “The Ubiquitous B-tree”, ACM Computing Surveys, Vol 11, No 2, June 1979, pp. 121–137.
D. J. DeWitt, H. R. Gerber, G. Graefe, L. M. Heytens, K. B. Kumar, and M. Muralikrishna, “GAMMA: A Performance Dataflow Database Machine”, Proc. of Very Large Data Bases Conf., August 1986, pp. 228–237.
B. Eisenbarth, N. Ziviani, G. H. Gonnet, K. Mehlhorn, and D. Wood, “The Theory of Fringe Analysis and its Application to 2–3 Trees and B-trees”, Information and Control, Vol 55, 1982, pp. 125–174.
R. Fagin, J. Nievergelt, N. Pippenger, and R. H. Strong, “Extendible Hashing — a Fast Access Method for Dynamic Files”, ACM Transaction on Database Systems, Vol 4, No 3, September 1979, pp. 315–355.
T. Lehman, “Design and Performance Evaluation of Main Memory Relational Database System”, University of Wisconsin Madison, Computer Science Dep. T.R. #656, August 1986.
W. Litwin, “Linear Hashing: a new tool for file and table addressing”, Proc. of Very Large Data Bases Conf., October 1980, pp. 212–223.
D. B. Lomet, “Partial Expansions for File Organizations With an Index”, ACM Transactions on Database Systems, Vol 12, No 1, March 1987, pp. 65–84.
D. B. Lomet, “A Simple Bounded Disorder File Organization with Good Performance”, ACM Transactions on Database Systems, Vol 13, No 4, December 1988, pp. 525–551.
G. Matsliach, “Performance Analysis of File Organizations that Use Multi-Bucket Data Leaves with Partial Expansions”, Technion — Israel Institute of Technology, Dept. of Computer Science, TR #643, July 1990.
G. Matsliach, and O. Shmueli, “Distributing a B+-tree in a Loosely Coupled Environment”, Information Processing Letters, Vol 34, No 6, May 1990. pp. 313–321.
G. Matsliach, and O. Shmueli, “A Combined Method for Maintaining Indices in Multi-processor Multi-disk Environments”, Technion — Israel Institute of Technology, Dept. of Computer Science, TR #608, February 1990.
G. Matsliach, and O. Shmueli, “A General Method For Distributing Search Structures and Reducing Main Memory Consumption”, Technion — Israel Institute of Technology, Dept. of Computer Science, Center of Intelligent Systems, TR #9004, June 1990.
G. Matsliach, and O. Shmueli, “A Framework for Distributing and Parallelizing Secondary Memory Search Structures”, Technion — Israel Institute of Technology, Dept. of Computer Science, TR #637, June 1990.
M. V. Ramakrishna, and P. Mulkhopadhyay, “Analysis of Bounded Disorder File Organization”, Proc. of ACM-PODS Conf., 1988, pp. 117–125.
Y. Sagiv, “Concurrent Operations on B+-trees with Overtaking”, Journal of Computer and System Sciences, Vol 33, No 2, October 1986, pp. 275–296.
A. A. C. Yao, “On Random 2–3 Trees”, Acta Informatica, Vol 9, No 2, 1978, pp. 159–170.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1990 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Matsliach, G., Shmueli, O. (1990). Maintaining bounded disorder files in multiprocessor multi-disk environments. In: Abiteboul, S., Kanellakis, P.C. (eds) ICDT '90. ICDT 1990. Lecture Notes in Computer Science, vol 470. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-53507-1_73
Download citation
DOI: https://doi.org/10.1007/3-540-53507-1_73
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-53507-2
Online ISBN: 978-3-540-46682-6
eBook Packages: Springer Book Archive