DocumentCode
2277803
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
fYear
1993
fDate
19-23 Apr 1993
Firstpage
190
Lastpage
197
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 1993. Proceedings. Ninth International Conference on
Conference_Location
Vienna
Print_ISBN
0-8186-3570-3
Type
conf
DOI
10.1109/ICDE.1993.344063
Filename
344063
Link To Document