A maintenance algorithm of materialized view in data warehouse
Qing Guo
Abstract
Qing Guo
Abstract
Implement of materialized view is a key technology and efficient solution of advancing system response time.But the maintenance problem of materialized view is involved.Because source data is 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 will be fall down and the authenticity and consistency of OLAP will be affected.For the maintenance problem of materialized view,an algorithm is presented and it can make the cost of materialized view recomputation be minimized.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
Implement of materialized view is a key technology and efficient solution of advancing system response time.But the maintenance problem of materialized view is involved.Because source data is 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 will be fall down and the authenticity and consistency of OLAP will be affected.For the maintenance problem of materialized view,an algorithm is presented and it can make the cost of materialized view recomputation be minimized.
Key concepts: Materialized view, Data warehouse, Computer science, Online analytical processing, Consistency (knowledge bases), Key (lock), Database, Data mining