Data Warehouse Design and Maintenance through View Normalization

  • Authors:
  • Mukesh K. Mohania;Kamalakar Karlapalem;Yahiko Kambayashi

  • Affiliations:
  • -;-;-

  • Venue:
  • DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

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 diffcult 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 effcient maintenance of materialized views.