Data Warehousing Community Forum
February 09, 2012, 01:05:35 pm

Pages: [1]   Go Down
  Print  
Author Topic: Centralized Data Warehouse  (Read 940 times)
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« on: August 24, 2007, 10:43:47 am »

Friends,

Define Centralized Data Warehouse ?
How this is different from Data Warehouse?
Logged

If most people said what’s on their minds, they’d be speechless.
Arvind
DW Apprentice
**

Reputation: +10/-0
Offline Offline

Posts: 78


View Profile
« Reply #1 on: September 07, 2007, 12:00:57 pm »

The centralized data warehouse is a single physical database that contains all of the data for a specific functional area, department, division, or enterprise.

Centralized Data Warehouses are often selected where there is a common need for informational data and there are large numbers of end-users already connected to a central computer or network.

A Centralized Data Warehouse may contain data for any specific period of time. Usually,  Centralized Data Warehouses contain data from multiple operational systems.

Centralized Data Warehouses are real. The data stored in the data warehouse is accessible from one place and must be loaded and maintained on a regular basis. Normally, data warehouses are built around advanced RDBMs or some form of multi-dimensional informational database server.

Please make corrections if any missing  Wink-
Logged

regards,
Arvind
mrinal
DW Fresher
*

Reputation: +8/-0
Offline Offline

Posts: 23


World is Mine


View Profile
« Reply #2 on: December 04, 2008, 04:25:00 pm »

A Centralized Data Warehouse is a data warehousing implementation wherein a single data warehouse serves the needs of several separate business unites simultaneously using a single data model that spans the needs of multiple business divisions.
Companies can have the option to have several data warehouses in different locations. These data warehouses communication with each other and send, extracts, transforms and loads data for statistical analysis.
Data security is a critical issue in data warehouses from several locations trying to send and receive data and constantly make contact with each other. Communication lines can be open to sniffers and malicious hackers and crackers may be able to steal important information and breach privacy. Securing a network is an expensive activity so companies will have to spend more on buying appropriate technology measures.
Having a centralized data warehouse has its own advantages. The company will have to invest only a central IT team. The central team will be responsible for defining and publishing corporate dimensions. This is can especially true if the company has multiple lines of business to be combined in one robust framework. The team is also responsible for providing cross divisional applications. The need to purchase to software and database tools will only be for the central data warehouse and it can be fairly easy to implement cross divisional applications.
Logged
alexa007
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 17


View Profile
« Reply #3 on: September 19, 2011, 12:10:39 pm »

A Centralized Data Warehouse is implementation of Data Warehouse wherein a single data warehouse serves the needs of several businesses unites simultaneously using a single data model that spans the needs of multiple business divisions.


________________________________
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: