2007Journal of Jinan UniversityRequires access

A maintenance algorithm of materialized view in data warehouse

Qing Guo

Open publisher page 0 citations

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.

About this research paper

What this paper is about

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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.

Key concepts: Materialized view, Data warehouse, Computer science, Online analytical processing, Consistency (knowledge bases), Key (lock), Database, Data mining

Related papers

Back to paper searchBrowse research topicsOriginal source
A maintenance algorithm of materialized view in data warehouse — Research Paper | ScholarLens