Sciweavers

Share
DOLAP
1999
ACM

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

10 years 2 months ago
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...
Goretti K. Y. Chan, Qing Li, Ling Feng
Added 02 Aug 2010
Updated 02 Aug 2010
Type Conference
Year 1999
Where DOLAP
Authors Goretti K. Y. Chan, Qing Li, Ling Feng
Comments (0)
books