Title :
Realization of the Data Warehouse Design and the Anti-normalization Design by Using PowerDesigner
Author :
Ma, Hui ; Zhang, Fan ; Wu, Yina
Author_Institution :
Inf. Coll., Capital Univ. of Econ. & Bus., Beijing, China
Abstract :
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.
Keywords :
data mining; data structures; data warehouses; relational databases; PowerDesigner visual design; antinormalization design; data mining system; data structure; data warehouse design; relational database; Business; Decision support systems; PowerDesigner; anti-normalization; conceptual data model; physical data model;
Conference_Titel :
Business Intelligence and Financial Engineering (BIFE), 2010 Third International Conference on
Conference_Location :
Hong Kong
Print_ISBN :
978-1-4244-7575-9
DOI :
10.1109/BIFE.2010.27
