Author : Akeela M. Al-Atroshi and Fared Mahmood Abdullah

growing amounts of data in different database formats. whether these companies need to understand the effectiveness of their marketing efforts and quickly maintain the large volumes of data created each day. These challenges require a well-defined database system and data warehouse that can bring together disparate data with different dimensionality and granularity. The aim of this study is to design distributed data warehouse based on relational OLAP with materialize views for the purposes of analysis. In order to achieve this objective, the current study adopted a case study approach, including the application of the proposed system in General Company for the pharmaceutical industry. The study came out a set of conclusions of the most important is Data warehouse considered the most suited approach of Information Integration to build a Decision Support System for the business intelligence scenario. The implementation shows that the system proposed provides the effective tools to retrieve data through the: generate reports or query the data on line, and building data cube.

Keywords: Distributed data warehouse, Materialize views , ROLAP, Rollup and Drill down, Slice and Dice operations

Article published in International Journal of Current  Engineering  and Technology, Vol.3,No.5(Dec- 2013)