A new join algorithm

This paper introduces a new efficient join algorithm to increase the speed of the join relational operation. Using a divide and conquer strategy, stack oriented filter technique in the new join algorithm filters unwanted tuples as early as possible while none of the currently existing join algorithms takes advantage of any filtering concept. Other join algorithms may carry the unnecessary tuples up to the last moment of join attribute comparisons.Four join algorithms are described and discussed in this paper: the nested-loop join algorithm, the sort-merge join algorithm, the hash join algorithm, and the new join algorithm.

[1]  David J. DeWitt,et al.  A performance evaluation of four parallel join algorithms in a shared-nothing multiprocessor environment , 1989, SIGMOD '89.

[2]  D. J. De Witt,et al.  Direct—A Multiprocessor Organization for Supporting Relational Database Management Systems , 1979 .

[3]  Edward Babb,et al.  Implementing a relational database by means of specialzed hardware , 1979, TODS.

[4]  Leonard D. Shapiro,et al.  Join processing in database systems with large main memories , 1986, TODS.

[5]  Carlo H. Séquin,et al.  Hypertree: A Multiprocessor Interconnection Topology , 1981, IEEE Transactions on Computers.

[6]  David J. DeWitt,et al.  Processor allocation strategies for multiprocessor database machines , 1981, TODS.

[7]  Raymond T. Ng,et al.  Very large data bases , 1994 .

[8]  Abd-Elfattah M. Abd-Alla,et al.  Principles of digital computer design , 1976 .

[9]  Philip S. Yu,et al.  On parallel execution of multiple pipelined hash joins , 1994, SIGMOD '94.

[10]  Miron Livny,et al.  Partially preemptible hash joins , 1993, SIGMOD Conference.

[11]  Stanley Y. W. Su,et al.  Database computers: principle, architectures & techniques , 1988 .

[12]  Patrick Valduriez,et al.  Join and Semijoin Algorithms for a Multiprocessor Database Machine , 1984, TODS.

[13]  Dong Keun Shin.  A comparative study of hash functions for a new hash-based relational join algorithm , 1991 .

[14]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[15]  David J. DeWitt,et al.  Parallel algorithms for the execution of relational database operations , 1983, TODS.

[16]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[17]  Stanley Y. W. Su,et al.  Database computers : principles, architectures, and techniques , 1988 .

[18]  David J. DeWitt,et al.  Multiprocessor Hash-Based Join Algorithms , 1985, VLDB.

[19]  David K. Hsiao,et al.  Advanced Database Machine Architecture , 1983, Advanced Database Machine Architecture.

[20]  M. W. Blasgen,et al.  Storage and Access in Relational Data Bases , 1977, IBM Syst. J..