数据仓库中实体化数据视图的一种维护技术

A Maintenance Technology of Materialized View in Data Warehouse

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

Implement of materialized view was a key technology and efficient solution of advancing system response time. But the maintenance problem of materialized view was faced. Because source data was unsteadiness, the changes of data must be spread to materialized view and make it be consistency the changes of materialized view and source data. Otherwise the freshness of data in materialized view would be fall down and the authenticity and consistency of OLAP would be affected. For the maintenance problem of materialized view, maintenance algorithm was presented and it can make the cost of materialized view recompilation be minimized.