The Inmon approach is said to have the Hub and Spoke architecture. The primary feature of the same is the Enterprise Data Warehouse (EDW) which is maintained as a 3NF database. It is slightly different from the Operational database as it is:
1. Subject Oriented
2. Non-volatile - Data doesn't change . Soft delete is present by the use of timestamping.
3. Time variant - Maintains historical data
4. Integrated.
It does not have fact or dimensions, and has a set of functional data marts pulling data out of it.
OLTP > EDW (3N) >Datamart (3N) >OLAP Cube
The Kimball approach is said to have the Bus Architecture. It contains set of stars i.e de-normalized groups of fact and dimension tables connected via conformed dimension (dimensions common to two facts)
OLTP > Star Schema (Dimensional Model) >OLAP Cube
1. Subject Oriented
2. Non-volatile - Data doesn't change . Soft delete is present by the use of timestamping.
3. Time variant - Maintains historical data
4. Integrated.
It does not have fact or dimensions, and has a set of functional data marts pulling data out of it.
OLTP > EDW (3N) >Datamart (3N) >OLAP Cube
The Kimball approach is said to have the Bus Architecture. It contains set of stars i.e de-normalized groups of fact and dimension tables connected via conformed dimension (dimensions common to two facts)
OLTP > Star Schema (Dimensional Model) >OLAP Cube
No comments:
Post a Comment