System and method for real-time materialized view maintenance

A non-transitory computer readable storage medium comprising a computer readable program for maintaining a materialized view defined on a base relation of a relational database, wherein the computer readable program when executed on a computer causes the computer to perform the steps of:

• generating a materialized view in a materialized view maintenance system, implemented in a computing device having at least a processor and a memory device, that is defined on one or more base relations;
• generating a respective filtering relation for each base relation that captures a relationship among multiple join attributes of the base relation and includes a summary of attributes of the base relation, including all join attributes of the base relation that match a disjunctive-conjunctive equi-join condition on two base relations;
• determining whether each of a plurality of updates to base relations of the materialized view is irrelevant with respect to relations in the materialized view by performing content-based filtering on each update by joining filtering relations of base relations other than the updated base relation to updated tuples of the updated base relation to determine that no join result tuple is produced;
• and
• maintaining the materialized view in accordance with at least one of the updates, omitting at least one update that is determined to be irrelevant.