Hi Wang,
As Stamatis said, the paper[1] indicates that the rewriting algorithm can
be extended to support
outer join. But I think it is not as easy as it says. Another paper[2] is
about how to support outer join
in rewriting. Hope it helps.
[1] http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.
Hi Wang,
The implementation of the rule based rewriting algorithm follows closely
the following research paper:
Optimizing Queries Using Materialized Views: A Practical, Scalable Solution
"The algorithm explained in this paper is limited to SPJG subexpressions
and single-table substitutes. Howeve