Construct · 1 fields · 1 citations

hash join: a standalone construct

One name. One construct. A landmark on the map.

● anchor · a standalone construct Nearest construct by meaning·not indexed

A single standalone construct; nearby constructs are located against it in the Collider. Tap a field for its definition, unit, and measures.

Database systems

joining two relations by building a hash table on one and probing it with the other, efficient for equality joins.

In database systems, hash join refers to joining two relations by building a hash table on one and probing it with the other, efficient for equality joins. This meaning comes from DeWitt (1984) in Proceedings of the 1984 ACM SIGMOD international conference on Management of data - SIGMOD '84.[1]

Unit
Recovery means
Measured by

Run it through the Collider, or take the citations with you.

See how hash join sits against neighbouring constructs in the Collider, or export every reference on this page in one click.

Open in Collider Export BibTeX Report this entry

Nearby constructs

hash2 fields · 3 citationsjingle · one word, two constructs join3 fields · 3 citationsjingle · one word, three constructs

References

DeWitt, D. J., Katz, R. H., Olken, F., Shapiro, L. D., Stonebraker, M. R., & Wood, D. (1984). Implementation techniques for main memory database systems. Proceedings of the 1984 ACM SIGMOD international conference on Management of data - SIGMOD '84. https://doi.org/10.1145/602259.602261

Cited on this page?

Confirm your construct, or correct us.

If your work is cited behind one of these entries, you know better than we do whether we captured the meaning right. Confirm it, suggest an edit, or dispute it, and your name goes on the entry as an author who has checked it, linked to your ORCID.

Claim your construct