Distributed Data Warehousing Using Web Technology: How to by R. A. Moeller

By R. A. Moeller

Flip to this publication to benefit to control mountains of data
through dispensed info warehousing options.

Show description

Read or Download Distributed Data Warehousing Using Web Technology: How to Build a More Cost-Effective and Flexible Warehouse PDF

Similar management information systems books

Inescapable Data: Harnessing the Power of Convergence

As communications, computing, and knowledge garage converge, info is changing into totally ubiquitous. .. and that alterations every thing. during this ebook, best facts administration visionaries exhibit how information transforms how you do company, the applied sciences you employ, the investments you are making, the lifestyles you reside, and the area you reside in.

Business Intelligence: The Savvy Manager's Guide

Fascinating, well timed, and specifically, helpful, Savvy publications supply IT managers the knowledge they should successfully deal with their technologists, in addition to rigorously tell enterprise choice makers, in the middle of technological revolution.

The SPSS Guide to the New Statistical Analysis of Data

This e-book is a self-teaching advisor to the SPSS for home windows computing device package deal. 'It is designed for use hand-in-hand with the recent Statistical research of knowledge through T. W. Anderson and Jeremy D. Finn, even though it can be utilized as a stand-alone guide in addition. This consultant is really easy to stick with when you consider that all systems are defined in a simple, step by step layout.

Getting Started with Oracle Event Processing 11g

Create and increase real-world situation Oracle CEP functions evaluation a distinct perception and engaging occasion pushed trip that breathes existence into Oracle occasion Processing. discover the evolution and significant features of this leading edge Oracle product in a step-by-step, development block type. full of samples and easy tutorials advanced via years of shut collaboration with professional clients and experts.

Extra resources for Distributed Data Warehousing Using Web Technology: How to Build a More Cost-Effective and Flexible Warehouse

Sample text

An integrated architecture should be developed to tie the data marts together to facilitate crossfunctional analysis and maintenance. This is, after all, only common sense: It would be wasteful and foolhardy not to adopt as many elements of the first successful implementation into the subsequent data marts in other departments. Some of the elements to be considered in an overall architecture include: ƒ Common data model ƒ Extraction tools ƒ Transformation tools ƒ Processes ƒ Data dictionary ƒ OLAP tools This raises the thorny question of the enterprise data model.

Entry costs are low, and even the full-scale distributed warehouse is dramatically less expensive than its centralized counterpart. In some instances, existing databases can even be added as is, without costly extractions and loads. This combination of flexibility and cost-effectiveness makes distributed data warehousing the preferred method for the foreseeable future. - 45 - Challenges of a Distributed Data Warehouse The distributed data warehouse is a relatively new concept. While many organizations have implemented multiple independent data marts, few have taken the next logical step of joining them together.

In Figure 2-6, a logical model/metadata exists for each specific stage of the data warehouse: source system, physical data warehouse, and data marts. In fact, each stage may have multiple sets of models/metadata if the designer is working with individual data models for each of the source systems and unique models for each data mart. Although this is a curious instance, representing one of the more unusual examples of data warehousing, data warehouse architecture needs to accommodate multiple sets of models/metadata and the mapping between them.

Download PDF sample

Rated 4.86 of 5 – based on 40 votes