DocumentCode
2851928
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
fYear
2010
fDate
13-15 Aug. 2010
Firstpage
72
Lastpage
75
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Business Intelligence and Financial Engineering (BIFE), 2010 Third International Conference on
Conference_Location
Hong Kong
Print_ISBN
978-1-4244-7575-9
Type
conf
DOI
10.1109/BIFE.2010.27
Filename
5621732
Link To Document