Data Modeling - Data Models

1 - About

In the data warehousing environment, you can find several models.

3 - Data Model Architecture

3.1 - Hub-and-spoke

3.1.1 - Corporate Information Factory

Inmon

3.1.2 - Data Vault

Data Vault (linstedt)

3.2 - Data mart bus

Kimball Star Schema with conformed dimensions.

(1) Attributes of Dim Order which is a fact dimension can be degenerated.

3.3 - Centralized Data Warehouse Architecture

Normalized relational warehouse (3NF) (atomic/some summarized data)

4 - Layer

  • Persistent Staging Area (PSA) - Persistent Data Store (PDS)
  • Bookmark "Data Modeling - Data Models" at del.icio.us
  • Bookmark "Data Modeling - Data Models" at Digg
  • Bookmark "Data Modeling - Data Models" at Ask
  • Bookmark "Data Modeling - Data Models" at Google
  • Bookmark "Data Modeling - Data Models" at StumbleUpon
  • Bookmark "Data Modeling - Data Models" at Technorati
  • Bookmark "Data Modeling - Data Models" at Live Bookmarks
  • Bookmark "Data Modeling - Data Models" at Yahoo! Myweb
  • Bookmark "Data Modeling - Data Models" at Facebook
  • Bookmark "Data Modeling - Data Models" at Yahoo! Bookmarks
  • Bookmark "Data Modeling - Data Models" at Twitter
  • Bookmark "Data Modeling - Data Models" at myAOL
data_modeling/data_model_datawarehousing.txt ยท Last modified: 2017/01/20 21:00 by gerardnico