 BI Layer |
Presents the data required for BI Analysis and Reports.The Model generally looks like the Semantic Data Mode, in the next level. |
| Semantic Data Model |
This combines presentation of the data with an indication of the meaning of the data.
Here is
Wikipedia's view and their example
|
| Conceptual Data Model |
A business user view of the data. |
|
Data Marts |
Presents the restricted sets of data required for specific Report families.
They usually have the same Dimensions and Facts structure that we find in Dimensional Models.
|
|
Dimensional Models |
Characterised by Dimensions and Facts.
Here is an example of a Generic Data Mart :-
|
|
Third Normal Form Data Warehouse |
The Third Normal Form helps ensure a Single View of the Truth.
It is usually a subset of the more comprehensive Enterprise Data Model.
This is an example of a 3NF Data Warehouse for Hotel Check-In :-
|
|
Enterprise Data Model
|
Partial or Complete |
|
Subject Area Data Models |
Pretty much essential - in other words, if you don't find one, then there is something wrong. |
|
Canonical Data Model |
Very valuable, check out
our current thinking.
Here is the current incarnation of the Canonical Data Model :-
|
|
Operational Data Stores |
Can be in a range of formats - from a simple CSV file, to an ODBC connection, to a bespoke SAP or Salesforce interface.
Here are my wife and myself on a recent holiday in Malaysia riding on an Elephant, with the "ticket to ride" (ie the ODS) and the ODS Entity :-
|
