Materialized View Selection in Data Warehousing
Authors:
- 1 April 2007
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 843-847
Abstract
Everyday an enormous amount of data is retrieved and transmitted. To avoid the chaos, data mining and warehousing is used. A data warehouse is a set of materialized views defined over remote source relations. These materialized views must be maintained in response to actual relation updates in the remote sources. During the initial design and evolution of data warehouse, the designer has to handle problems of selecting views to materialize in the data warehouse. A design objective can be the minimization of a cost function or a constraint of available space. AND/OR DAG expression is used to represent alternative ways of evaluating multiple queries and views and sub expression sharing. Proposed approach can be used to optimize the views for the better performance of the data warehouseKeywords
This publication has 11 references indexed in Scilit:
- Selection of views to materialize in a data warehouseIEEE Transactions on Knowledge and Data Engineering, 2005
- Making views self-maintainable for data warehousing2002
- Incremental Design of a Data WarehouseJournal of Intelligent Information Systems, 2000
- Complex View Selection for Data Warehouse Self-MaintainabilityLecture Notes in Computer Science, 2000
- Making aggregate views self-maintainableData & Knowledge Engineering, 2000
- Implementing data cubes efficientlyACM SIGMOD Record, 1996
- Materialized view maintenance and integrity constraint checkingACM SIGMOD Record, 1996
- Incremental maintenance of views with duplicates1995
- Improvements on a heuristic algorithm for multiple-query optimizationData & Knowledge Engineering, 1994
- Multiple-query optimizationACM Transactions on Database Systems, 1988