Optimized design of materialized views in a real-life data warehousing environment

@inproceedings{Chan2001OptimizedDO,
  title={Optimized design of materialized views in a real-life data warehousing environment},
  author={Gorettiv K. Y. Chan and Qiming Li and Ling Feng},
  year={2001}
}
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… CONTINUE READING

Citations

Publications citing this paper.
SHOWING 1-9 OF 9 CITATIONS

Similar Papers

Loading similar papers…