Materialize/doc/developer/design/static/qgm/simple-cross-join.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.43.0 (0)
 -->
<!-- Title: G Pages: 1 -->
<svg width="501pt" height="388pt"
 viewBox="0.00 0.00 501.00 388.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 384)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-384 497,-384 497,4 -4,4"/>
<text text-anchor="middle" x="140.5" y="-7.8" font-family="Times,serif" font-size="14.00">select * from t1, t2; (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="27,-171 27,-372 485,-372 485,-171 27,-171"/>
<text text-anchor="middle" x="77.5" y="-356.8" font-family="Times,serif" font-size="14.00">Box0:Select</text>
</g>
<g id="clust3" class="cluster">
<title>cluster2</title>
<polygon fill="none" stroke="black" points="178,-31 178,-163 340,-163 340,-31 178,-31"/>
<text text-anchor="middle" x="254" y="-147.8" font-family="Times,serif" font-size="14.00">Box2:BaseTable T2</text>
</g>
<g id="clust5" class="cluster">
<title>cluster1</title>
<polygon fill="none" stroke="black" points="8,-31 8,-163 170,-163 170,-31 8,-31"/>
<text text-anchor="middle" x="84" y="-147.8" font-family="Times,serif" font-size="14.00">Box1:BaseTable T1</text>
</g>
<!-- boxhead0 -->
<g id="node1" class="node">
<title>boxhead0</title>
<polygon fill="none" stroke="black" points="331,-179.5 331,-340.5 477,-340.5 477,-179.5 331,-179.5"/>
<text text-anchor="middle" x="404" y="-325.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="331,-317.5 477,-317.5 "/>
<text text-anchor="middle" x="404" y="-302.3" font-family="Times,serif" font-size="14.00">0: Q0.c0 as F1</text>
<polyline fill="none" stroke="black" points="331,-294.5 477,-294.5 "/>
<text text-anchor="middle" x="404" y="-279.3" font-family="Times,serif" font-size="14.00">1: Q0.c1 as F2</text>
<polyline fill="none" stroke="black" points="331,-271.5 477,-271.5 "/>
<text text-anchor="middle" x="404" y="-256.3" font-family="Times,serif" font-size="14.00">2: Q0.c2 as F3</text>
<polyline fill="none" stroke="black" points="331,-248.5 477,-248.5 "/>
<text text-anchor="middle" x="404" y="-233.3" font-family="Times,serif" font-size="14.00">3: Q1.c0 as F1</text>
<polyline fill="none" stroke="black" points="331,-225.5 477,-225.5 "/>
<text text-anchor="middle" x="404" y="-210.3" font-family="Times,serif" font-size="14.00">4: Q1.c1 as F2</text>
<polyline fill="none" stroke="black" points="331,-202.5 477,-202.5 "/>
<text text-anchor="middle" x="404" y="-187.3" font-family="Times,serif" font-size="14.00">5: Q1.c2 as F3</text>
</g>
<!-- Q0 -->
<g id="node2" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="100" cy="-260" rx="64.99" ry="64.99"/>
<text text-anchor="middle" x="100" y="-256.3" font-family="Times,serif" font-size="14.00">Q0(F) as T1</text>
</g>
<!-- boxhead1 -->
<g id="node5" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16,-39.5 16,-131.5 162,-131.5 162,-39.5 16,-39.5"/>
<text text-anchor="middle" x="89" y="-116.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="16,-108.5 162,-108.5 "/>
<text text-anchor="middle" x="89" y="-93.3" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="16,-85.5 162,-85.5 "/>
<text text-anchor="middle" x="89" y="-70.3" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="16,-62.5 162,-62.5 "/>
<text text-anchor="middle" x="89" y="-47.3" font-family="Times,serif" font-size="14.00">2: c2 as F3</text>
</g>
<!-- Q0&#45;&gt;boxhead1 -->
<g id="edge1" class="edge">
<title>Q0&#45;&gt;boxhead1</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M95.9,-194.77C95.24,-184.41 94.55,-173.61 93.88,-163"/>
</g>
<!-- Q1 -->
<g id="node3" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="248" cy="-260" rx="64.99" ry="64.99"/>
<text text-anchor="middle" x="248" y="-256.3" font-family="Times,serif" font-size="14.00">Q1(F) as T2</text>
</g>
<!-- boxhead2 -->
<g id="node4" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="186,-39.5 186,-131.5 332,-131.5 332,-39.5 186,-39.5"/>
<text text-anchor="middle" x="259" y="-116.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="186,-108.5 332,-108.5 "/>
<text text-anchor="middle" x="259" y="-93.3" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="186,-85.5 332,-85.5 "/>
<text text-anchor="middle" x="259" y="-70.3" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="186,-62.5 332,-62.5 "/>
<text text-anchor="middle" x="259" y="-47.3" font-family="Times,serif" font-size="14.00">2: c2 as F3</text>
</g>
<!-- Q1&#45;&gt;boxhead2 -->
<g id="edge2" class="edge">
<title>Q1&#45;&gt;boxhead2</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M252.1,-194.77C252.76,-184.41 253.45,-173.61 254.12,-163"/>
</g>
</g>
</svg>