A performance analysis of view materialization strategies
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Optimal update policies for distributed materialized views
Management Science
View maintenance in a warehousing environment
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Implementing data cubes efficiently
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
A framework for supporting data integration using the materialized and virtual approaches
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Supporting multiple view maintenance policies
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Efficient view maintenance at data warehouses
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
An alternative storage organization for ROLAP aggregate views based on cubetrees
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Analytical modeling of materialized view maintenance
Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Efficient refreshment of materialized views with multiple sources
Proceedings of the eighth international conference on Information and knowledge management
The Strobe algorithms for multi-source warehouse consistency
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
Making views self-maintainable for data warehousing
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
Updating Distributed Materialized Views
IEEE Transactions on Knowledge and Data Engineering
Data Integration using Self-Maintainable Views
EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
A Systematic Approach to Selecting Maintenance Policies in a Data Warehouse Environment
EDBT '02 Proceedings of the 8th International Conference on Extending Database Technology: Advances in Database Technology
Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Implementation and Comparative Evaluation of Maintenance Policies in a Data Warehouse Environment
BNCOD 19 Proceedings of the 19th British National Conference on Databases: Advances in Databases
Incremental maintenance of consistent data warehouses
Incremental maintenance of consistent data warehouses
| Hi-index | 0.00 |
This work addresses data warehouse maintenance, i.e. how changes to autonomous, heterogeneous, and distributed sources should be detected and propagated to a warehouse. The research community has mainly addressed issues relating to the internal operation of data warehouse servers. Work related to data warehouse maintenance has received less attention and only a limited set of maintenance alternatives are considered while ignoring the autonomy and heterogeneity of sources.In this paper, we extend work on single source view maintenance to views with multiple heterogeneous sources. We present a tool (PAM) which allows for comparison of a large number of relevant maintenance policies under different configurations. Based on such analysis and previous studies we propose a set of heuristics to guide in policy selection. The quality of these heuristics is evaluated empirically using a test-bed developed for this purpose. This is done for a number of different criteria and for different data sources and computer systems. The performance gained using the policy selected through the heuristics is compared with the performance of all identified policies. Based on these experiments we claim that heuristic-based selections are good.