TY - GEN
T1 - Design and selection of materialized views in a data warehousing environment
T2 - 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
AU - Chan, Goretti K.Y.
AU - Li, Qing
AU - Feng, Ling
PY - 1999/11/6
Y1 - 1999/11/6
N2 - In this paper, we describe the design of a data warehousing system for an engineering company 'R'. A cost model was developed for this system to enable the evaluation of the total costs and benefits involved in selecting each materialized view. Using the cost analysis methodology for evaluation, an adapted greedy algorithm has been implemented for the selection of materialized views. The algorithm and cost model were applied to a set of real-life database items extracted from company 'R'. By selecting the most cost effective set of materialized summary views, the total of the maintenance, storage and query costs of the system is optimized, thereby resulting in an efficient data warehousing system. Copyright ACM 1999.
AB - In this paper, we describe the design of a data warehousing system for an engineering company 'R'. A cost model was developed for this system to enable the evaluation of the total costs and benefits involved in selecting each materialized view. Using the cost analysis methodology for evaluation, an adapted greedy algorithm has been implemented for the selection of materialized views. The algorithm and cost model were applied to a set of real-life database items extracted from company 'R'. By selecting the most cost effective set of materialized summary views, the total of the maintenance, storage and query costs of the system is optimized, thereby resulting in an efficient data warehousing system. Copyright ACM 1999.
UR - http://www.scopus.com/inward/record.url?scp=0013153962&partnerID=8YFLogxK
U2 - 10.1145/319757.319787
DO - 10.1145/319757.319787
M3 - Conference article published in proceeding or book
AN - SCOPUS:0013153962
T3 - DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP
SP - 42
EP - 47
BT - Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
PB - Association for Computing Machinery
Y2 - 2 November 1999 through 6 November 1999
ER -