Data Warehouse

Get Started. It's Free
or sign up with your email address
Rocket clouds
Data Warehouse by Mind Map: Data Warehouse

1. history

1.1. Definition

1.1.1. "a subject-oriented, integrated, time variant and nonvolatile collection of data used in strategic decision making"

1.1.1.1. Bill Inmon 1992: Building the Data Warehouse. 1st Edition. Wiley and Sons

1.1.1.2. description

1.1.1.2.1. subject-oriented

1.1.1.2.2. integrated

1.1.1.2.3. time variant

1.1.1.2.4. nonvolatile

1.2. authors

1.2.1. Bill Inmon

1.2.1.1. The 10 IT People Who Mattered in the Past 40 Years (but You May Not Know Why)

1.2.1.1.1. http://www.computerworld.com/s/article/295941/The_10_IT_People_Who_Mattered_in_the_Past_40_Years_but_You_May_Not_Know_Why_

1.2.2. Ralph Kimball

2. architecture

2.1. layers

2.1.1. Operational Systems

2.1.2. Integration Layer

2.1.2.1. ODS

2.1.2.2. Staging Area

2.1.3. Data Warehouse

2.1.3.1. Data Vault

2.1.4. Data Marts

2.1.5. Stategic Marts

2.2. approach

2.2.1. Multidimensional (wielowymiarowa)

2.2.1.1. Star schema

2.2.1.2. Snowflake schema

2.2.1.3. Starflake schema

2.2.2. Normalized (znomarlizowana)

2.2.2.1. 1NF

2.2.2.2. 2NF

2.2.2.3. 3NF

2.2.2.4. other NF

3. design approach

3.1. Bottom-up

3.2. Top-down

4. ETL

4.1. Extract

4.1.1. db

4.1.2. flat files

4.1.3. message queue

4.2. Transform

4.2.1. filter

4.2.2. translate

4.2.3. trim

4.2.4. calculate value

4.2.5. sort

4.2.6. join

4.2.7. split

4.2.8. lookup

4.2.9. aggregate

4.2.10. generate surrogate Id

4.2.11. validate

4.3. Load

4.3.1. db

4.3.2. flat files

4.3.3. message queue

4.4. Products

4.4.1. IBM InfoSpehere DataStage

4.4.2. Teradata Enterprise Warehouse

4.4.3. Oracle Data Integrator

4.4.4. Informatica Powercenter

4.4.5. SAS BI

4.4.6. SAP NetWeaver

4.4.7. Sybase IQ

4.4.8. Microsoft SQLServer BI