New Data Warehouse Designing Approach Based on Principal Component Analysis
Wafa Tebourski,Wahiba Karaa, Wahiba Karaa
Journal of E-Technology, Vol. 5, No. 3, 2014.
DOI: 
Link: http://www.dline.info/jet/fulltext/v5n3/1.pdf
Abstract:
Decision-making has become a strategic need for any business. Indeed, is among the capital business priorities. The establishment of decision information systems it facilitate the data exploitation and analysis. We distinguish
data warehouses as the core system of business intelligence to ensure the structuring and analysis of multidimensional data. Consequently, the design of data warehouses has become a major problem, leading to the development of appropriate
approaches to implement data warehouses. In this paper, we propose an approach to design and to construct data warehouses based on a descriptive statistics technique for the analysis of  multidimensional data in the Principal Components
Analysis (PCA). The findings of this article appear in two main areas: (i) a conceptual model data warehouse, (ii) an algorithm for the determination of measures and dimensions. A case study is used to validate our proposal.