Design and selection of materialized views in a data warehousing environment: a case study
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses
IEEE Transactions on Knowledge and Data Engineering
Algorithms for Materialized View Design in Data Warehousing Environment
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Efficient approaches for materialized views selection in a data warehouse
Information Sciences: an International Journal
Information Sciences: an International Journal
A survey of view selection methods
ACM SIGMOD Record
A new scale for attribute dependency in large database systems
CISIM'12 Proceedings of the 11th IFIP TC 8 international conference on Computer Information Systems and Industrial Management
Hi-index | 0.00 |
Data warehouses are accessed by different queries with different frequencies. The portions of data accessed by a query can be treated as a view. When these views are related to each other and defined over overlapping portions of the base data, then it may be more efficient not to materialize all the views, but rather to materialize certain ``shared views'' from which the query results can be generated. In this paper, we address some issues related to determining this set of shared views to be materialized in order to achieve the best combination of good performance and low maintenance, and provide an algorithm for achieving this goal.