Inferring a tree from lowest common ancestors with an application to the optimization of relational expressions - SIAM Journal on Compiting, 10(3), p.405-421, 1981 .

We present an algorithm for constructing a tree to satisfy a set of lineage constraints on common ancestors. We then apply this algorithm to synthesize a relational algebra expression from a simple tableau, a problem arising in the theory of relational databases.


TREE ALGORITHMS
LOWEST COMMON ANCESTORS
RELATIONAL DATABASES
RELATIONAL ALGEBRA
TABLEAUX
QUERY OPTIMIZATION
JOIN MINIMIZATION