Materialize/doc/developer/design/static/qgm/normalized-outer-joins.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="822pt" height="670pt"
 viewBox="0.00 0.00 822.00 669.99" 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 665.99)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-665.99 818,-665.99 818,4 -4,4"/>
<text text-anchor="middle" x="372" y="-7.8" font-family="Times,serif" font-size="14.00">select * from t1 left join t3 on t1.f1 = t3.f1 left join t2 on t1.f1 = t2.f1; (with normalized outer joins)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="245,-383.99 245,-653.99 683,-653.99 683,-383.99 245,-383.99"/>
<text text-anchor="middle" x="295.5" y="-638.79" font-family="Times,serif" font-size="14.00">Box0:Select</text>
</g>
<g id="clust3" class="cluster">
<title>cluster1</title>
<polygon fill="none" stroke="black" points="8,-182 8,-350.99 318,-350.99 318,-182 8,-182"/>
<text text-anchor="middle" x="70.5" y="-335.79" font-family="Times,serif" font-size="14.00">Box1:OuterJoin</text>
</g>
<g id="clust5" class="cluster">
<title>cluster5</title>
<polygon fill="none" stroke="black" points="164,-31 164,-163 326,-163 326,-31 164,-31"/>
<text text-anchor="middle" x="240" y="-147.8" font-family="Times,serif" font-size="14.00">Box5:BaseTable T2</text>
</g>
<g id="clust7" class="cluster">
<title>cluster2</title>
<polygon fill="none" stroke="black" points="326,-182 326,-350.99 636,-350.99 636,-182 326,-182"/>
<text text-anchor="middle" x="388.5" y="-335.79" font-family="Times,serif" font-size="14.00">Box2:OuterJoin</text>
</g>
<g id="clust9" class="cluster">
<title>cluster4</title>
<polygon fill="none" stroke="black" points="482,-31 482,-163 644,-163 644,-31 482,-31"/>
<text text-anchor="middle" x="558" y="-147.8" font-family="Times,serif" font-size="14.00">Box4:BaseTable T3</text>
</g>
<g id="clust11" class="cluster">
<title>cluster3</title>
<polygon fill="none" stroke="black" points="644,-200.49 644,-332.49 806,-332.49 806,-200.49 644,-200.49"/>
<text text-anchor="middle" x="720" y="-317.29" font-family="Times,serif" font-size="14.00">Box3:BaseTable T1</text>
</g>
<!-- boxhead0 -->
<g id="node1" class="node">
<title>boxhead0</title>
<polygon fill="none" stroke="black" points="529,-392.49 529,-622.49 675,-622.49 675,-392.49 529,-392.49"/>
<text text-anchor="middle" x="602" y="-607.29" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="529,-599.49 675,-599.49 "/>
<text text-anchor="middle" x="602" y="-584.29" font-family="Times,serif" font-size="14.00">0: Q4.c0 as F1</text>
<polyline fill="none" stroke="black" points="529,-576.49 675,-576.49 "/>
<text text-anchor="middle" x="602" y="-561.29" font-family="Times,serif" font-size="14.00">1: Q4.c1 as F2</text>
<polyline fill="none" stroke="black" points="529,-553.49 675,-553.49 "/>
<text text-anchor="middle" x="602" y="-538.29" font-family="Times,serif" font-size="14.00">2: Q4.c2 as F3</text>
<polyline fill="none" stroke="black" points="529,-530.49 675,-530.49 "/>
<text text-anchor="middle" x="602" y="-515.29" font-family="Times,serif" font-size="14.00">3: Q0.c0 as F1</text>
<polyline fill="none" stroke="black" points="529,-507.49 675,-507.49 "/>
<text text-anchor="middle" x="602" y="-492.29" font-family="Times,serif" font-size="14.00">4: Q0.c1 as F2</text>
<polyline fill="none" stroke="black" points="529,-484.49 675,-484.49 "/>
<text text-anchor="middle" x="602" y="-469.29" font-family="Times,serif" font-size="14.00">5: Q0.c2 as F3</text>
<polyline fill="none" stroke="black" points="529,-461.49 675,-461.49 "/>
<text text-anchor="middle" x="602" y="-446.29" font-family="Times,serif" font-size="14.00">6: Q2.c0 as F1</text>
<polyline fill="none" stroke="black" points="529,-438.49 675,-438.49 "/>
<text text-anchor="middle" x="602" y="-423.29" font-family="Times,serif" font-size="14.00">7: Q2.c1 as F2</text>
<polyline fill="none" stroke="black" points="529,-415.49 675,-415.49 "/>
<text text-anchor="middle" x="602" y="-400.29" font-family="Times,serif" font-size="14.00">8: Q2.c2 as F3</text>
</g>
<!-- Q0 -->
<g id="node2" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="290" cy="-507.49" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="290" y="-503.79" font-family="Times,serif" font-size="14.00">Q0(F)</text>
</g>
<!-- boxhead1 -->
<g id="node5" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16,-208.99 16,-300.99 162,-300.99 162,-208.99 16,-208.99"/>
<text text-anchor="middle" x="89" y="-285.79" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="16,-277.99 162,-277.99 "/>
<text text-anchor="middle" x="89" y="-262.79" font-family="Times,serif" font-size="14.00">0: Q3.c0 as F1</text>
<polyline fill="none" stroke="black" points="16,-254.99 162,-254.99 "/>
<text text-anchor="middle" x="89" y="-239.79" font-family="Times,serif" font-size="14.00">1: Q3.c1 as F2</text>
<polyline fill="none" stroke="black" points="16,-231.99 162,-231.99 "/>
<text text-anchor="middle" x="89" y="-216.79" font-family="Times,serif" font-size="14.00">3: Q3.c2 as F3</text>
</g>
<!-- Q0&#45;&gt;boxhead1 -->
<g id="edge6" class="edge">
<title>Q0&#45;&gt;boxhead1</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M266.94,-477.75C242.17,-446.88 201.45,-396.14 165.22,-350.98"/>
</g>
<!-- Q2 -->
<g id="node3" class="node">
<title>Q2</title>
<ellipse fill="none" stroke="black" cx="382" cy="-507.49" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="382" y="-503.79" font-family="Times,serif" font-size="14.00">Q2(F)</text>
</g>
<!-- boxhead2 -->
<g id="node8" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="334,-208.99 334,-300.99 480,-300.99 480,-208.99 334,-208.99"/>
<text text-anchor="middle" x="407" y="-285.79" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="334,-277.99 480,-277.99 "/>
<text text-anchor="middle" x="407" y="-262.79" font-family="Times,serif" font-size="14.00">0: Q1.c0 as F1</text>
<polyline fill="none" stroke="black" points="334,-254.99 480,-254.99 "/>
<text text-anchor="middle" x="407" y="-239.79" font-family="Times,serif" font-size="14.00">1: Q1.c1 as F2</text>
<polyline fill="none" stroke="black" points="334,-231.99 480,-231.99 "/>
<text text-anchor="middle" x="407" y="-216.79" font-family="Times,serif" font-size="14.00">2: Q1.c2 as F3</text>
</g>
<!-- Q2&#45;&gt;boxhead2 -->
<g id="edge7" class="edge">
<title>Q2&#45;&gt;boxhead2</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M385.31,-470.41C388.07,-440.54 392.17,-396.99 396,-358.99 396.27,-356.35 396.54,-353.68 396.81,-350.98"/>
</g>
<!-- Q4 -->
<g id="node4" class="node">
<title>Q4</title>
<ellipse fill="none" stroke="black" cx="474" cy="-507.49" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="474" y="-503.79" font-family="Times,serif" font-size="14.00">Q4(F)</text>
</g>
<!-- Q3 -->
<g id="node6" class="node">
<title>Q3</title>
<ellipse fill="none" stroke="black" cx="245" cy="-254.99" rx="64.99" ry="64.99"/>
<text text-anchor="middle" x="245" y="-251.29" font-family="Times,serif" font-size="14.00">Q3(F) as T2</text>
</g>
<!-- Q4&#45;&gt;Q3 -->
<g id="edge1" class="edge">
<title>Q4&#45;&gt;Q3</title>
<path fill="none" stroke="black" d="M469.18,-470.69C463.69,-443.4 452.12,-406.76 428,-383.99 410.06,-367.05 342.42,-364.83 322,-350.99 306.01,-340.15 291.66,-325.01 279.8,-310"/>
<text text-anchor="middle" x="469.5" y="-362.79" font-family="Times,serif" font-size="14.00">(Q4.c0) = (Q3.c0)</text>
</g>
<!-- Q1 -->
<g id="node9" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="563" cy="-254.99" rx="64.99" ry="64.99"/>
<text text-anchor="middle" x="563" y="-251.29" font-family="Times,serif" font-size="14.00">Q1(F) as T3</text>
</g>
<!-- Q4&#45;&gt;Q1 -->
<g id="edge2" class="edge">
<title>Q4&#45;&gt;Q1</title>
<path fill="none" stroke="black" d="M479.94,-470.78C486,-444.08 497.8,-408.17 520,-383.99 526.99,-376.37 534.7,-382.18 541,-373.99 552.75,-358.71 558.88,-339.06 561.92,-320.21"/>
<text text-anchor="middle" x="611.5" y="-362.79" font-family="Times,serif" font-size="14.00">(Q4.c0) = (Q1.c0)</text>
</g>
<!-- boxhead3 -->
<g id="node11" class="node">
<title>boxhead3</title>
<polygon fill="none" stroke="black" points="652,-208.99 652,-300.99 798,-300.99 798,-208.99 652,-208.99"/>
<text text-anchor="middle" x="725" y="-285.79" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="652,-277.99 798,-277.99 "/>
<text text-anchor="middle" x="725" y="-262.79" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="652,-254.99 798,-254.99 "/>
<text text-anchor="middle" x="725" y="-239.79" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="652,-231.99 798,-231.99 "/>
<text text-anchor="middle" x="725" y="-216.79" font-family="Times,serif" font-size="14.00">2: c2 as F3</text>
</g>
<!-- Q4&#45;&gt;boxhead3 -->
<g id="edge4" class="edge">
<title>Q4&#45;&gt;boxhead3</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M477.18,-470.45C481.75,-442.07 492.89,-404.06 520,-383.99 548.27,-363.05 649.52,-394.64 678,-373.99 692.12,-363.75 702,-348.57 708.91,-332.49"/>
</g>
<!-- boxhead5 -->
<g id="node7" class="node">
<title>boxhead5</title>
<polygon fill="none" stroke="black" points="172,-39.5 172,-131.5 318,-131.5 318,-39.5 172,-39.5"/>
<text text-anchor="middle" x="245" y="-116.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="172,-108.5 318,-108.5 "/>
<text text-anchor="middle" x="245" y="-93.3" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="172,-85.5 318,-85.5 "/>
<text text-anchor="middle" x="245" y="-70.3" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="172,-62.5 318,-62.5 "/>
<text text-anchor="middle" x="245" y="-47.3" font-family="Times,serif" font-size="14.00">2: c2 as F3</text>
</g>
<!-- Q3&#45;&gt;boxhead5 -->
<g id="edge3" class="edge">
<title>Q3&#45;&gt;boxhead5</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M245,-189.72C245,-180.97 245,-171.93 245,-163"/>
</g>
<!-- boxhead4 -->
<g id="node10" class="node">
<title>boxhead4</title>
<polygon fill="none" stroke="black" points="490,-39.5 490,-131.5 636,-131.5 636,-39.5 490,-39.5"/>
<text text-anchor="middle" x="563" y="-116.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="490,-108.5 636,-108.5 "/>
<text text-anchor="middle" x="563" y="-93.3" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="490,-85.5 636,-85.5 "/>
<text text-anchor="middle" x="563" y="-70.3" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="490,-62.5 636,-62.5 "/>
<text text-anchor="middle" x="563" y="-47.3" font-family="Times,serif" font-size="14.00">2: c2 as F3</text>
</g>
<!-- Q1&#45;&gt;boxhead4 -->
<g id="edge5" class="edge">
<title>Q1&#45;&gt;boxhead4</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M563,-189.72C563,-180.97 563,-171.93 563,-163"/>
</g>
</g>
</svg>