Design and Selection of Materialized Views in a Data Warehousing Environment: A Case Study

In this paper, we describe the design of a data warehousing system for an engineering company ‘R’. This system aims to assist users in retrieving data for business analysis in an efficient manner. The structural design of this data warehousing system employs the dimensional modeling concepts of star and snowflake schemes. Furthermore, frequently accessed dimension keys and attributes are stored in various summary views (materialized views) in order to minimize the query processing cost. A cost model was developed to enable the evaluation of the total cost and benefit 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. This algorithm takes into account all of the cost variables associated with the materialized views selection method, including query access frequencies, base-data update frequencies, query access costs, view maintenance costs and the...

• Type: Conference
• Year: 1999
• Where: DOLAP
• Authors: Goretti K. Y. Chan, Qing Li, Ling Feng
• Keywords: Data Warehousing, DOLAP 1999, Information Management, Materialized Views, Total Cost