Patent ID: 7467128
Filing Date: 2008-12-16
Classification: G06F,Y10S

Abstract:
1. A computer-implemented system that facilitates maintenance of a materialized outer-join view, comprising: a view creation component for creating a materialized view definition that includes at least one outer join of data in at least one base table for inclusion in the materialized outer-join view; and a maintenance component for updating at least a stored materialized selection, projection, and outer-join (SPOJ) view result associated with the materialized view definition, wherein the maintenance component determines which base table outer-join relationships are affected by a change in the at least one base table and wherein the update to the SPOJ view materialization reflects changes associated with the results of the at least one outer-join of data with the at least one base table based at least in part on the determination of a change in the base table affecting an outer join relationship.