Jump to content

File:Comparison of join algorithms.png

Page contents not supported in other languages.
This is a file from the Wikimedia Commons
From Wikipedia, the free encyclopedia

Original file (1,955 × 1,155 pixels, file size: 122 KB, MIME type: image/png)

Summary

Description
English: An illustration of properties of algorithms for computing a relational join. When performing a join between more than two relations on more than two attributes, binary join algorithms such as hash join operate over two relations at a time, and join them on all attributes in the join condition; worst-case optimal algorithms such as generic join operate on a single attribute at a time but join all the relations on this attribute. The diagram is from the paper "Free Join: Unifying Worst-Case Optimal and Traditional Joins" by Yisu Remy Wang, Max Willsey, and Dan Suciu
Date
Source https://arxiv.org/e-print/2301.10841
Author Yisu Remy Wang, Max Willsey, Dan Suciu
This diagram image could be re-created using vector graphics as an SVG file. This has several advantages; see Commons:Media for cleanup for more information. If an SVG form of this image is available, please upload it and afterwards replace this template with {{vector version available|new image name}}.


It is recommended to name the SVG file “Comparison of join algorithms.svg”—then the template Vector version available (or Vva) does not need the new image name parameter.

Licensing

w:en:Creative Commons
attribution
This file is licensed under the Creative Commons Attribution 4.0 International license.
You are free:
  • to share – to copy, distribute and transmit the work
  • to remix – to adapt the work
Under the following conditions:
  • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

Captions

An illustration of properties of algorithms for computing a relational join

Items portrayed in this file

depicts

25 January 2023

image/png

5bf074ebe58567867b632b22c49ca7b3895512d1

124,912 byte

1,155 pixel

1,955 pixel

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current16:25, 4 March 2023Thumbnail for version as of 16:25, 4 March 20231,955 × 1,155 (122 KB)SiddharthistImprove quality
16:23, 4 March 2023Thumbnail for version as of 16:23, 4 March 2023391 × 231 (11 KB)SiddharthistUploaded a work by Yisu Remy Wang, Max Willsey, Dan Suciu from https://arxiv.org/e-print/2301.10841 with UploadWizard

The following 2 pages use this file: