News Updates Tuesday 13th Nov 2018 :
  • Welcome to INPRESSCO, 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 Nov/Dec 2018 extended to 10 Nov 2018, Submit online or at editor.ijcet@inpressco.com
  • Our journals are indexed in NAAS, University of Regensburg Germany, Google Scholar, Cross Ref etc.
  • DOI is given to all articles

Design a Distributed Data Warehousing based ROLAP with Materialized Views


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

Pages : 1838-1843
Download PDF
Abstract

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- Nov/Dec 2018 Issue

    Submission Last Date
    15 Nov
  2. DOI is given to all articles
  3. Current Issue
  4. IJTT-Dec-2018
  5. IJAIE-Dec-2018
  6. IJCSB-Dec-2018
  • 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-2018 INPRESSCO® All Rights Reserved