A maintainable model of materialized view based on data warehouse
Xueyu Huang, Qisheng Chen · 2011
Based on operator SPJ (Select-Project-Join) and the technology of self-maintainable view, this paper proposes a new maintainable model of materialized view; the proposed model contains two processes: the monitoring process and maintenance process, the first process is used to monitor the changes of basic tables; while the second process will automatically update the materialized view by auxiliary view, the results show that it can make the materialized view self-maintainable and reduce the storage space.