Skip to content

DW Architecture: The Enterprise Data Warehouse

September 16, 2013

The enterprise data warehouse (EDW) store the history of the enterprise. This history is commonly stored in the form of transactional and snapshot fact tables; also, dimension tables are added to give context to the different elements of the enterprise history. This is the ever growing part of the Data Warehouse.

Since the structure of the EDW is, mostly, facts and dimensions tables, it is considered redundant or denormalized. The focus is not on transactions speed, but on queries respond time.

The data that arrive to the EDW is extract from different sources systems, verified again the master data, transformed to fit the structure and requirement of the data warehouse and loaded in the EDW.

The EDW is mostly used by Analysts and Researchers in their quest for new insights or trends. Also, it is the data source of the data marts.

 

Read Further

The Data Warehouse Architecture

 

Advertisements

From → DW Architecture

One Comment

Trackbacks & Pingbacks

  1. The Data Warehouse Architecture | ARBIME

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: