Hash join: Difference between revisions
Content added Content deleted
(→{{header|Tcl}}: Some extra notes) |
(Revised the task description to give the sample data to use) |
||
Line 21: | Line 21: | ||
'''place''' relation in ''Q'' |
'''place''' relation in ''Q'' |
||
Task: implement the Hash Join algorithm and show the result of joining two tables with it. |
'''Task:''' implement the Hash Join algorithm and show the result of joining two tables with it. |
||
You should use your implementation to show the joining of these tables: |
|||
<table><tr><td><table border> |
|||
<tr><th>Age</th><th>Name</th></tr> |
|||
<tr><td>27</td><td>Jonah</td></tr> |
|||
<tr><td>18</td><td>Alan</td></tr> |
|||
<tr><td>28</td><td>Glory</td></tr> |
|||
<tr><td>18</td><td>Popeye</td></tr> |
|||
<tr><td>28</td><td>Alan</td></tr> |
|||
</table></td><td><table border> |
|||
<tr><th>Name</th><th>Nemesis</th></tr> |
|||
<tr><td>Jonah</td><td>Whales</td></tr> |
|||
<tr><td>Jonah</td><td>Spiders</td></tr> |
|||
<tr><td>Alan</td><td>Ghosts</td></tr> |
|||
<tr><td>Alan</td><td>Zombies</td></tr> |
|||
<tr><td>Glory</td><td>Buffy</td></tr> |
|||
</table></td></tr></table> |
|||
=={{header|Common Lisp}}== |
=={{header|Common Lisp}}== |