Data warehouse design and maintenance through view normalization

Abstract

Database design has always been a challenging problem, more so if the performance of queries is the prime goal. Thus, data warehouse design driven by queries is lot more difficult because of the materialized view selection and maintenance problems. Since user queries change over time, data warehouse design becomes a dynamic problem, that has to contain frequent changes to data warehouse design. In this paper, we advocate the applicability of view normalization technique to facilitate robust data warehouse design and facilitate efficient maintenance of materialized views.