Publisher review:Relational Join Algorithms script implements the three standard relational join algorithms. This script implements the three standard relational join algorithms: nested loops join, hash join, and merge join, using the iterator algebra support in Python.
This script also presents code that can be used for inner join, left outer join, full outer join, and semijoins. The nested loops join supports a theta join. & nested lemijoins are useful, especially in conjunction with hierarchical queries. In SQL, if supported, they are the efficient alternative to writing 'select distinct', although they make one's code difficult to understand by the unversed. Hopefully showing this with procedural code can make this useful feature less mysterious.
Relational Join Algorithms 1.0 is a Python script for Programming Methods and Algorithms scripts design by Jim Baker.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Relational Join Algorithms script implements the three standard relational join algorithms.
Operating system:Windows / Linux / Mac OS / BSD / Solaris