A Data warehouse conceptual data model is nothing but a highest-level relationships between the different entities (in other word different table) in the data model.
Read:
- Star Schema model in Data Warehouse
- Snowflake Schem Model in Data Warehouse
- Step by Step Guide to Dimensional Data Modeling
- Slowly Changing Dimensions (SCD) in Data Warehouse
- Rapidly Changing Dimension in Data Warehouse
- Data Warehouse Three-tier Architecture in Details
Features of Data Warehouse Conceptual Data Model
Following are the features of conceptual data model:
- This is initial or high level relation between different entities in the data model. Conceptual model includes the important entities and the relationships among them.
- In the Data warehouse conceptual data model you will not specify any attributes to the entities.
- You also not define any primary key yet.
Schematic Representation of Data Warehouse Logical Data Model
The figure below is an example of a conceptual data model.
From the above table you can see that, data warehouse conceptual model, only high level relationship between the entities are described.
You can also read: