Abstract
The equi-join operation is one of the most important operations of the relational data model. It participates in all queries which reference more than one relation. In this paper, a large set of parallel algorithms for implementing the equi-join operation on a multiprocessor database machine called MIRDM (MIchigan Relational Database Machine), is presented. An outline of a study for the performance of the proposed algorithms in carrying out the equi-Join operation on MIRDM, is also presented. The main objective of this study is twofold: the determination of the overall best performing equi-join algorithm and the investigation of the effectiveness (from the equi-join operation point of view) of performing some tuning to the architecture of MIRDM. This study shows, among others, that for a given MIRDM configuration; the overall best performing equi-join algorithm is not unique and different algorithms score the best performance depending on the characteristics of the data participating in the equi-join operation.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
D. D. Chamberlin, A. M. Gilbert, and R. A. Yost, “A History of System-R and SQL/Data system,” in 7th International Conference on Very Large Data Bases, Cannes, France, Sept. 1981.
M. Stonebreaker, E. Wong, and P. Kreps, “The Design and Implementation of INGRES,” ACM Trans, on Database Systems, 1, 3, Sept. 1976.
E. A. Ozkarahan, S. A. Schuster and K. C. Smith, “RAP-An Associative Professor for Database Management” AFIPS Proceedings, Vol. 45, 1975, pp. 379–387.
J. Banerjee, D. Hsiao and K. Kannan, “DBC-A Database Computer for Very Large Databases,” IEEE Transaction on Computers, Vol. C-28, No. 6, June 1979, pp. 414–429.
E. Babb, “Implementing a Relational Database by Means of Specilized Hardware,” ACM Trans, on Database Systems,Vol. 4, No. 1 (March 1979), pp. 1–29.
G. J. Liposki, “Architectural Feature of CASSM: A Context Segment Sequential Memory,” Proceedings of the Fifth Annual Symp. on Computer Architecture, Palo Alto, CA, April 1978, pp. 31–38.
D. J. Dewitt, “DIRECT — A Multiprocessor Organization for Supporting Relational Database Management Systems,” IEEE Trans, on Computers, Vol. C-28, No. 6, June 1979, pp. 395–408.
G. Gardrain, “An Introduction to SABRE: A Mufti-Microprocessor Database Machine,” 6th Workshop on Computer Architecture for Non-Numeric Processing, Hyeres, France, June 1981.
D. K. Hsiao and M. J. Menon, “Design and Analysis of a Mufti-Backend Database System for Performance Improvements, Functionality Expantion and Capacity Growth (Part I and II),” Technical Reports, OSU-CISRC-TR- 81-81-7 and OSU-CISRC-TR-81-8, The Ohio State University, Columbus, Ohio, 1981.
R. Epstein and P. Hawthorn, “Design Decisions for the Intelligent Database Machine,” Proceedings of NCC4, AFIP, 1980, pp. 237–241.
J. R. Goodman, “An Investigation of Multiprocessor Structures and Algorithms for Database Management,” Memo No. UCB/ERLM81 (May 1981), Electronic Research Lab., College of Engineering, Univ. of California/ Berkeley.
[G. Z. Qadah and K. B. Irani, “A Database Machine for Very Large Relational Databases,” Proceedings of the International Conference on Parallel Processing, August 23–26, 1983, pp. 307–314.
E. F. Codd, “A Relational Model of Data for Large Shared Databanks,” Comm, ACM, Vol. 13, No. 1, June 1970, pp. 377–387.
D. Bitton, et al., “Parallel Algorithms for the Execution of Relational Database Operations,” ACM Trans. on Database Systems, Vol. 8, No. 3, September 1983, pp. 324–353.
P. Valduriez and G. Gardarin, “Join and Semijoin Algorithms for a Microprocessor Database Machine,” ACM Trans, on Database Systems, Vol. 9, No. 1, March 1984, pp. 133–161.
D. B. Friedland, “Design, Analysis, and Implementation of Parallel External Sorting Algorithms,” Computer Science Technical Report #464, University of Wisconsin-Madison, January 1982.
D. E. Knuth, The Art of Computer Programming, Vol 3: Sorting and Searching, ”Addison-Wesley, Reading, Mass., 1973.
G. Z. Qadah, “A Relational Databases Machine: Analysis and Design,” Ph.D. Thesis, 1983. The Electrical and Computer Engineering Department, the University of Michigan, Ann Arbor.
IBM Corporation, “IBM 3380 DIRECT Access Storage Description and User’s Guide,” IBM Document GA26–1664–0, File No. 51370–07, 1980.
Intel Corporation, “iupx86, 88 User-s Manual,” July 1981.
H. Schweppe, H. Zeidler, W. hell, h. Leilich, G. Stiege and W. Teich, “RDBM—A Dedicated Multiprocessor System for Database Management,” Advanced Database Architecture, Prentice-Hall, 1983, pp. 36–86
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1985 Springer-Verlag New York Inc.
About this chapter
Cite this chapter
Qadah, G.Z. (1985). The Equi-Join Operation on a Multiprocessor Database Machine: Algorithms and the Evaluation of their Performance. In: DeWitt, D.J., Boral, H. (eds) Database Machines. Springer, New York, NY. https://doi.org/10.1007/978-1-4612-5144-6_3
Download citation
DOI: https://doi.org/10.1007/978-1-4612-5144-6_3
Publisher Name: Springer, New York, NY
Print ISBN: 978-0-387-96200-9
Online ISBN: 978-1-4612-5144-6
eBook Packages: Springer Book Archive