Skip to main content

Sorting and Join Algorithms for Multiprocessor Database Machines

  • Conference paper

Part of the book series: NATO ASI Series ((NATO ASI F,volume 24))

Abstract

Several multiprocessor database machines [GARDA81] [BABBE79] [DEWIT79]. have been or are currently being developed. The main objective of these machines is to answer complex queries against very large data bases, with better performance than conventional database systems [CHAMB81] [STONE76].

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Bibliography

  1. Babb, E., Implementing a Relational Database by Means of Specialized Hardware, ACM Transactions on Database Systems 4, No.l (March 1979) pp. 1–29.

    Article  Google Scholar 

  2. Batcher, K. E., Sorting Networks and their Applications, Proceedings of the 1968 Spring Joint Computer Conference 32 (Atlantic City, N. J., May 1968) pp. 307-314.

    Google Scholar 

  3. Baudet, G. and Stevenson, D., Optimal Sorting Algorithms for Parallel Computers, IEEE-TC C-27, No.1 (Jan. 1978).

    MathSciNet  Google Scholar 

  4. Bitton, D., Design, Analysis and Implementation of Parallel External Sorting Algorithms, Ph. D. Dissertation, TR484, Computer Science Department, University of Wisconsin, Madison (Jan. 1982).

    Google Scholar 

  5. Bitton, D., Boral, H., Dewitt, D. J., and Wilkinson, W. K., Parallel Algorithms for the Execution of Relational Database Operations, ACM Transactions on Database Systems 8, No. 3 (Sept 1983).

    Google Scholar 

  6. Bitton, D., Dewitt, D. J., Hsiao, D. K., and Menon, M. J., A Taxonomy of Parallel Sorting, Computing Surveys 16, No.3 (Sep. 1984).

    Article  MathSciNet  Google Scholar 

  7. Blasgen, M. W., and Eswaran, K. P., Storage and Access in Relational Data Bases, IBM Systems Journal 16, No.4 (1977).

    Article  Google Scholar 

  8. Bratsbergsengen, K., Hashing Methods and Relational Algebra Operations, Proceedings of Tenth International Conference on VLDB (Singapore, August 1984).

    Google Scholar 

  9. Chamberlin, D. D., Gilbert, A. M., and Yost, R. A., A History of System-R and SQL-data system, Proceedings of Seventh International Conference on VLDB (Cannes, France, Sept. 1981).

    Google Scholar 

  10. Dewitt, D. J., Query Execution in DIRECT, Proceedings of ACM SIGMOD Conference (New York, May 1979).

    Google Scholar 

  11. Gardarin, G., An Introduction to SABRE: a multimicroprocessor database machine, Sixth Workshop on Computer Architecture for Non-numeric Processing (Hyeres, France, June 1981).

    Google Scholar 

  12. Goodman, J. R., An Investigation of Multiprocessor Architectures and Algorithms for Database Management, Ph. D. Dissertation, UCB/ ERL/M81/33, College of Engineering, Berkeley, Ca. (May 1981).

    Google Scholar 

  13. Hirschberg, D. S., Fast Parallel Sorting Algorithms, Communications of the ACM 21, No.8 (Aug. 1978).

    Article  MathSciNet  Google Scholar 

  14. Hsiao, D. K., and Menon, M. J., Parallel Record Sorting Methods for Hardware Realization, Technical Report, OSU-CISRC-TR-80-7, Computer and Information Science Department, Ohio State University, Columbus, Ohio (July 1980).

    Google Scholar 

  15. Knuth, D. E., The Art of Computer Programming, Addison Wesley (Reading, 1973).

    Google Scholar 

  16. Menon, M. J., and Hsiao, D. K., Design and Analysis of Relational Join Operations of a Database Computer (DBC), Proceedings of Seventh International Conference on VLDB (Cannes, Sept. 1981).

    Google Scholar 

  17. Menon, M. J., IBM Internal memo.

    Google Scholar 

  18. Muller, D. E., and Preparata, F. P., Bounds to Complexities of Networks for Sorting and for Switching, Journal of the ACM 22, No. 2 (Apr. 1975).

    Article  MathSciNet  Google Scholar 

  19. Nassimi, D., and Sahni, S., Bitonic Sort on a Mesh Connected Parallel Computer, IEEE Transactions on Computers C-27, No. 1 (Jan. 1978).

    Google Scholar 

  20. Preparata, F. P., New Parallel Sorting Schemes, IEEE Transactions on Computers C-27, No. 7 (July 1978).

    Article  MathSciNet  Google Scholar 

  21. Shaw, D., A Relational Database Machine Architecture, Fifth Annual Workshop on Computer Architecture for Non-numeric Processing (Asilomar, March 1980).

    Google Scholar 

  22. Stone, H. S., Parallel Processing with the Perfect Shuffle, IEEE Transactions on Computers C-20, 2 (Feb. 1971).

    Article  Google Scholar 

  23. Stonebraker, M., Wong, E., and Kreps, P., The Design and Implementation of INGRES, ACM Transactions on Database Systems 1, 3 (Sept. 1976).

    Article  Google Scholar 

  24. Thompson, C. D., and Kung, H. T., Sorting on a Mesh-Connected Parallel Computer, Communications of the ACM 20, 4 (Apr. 1977).

    Article  MathSciNet  Google Scholar 

  25. Valduriez, P. and Gardarin, G., Join and Semi-Join Algorithms for a Multiprocessor Database Machine, ACM Transactions on Database Systems 9, No. 1 (March 1984).

    Article  Google Scholar 

  26. Valiant, L. G., Parallelism in Comparison Problems, SIAM Journal of Computing 3, No. 4 (Sept. 1975).

    MathSciNet  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1986 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Menon, J. (1986). Sorting and Join Algorithms for Multiprocessor Database Machines. In: Sood, A.K., Qureshi, A.H. (eds) Database Machines. NATO ASI Series, vol 24. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-82937-6_13

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-82937-6_13

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-82939-0

  • Online ISBN: 978-3-642-82937-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics