PPT Slide

Previous slide

Next slide

Back to first slide

View graphic version

Our unnesting algorithm converts the reductions of the inner boxes into group-by operators, the joins into outerjoins, and at the end, it embeds the operators in the point immediately before they are used. The output of the group-by operator corresponds to a range variable, which is used in place of the small dark boxes.