Title :
A new algorithm for computing joins with grid files
Author :
Becker, Ludger ; Hinrichs, Klaus ; Finke, Ulrich
Author_Institution :
FB 15, Inf., Westfalische Wilhelms-Univ., Munster, Germany
Abstract :
The BR2-directory representation, a directory structure for grid files, and a join algorithm for the evaluation of general n -ary joins on grid files are presented. It is shown that the CPU cost of the join algorithm is successfully reduced by introducing an inner join. A comparison with the hash join algorithm and a join algorithm on k-d trees for equijoins is based on a cost model developed for query processing with grid files. The join algorithm outperforms the hash join, a specialized join method for equijoins, and the join algorithm on k-d trees for equijoins
Keywords :
file organisation; BR2-directory representation; CPU cost; directory structure; equijoins; grid files; hash join; inner join; join algorithm; k-d trees; performance; query processing; Algorithm design and analysis; Application software; Computer applications; Costs; Grid computing; Multidimensional systems; Object oriented modeling; Partitioning algorithms; Performance analysis; Robots;
Conference_Titel :
Data Engineering, 1993. Proceedings. Ninth International Conference on
Conference_Location :
Vienna
Print_ISBN :
0-8186-3570-3
DOI :
10.1109/ICDE.1993.344063