数据仓库中实体化视图的一致性维护问题的研究

实现实体化视图是提高系统响应时间的一个关键技术和有效的解决方案，但在具体的实现过程中面临着实体化视图的一致性维护问题。由于源数据的不稳定性，其结构和数据的变化必须及时传播到实体化视图中，以保持实体化视图与源数据的变化一致性，否则会降低实体化视图中数据的新鲜度，并影响OLAP查询结果的真实性和有效性。为此本文针对视图的一致性维护问题，介绍了视图中数据的维护方法，同时还就实体化视图结构的维护，提出了使视图重计算代价最小化的解决方案和基本算法。

STUDY ON CONSISTENCY MAINTENANCE OF MATERIALIZED VIEW IN DATA WAREHOUSING

Implement of materialized view is a key technology and efficient solution of adv ancing system response time.But the problem of consistency maintenance of materi alized view is faced.Because source data is unsteadiness,the changes of structur e and data must be spread to materialized view and make it be consistency the ch anges of materialized view and source data.Otherwise the freshness of data in ma terialized view will be fall down and the authenticity and consistency of OLAP w ill be affected.For the consistency maintenance problem of materialized view,mai ntenance method is presented.For the maintenance problem of the structure of mat erialized view,the solution and algorithms is proposed that make the cost of mat erialized view recomputation be minimized.