Reducing Maintenance Query Cost of Materialized View by Source Relations Compensation

To resolve the problem of the high calculation and transmission cost caused by correcting the maintenance query based on compensation queries when incrementally maintaining materialized view in distributed environments,a view maintenance schema called source relations compensation maintenance(SRCM) was proposed.It pushed back related relations to the required states by compensating concurrent update conflicts,and directly evaluated and returned correct query results.Results of the analysis based on the cost model and imitation experiment show that SRCM effectively reduces the overall cost of maintenance queries compared with previous SWEEP and MEDWRAP compensation solutions.