Title
An Efficient View Maintenance Algorithm for Data Warehousing
Abstract
We first present a brief analysis of current issues on view maintenance problem for data warehousing. Then, we present an efficient view maintenance algorithm to maintain the materialized view of a data warehouse system. In our approach, a mechanism is provided to detect maintenance anomaly even if messages are delivered in a different order from their generated order. Our approach enforces complete consistency of the materialized view in the sense that every logical state of base relations is reflected as a distinct state of the materialized view. We conclude that our approach is efficient in two aspects: (1) maintenance queries for multiple update transactions are executed in parallel instead of in sequential approach; (2) any maintenance anomaly occurs during the maintenance query execution for some update transaction is removed locally at the data warehouse and no extra queries need to be sent to any base relation.
Year
Venue
Keywords
1998
ER Workshops
data warehousing,efficient view maintenance algorithm
Field
DocType
Volume
Data warehouse,Data mining,Computer science,Algorithm,View maintenance,Database transaction,Materialized view,Database
Conference
1552
ISSN
ISBN
Citations 
0302-9743
3-540-65690-1
7
PageRank 
References 
Authors
5.26
9
2
Name
Order
Citations
PageRank
Tok Wang Ling12449624.70
Ye Liu2910.07