Research problems in data warehousing
CIKM '95 Proceedings of the fourth international conference on Information and knowledge management
Materialized view maintenance and integrity constraint checking: trading space for time
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Physical Database Design for Data Warehouses
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Materialized Views Selection in a Multidimensional Database
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Algorithms for Materialized View Design in Data Warehousing Environment
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
View relevance driven materialized view selection in data warehousing environment
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
| Hi-index | 0.00 |
As a sufficiently abstract level, the data in the data warehouse can be seen as a set of materialized views, where the base data resides at the information sources. These materialized views are designed based on the users requirements (e.g., frequently asked queries). However Data Warehouse is a dynamic environment, i.e., when user query requirement changes, the existing materialized views should evolve to meet the new requirement. These changes will demand schema changes at the warehouse and should be handled with as little disruption or modification to other components of the warehousing system as possible.In this paper, we proposed a framework to determine if the existing materialized views will be affected by the requirement changes, and how they are affected. Algorithms are proposed to deal with the situation when a new query is added in. The aim of the algorithms are to efficiently get the new materialized views by analysing the relationships among queries using MVPP (a specification for query processing plan).