Join on a Cube: Analysis, Simulation, and Implementation

  • Chaitanya K. Baru
  • Ophir Frieder
  • Dilip Kandlur
  • Mark Segal
Part of the The Kluwer International Series in Engineering and Computer Science book series (SECS, volume 43)

Abstract

Our recent research effort has been in studying database processing on a cube connected multicomputer system. This paper discusses one part of our work, viz., the study of the join operation. Novel data redistribution operations are employed to improve the performance of the various database operations including join. Though a simple analysis is provided, the data redistribution operations are, in general, difficult to characterize analytically. Thus, a simulation and implementation was carried out to study the performance of these operations and the join operation. Issues involved in the simulation and implementation and a discussion of the results from both are presented in this paper.

Keywords

Dust Compaction Sorting Baru 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [BAB79]
    Babb, E., “Implementing a Relational Database by Means of Specialized Hardware,” ACM Transactions on Database Systems, Vol. 4, No. 1, March, 1979.Google Scholar
  2. [BAN79]
    Banerjee, J., Hsiao, D. K., and Kannan, K., “DBC — A Database Computer for Very Large Databases”, IEEE Transactions on Computers, Vol. c-28, No. 6, June 1979.Google Scholar
  3. [BAR86a]
    Baru, C. K. and Su, S. Y. W., “The Architecture of SM3: A Dynamically Partitionable Multicomputer with Switchable Memory,” IEEE Transactions on Computers, Vol.C-35,No. 9, Sept. 1986.Google Scholar
  4. [BAR87]
    Baru, C.K. and Frieder, O., “Implementing Relational Database Operations in a Cube-Connected Multicomputer System,” to appear in the IEEE 3rd Intl.Conf. on Data Engineering, Los Angeles, CA, Feb 2–5, 1987.Google Scholar
  5. [DEW79]
    DeWitt, D. J., “DIRECT — A Multiprocessor Organization for Supporting Relational Database Management Systems”, IEEE Transactions on Computers, Vol. c-28, No. 6, June 1979.Google Scholar
  6. [DEW86]
    DeWitt, D.J. et al, “GAMMA — A High Performance Dataflow Database Machine,” Proc. Intl. Conf. on Very Large Databases, Aug.25–28, Kyoto, Japan, 1986.Google Scholar
  7. [FRI87a]
    Frieder, O. and Baru, C.K., “Issues in Query Processing on a Cube-Connected Multicomputer System,” IEEE 6th Annual Intl. Phoenix Conference on Computers and Communications, Feb. 25–27, 1987, pp. 315–319.Google Scholar
  8. [FRI87b]
    Frieder, O. and Baru, C.K., “Data Distribution and Query Scheduling Policies for a Cube-Connected Multicomputer System,” 2nd Intl. Conf. on Supercomputing Systems, San Francisco, May 3–5,1987.Google Scholar
  9. [FRJ87c]
    Frieder, O., “Database Processing on a Cube-Connected Multicomputer,” Ph.D. Dissertation, Dept. of Electrical Engineering and Computer Science, The University of Michigan, Ann Arbor, MI 48109, 1987.Google Scholar
  10. [FUS86]
    Fushimi, S., Kitsuregawa, M., and Tanaka, H., “An Overview of the System Software of a Parallel Relational Database Machine GRACE,” Proc. VLDB 12th Intl. Conf. on Very Large Data Bases, Aug.25–28, Kyoto, Japan, 1986.Google Scholar
  11. [GAM87]
    Gamerl, M., “Maturing Parallel Transfer Disk Technology Finds More Applications,” Hardcopy, pp.41–48, Feb. 1987.Google Scholar
  12. [HAY86]
    Hayes, J.P. et al, “Architecture of a Hypercube Supercomputer,” Procs. Intl. Conf. on Parallel Processing, St. Charles, IL., 1986.Google Scholar
  13. [HIL86]
    Hillyer, B., Shaw, D.E., and Nigam, A., “NON-VON’s Performance on Certain Database Benchmarks,” IEEE Transactions on Software Engineering, Vol.SE-12, No.4, April, 1986.Google Scholar
  14. [K3T84]
    Kitsuregawa, M., Tanaka, H., and Moto-Oka, T., “Architecture and Performance of the Relational Algebra Machine GRACE,” Procs. Intl. Conf. on Parallel Processing, August, 1984.Google Scholar
  15. [PET85]
    Peterson, J.C., Tuazon, J.O., Lieberman, D., and Pniel, M., “The MARK III Hypercube-Ensemble Concurrent Computer,” Intl. Conf. on Parallel Processing, pp.71–73, Aug. 1985.Google Scholar
  16. [SCH79]
    Schuster, S.A., Nguyen, H.B., Ozkarahan, E.A., and Smith, K.C., “RAP.2-An Associative Processor for Databases and its Applications,” IEEE Transactions on Computers, Vol.C-28, No.6, June, 1979.Google Scholar
  17. [SU79]
    Su, S.Y.W., Nguyen, L.H., Emam, A., and Lipovski, G.J., “The Architectural Features and Implementation Techniques of the Multicell CASSM,” IEEE Transactions on Computers, Vol.C-28, No.6, June, 1979.Google Scholar

Copyright information

© Kluwer Academic Publishers, Boston 1988

Authors and Affiliations

  • Chaitanya K. Baru
    • 1
  • Ophir Frieder
    • 1
  • Dilip Kandlur
    • 1
  • Mark Segal
    • 1
  1. 1.Department of Electrical Engineering and Computer ScienceThe University of MichiganAnn ArborUSA

Personalised recommendations