Realization of the Data Warehouse Design and the Anti-normalization Design by Using PowerDesigner

摘要

Normalization is a basic principle when designing the relational database, which guarantees the revision of data structure and the quality of reorganization, but when referring to data mining system, anti-normalization is needed for data warehouse design. This paper discusses the necessity of anti-normalization and the typical design methods. At the same time, it explains how to realize the data warehouse design and the anti-normalization design by using PowerDesigner, so as to show the significance of PowerDesigner visual design.