Adapting materialized views after redefinitions: techniques and a performance study
Information Systems - Data warehousing
View relevance driven materialized view selection in data warehousing environment
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
An evolutionary approach to materialized views selection in a datawarehouse environment
IEEE Transactions on Systems, Man, and Cybernetics, Part C: Applications and Reviews
A comprehensive study of view maintenance approaches in data warehousing evolution
ACM SIGSOFT Software Engineering Notes
| Hi-index | 0.00 |
A large number of materialized views are stored in data warehouse to enable users to quickly get search results for OLAP analysis. But when the remote basic data source changes, the materialized views in data warehouse are also updated correspondingly in order to maintain the consistency with basic relations, which causes materialized views maintenance issues. There are two methods for materialized views maintenance. One way is to re-compute the views, which can lead to extra large storage and maintenance cost and is sometimes unachievable due to storage limitation. So incremental maintenance technique is more preferable in recent years. Its principle is that data source reports its changes to the integrator who then calculates the corresponding changes and inform the database with the results. Incremental maintenance technique is adopted in this paper. The amount of incremental data is different for the same view when adopting different methods, which result in different maintenance costs. The idea and strategy of minimum incremental maintenance is presented. The materialized view definitions and maintenance expressions, as well as algorithms are given. The experiment shows that the maintenance cost of materialized views is decreased and data warehouse processing efficiency is improved.