Immediate Maintenance of Materialized Views

A system for immediately updating a materialized view in a relational database management system, comprising:

• a first creating module for creating a materialized view defined over a base table;
• an executing module for executing an update statement on the base table;
• a first computing module for computing a delta of the base table by comparing images of the base table before execution of the update statement and after execution of the update statement;
• a second computing module for computing a delta of the materialized view based on the delta of the base table;
• and
• an updating module for updating the materialized view using the delta of the materialized view.

A computer program product comprising a computer-usable medium having computer program logic recorded thereon for enabling a processor to immediately update a materialized view in a relational database management system, the computer program logic comprising:

• first creating means for enabling a processor to create a materialized view defined over a base table;
• executing means for enabling a processor to execute an update statement on the base table;
• first computing means for enabling a processor to compute a delta of the base table by comparing images of the base table before execution of the update statement and after execution of the update statement;
• second computing means for enabling a processor to compute a delta of the materialized view based on the delta of the base table;
• and
• updating means for enabling a processor to update the materialized view using the delta of the materialized view.