TY - GEN
T1 - Reducing algorithms for materialized view updates
AU - Furukawa, Tetsuya
AU - Sha, Fei
PY - 1998/1/1
Y1 - 1998/1/1
N2 - Materialized views, which are used for such as data warehousing, have to be consistent with their original data. They are updated according to updates of the original data. Materialized view updates, however, become complicated when the view definition includes projection because one view data corresponds to several original data. This paper shows incremental view update algorithms when a materialized view defined with projection is updated. The algorithms proposed in this paper reduce the intermediate results by checking as early as possible whether the view data corresponding the updated original data indeed have to be updated. The paper also gives algorithms for multiple updates, which can realize deferred updates.
AB - Materialized views, which are used for such as data warehousing, have to be consistent with their original data. They are updated according to updates of the original data. Materialized view updates, however, become complicated when the view definition includes projection because one view data corresponds to several original data. This paper shows incremental view update algorithms when a materialized view defined with projection is updated. The algorithms proposed in this paper reduce the intermediate results by checking as early as possible whether the view data corresponding the updated original data indeed have to be updated. The paper also gives algorithms for multiple updates, which can realize deferred updates.
UR - http://www.scopus.com/inward/record.url?scp=84957808047&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=84957808047&partnerID=8YFLogxK
U2 - 10.1007/978-3-540-49524-6_30
DO - 10.1007/978-3-540-49524-6_30
M3 - Conference contribution
AN - SCOPUS:84957808047
SN - 3540651896
SN - 9783540651895
T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
SP - 377
EP - 392
BT - Conceptual Modeling - ER 1998 - 17th International Conference on Conceptual Modeling, Proceedings
A2 - Ram, Sudha
A2 - Ling, Tok Wang
A2 - Lee, Mong Li
PB - Springer Verlag
T2 - 17th International Conference on Conceptual Modeling, ER 1998
Y2 - 16 November 1998 through 19 November 1998
ER -