News Updates Saturday 22nd Oct 2016 :
  • Welcome to International Press Corporation, world's leading publishers, We have served more than 10000+ authors
  • Articles are invited in engineering, science, technology, management, industrial engg, biotechnology etc.
  • Paper submission last date of Sept/Oct 2016 issue is 25 Oct 2016, Submit online or at
  • Our journals are indexed in University of Regensburg Germany, Google Scholar, Cross Reference data bases
  • Applications for reviewers are invited and can be sent directly to concerned editor's mail

Design a Distributed Data Warehousing based ROLAP with Materialized Views

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

Pages : 1838-1843
Download PDF

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)



Call for Papers
  1. IJCET- Sept/Oct-2016 Issue

    Submission Last Date
    25 Oct 2016
  2. IJTT-Sept-2016
  3. IJAIE-Sept-2016
  4. IJCSB-Sept-2016
  • Inpressco Google Scholar
  • Inpressco Science Central
  • Inpressco Global impact factor
  • Inpressco aap

International Press corporation is licensed under a Creative Commons Attribution-Non Commercial NoDerivs 3.0 Unported License
©2010-2016 INPRESSCO® All Rights Reserved