Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

Data Warehouse by Mind Map: Data Warehouse
5.0 stars - 2 reviews range from 0 to 5

Data Warehouse

history

Definition

"a subject-oriented, integrated, time variant and nonvolatile collection of data used in strategic decision making", Bill Inmon 1992: Building the Data Warehouse. 1st Edition. Wiley and Sons, description, subject-oriented, integrated, time variant, nonvolatile

authors

Bill Inmon, The 10 IT People Who Mattered in the Past 40 Years (but You May Not Know Why), http://www.computerworld.com/s/article/295941/The_10_IT_People_Who_Mattered_in_the_Past_40_Years_but_You_May_Not_Know_Why_

Ralph Kimball

architecture

layers

Operational Systems

Integration Layer, ODS, Staging Area

Data Warehouse, Data Vault

Data Marts

Stategic Marts

approach

Multidimensional (wielowymiarowa), Star schema, Snowflake schema, Starflake schema

Normalized (znomarlizowana), 1NF, 2NF, 3NF, other NF

design approach

Bottom-up

Top-down

ETL

Extract

db

flat files

message queue

Transform

filter

translate

trim

calculate value

sort

join

split

lookup

aggregate

generate surrogate Id

validate

Load

db

flat files

message queue

Products

IBM InfoSpehere DataStage

Teradata Enterprise Warehouse

Oracle Data Integrator

Informatica Powercenter

SAS BI

SAP NetWeaver

Sybase IQ

Microsoft SQLServer BI