Jump to content

Symmetric hash join

From Wikipedia, the free encyclopedia
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

The symmetric hash join is a special type of hash join designed for data streams.[1][2]

Algorithm

  • For each input, create a hash table.
  • For each new record, hash and insert into inputs hash table.
    • Test if input is equal to a predefined set of other inputs.
      • If so, output the records.

See also

References

  1. ^ "Issues in Data Stream Management" (PDF).
  2. ^ "University of Waterloo - Database Systems Implementation" (PDF).