View Matching for Outer-Join Views

Prior work on computing queries from materialized views has focused on views defined by expressions consisting of selection, projection, and inner joins, with an optional aggregation on top (SPJG views). This paper provides the first view matching algorithm for views that may also contain outer joins (SPOJG views). The algorithm relies on a normal form for SPOJ expressions and does not use bottomup syntactic matching of expressions. It handles any combination of inner and outer joins, deals correctly with SQL bag semantics and exploits not-null constraints, uniqueness constraints and foreign key constraints.

• Type: Conference
• Year: 2005
• Where: VLDB
• Authors: Per-Åke Larson, Jingren Zhou
• Keywords: Database, Inner Joins, Outer Joins, View Matching Algorithm, VLDB 2005