News Updates Tuesday 17th Jan 2017 :
  • 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 Jan/Feb 2017 issue is 20 Jan 2017, Submit online or at editor.ijcet@inpressco.com
  • 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
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- Jan/Feb-2017 Issue

    Submission Last Date
    20 Jan 2017
  2. IJTT-March-2017
  3. IJAIE-March-2017
  4. IJCSB-March-2017
  • 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-2017 INPRESSCO® All Rights Reserved