Abstract
This paper proposes three efficient parallel algorithms for computing the range-join of two relations on two-dimensional n x m mesh-connected computers, where n and m are the numbers of the rows and columns respectively. After sorting all subsets of both relations, all proposed algorithms permute all sorted subsets of one relation to each processor in the computers, where they are joined with the subset of the other relation at that processor by using a sequential sort-merge rangejoin algorithm. The Min-Storage-Shifting and Min-Movement-Shifting algorithms permute the data on a mesh alternatively in the row and column directions, and Hamiltonian-cycle algorithm permutes the data along a Hamiltonian cycle of the mesh. The analysis shows that the Hamiltonian-cycle algorithm requires fewer local join operations but more data movements than other two algorithms and that the Min-Movement-Shifting algorithm requires fewer local join operations and data movements but more storage than the Min-Storage-Shifting algorithm.
Preview
Unable to display preview. Download preview PDF.
References
S. Chakravarthy and I. V. Ramakrishnan. Use of mesh connected processors for realizing fault tolerant relational database operations. In PARBASE-90 International Conference on Databases, Parallel Architectures and Their Applications, pages 568–70, Miami Beach, FL, USA, Mar. 1990.
S. D. Chen, H. Shen, and R. W. Topor. Efficient parallel permutation-based rangejoin algorithms on mesh-connected computers. Technical Report CIT-94-19, CIT, Griffith University, Australia, Aug. 1994.
S. D. Chen, H. Shen, and R. W. Topor. An improved hash-based join algorithm in the presence of double skew on a hypercube computer. In Proceedings of the Seventeenth Australia Computer Science Conference, Christchurch, New Zealand, Jan. 1994.
D. J. DeWitt and J. Gray. Parallel database systems: The future of high performance database systems. CACM, 35(6):85–98, 1992.
D. J. DeWitt, J. F. Naughton, and D. A. Schneider. An evaluation of Non-Equijoin algorithms. In Proceedings of the Seventeenth International Conference on VLDB, Barcelona, Spain, Sept. 1991.
M. Hamdi and R. W. Hall. Image processing on augmented mesh-connected parallel computers. Journal of Computer and Software Engineering, 2(3):329–48, 1994.
Intel Corporation. Intel Corporation literature, Nov. 1991.
H. Jhang. Performance comparison of join on hypercube and mesh. In 1992 ACM Computer Science Conference, pages 243–50, Kansas City, MO, USA, 1992.
F. T. Leighton. Introduction to Parallel Algorithms and Architectures: Arrays Trees Hypercubes. Morgan Kaufmann Publishers, San Mateo, California, 1992.
H. Shen. An improved selection-based parallel range-join algorithm in hypercubes. In Proceedings of the 20th EUROMICRO Conference, pages 65–72, Liverpool, UK, Sept. 1994.
M. Stonebraker. The case for shared nothing. Database Eng., 9(1), 1986.
J. D. Ullman. Principles of Database and Knowledge Base Systems, volume 2. Computer Science Press, 1989.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chen, S.D., Shen, H., Topor, R. (1995). Efficient parallel permutation-based range-join algorithms on mesh-connected computers. In: Kanchanasut, K., Lévy, JJ. (eds) Algorithms, Concurrency and Knowledge. ACSC 1995. Lecture Notes in Computer Science, vol 1023. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-60688-2_47
Download citation
DOI: https://doi.org/10.1007/3-540-60688-2_47
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60688-8
Online ISBN: 978-3-540-49262-7
eBook Packages: Springer Book Archive