• 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