The distributed data warehouse
This presentation is the property of its rightful owner.
Sponsored Links
1 / 8

The Distributed Data Warehouse PowerPoint PPT Presentation


  • 109 Views
  • Uploaded on
  • Presentation posted in: General

The Distributed Data Warehouse. Types of Distributed Data Warehouse . Business is distributed geographically or over multiple, differing product lines. The data warehouse environment will hold a lot of data, and the volume of data will be distributed over multiple processors.

Download Presentation

The Distributed Data Warehouse

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


The distributed data warehouse

The Distributed Data Warehouse


Types of distributed data warehouse

Types of Distributed Data Warehouse

  • Business is distributed geographically or over multiple, differing product lines.

  • The data warehouse environment will hold a lot of data, and the volume of data will be distributed over multiple processors.

  • The data warehouse environment grows up in a uncoordinated manner-first one data warehouse appears, then another


Concerns for each type of data warehouse

Concerns for each type of Data Warehouse

  • The Local Data Warehouses

  • The Global Data Warehouses

  • Intersection of Global and Local data

  • Redundancy

  • Access of Local and Global Data

  • The Technologically Distributed Data Warehouse

  • The Independently Evolving Distributed Data Warehouse


The nature of the development efforts

The Nature of the Development Efforts

  • Four possible meaning to “multiple groups building the data warehouse”

    • Completely unintegrated lines of business each with their own data warehouse

    • The same data warehouse but with distributed parts

    • Different levels of data within the same data warehouse

    • Different non-distributed parts of the detailed level of the data warehouse


Distributed data warehouse development

Distributed Data Warehouse Development

  • Coordinating Development across Distributed Locations

  • The Corporate Data Model – Distributed

  • Meta data in the Distributed Warehouse


Building the warehouse on multiple levels

Building the Warehouse on Multiple Levels

  • Why using multiple levels ?

  • What is advantage of multi levels ?

  • Example


Multiple groups building the current level of detail

Multiple Groups Building the Current Level of Detail

  • Different Requirements at different levels

  • Other types of detailed data


Multiple platforms for common detail data

Multiple Platforms for Common Detail Data

  • What is multiple platforms ?

  • Why using multiple platforms ?

  • What is advantage of multi platforms ?


  • Login