A Data warehouse logical data model describes model in more detail compared to the Data Warehouse conceptual data model. A data warehouse logical data model describes the data in as much detail as possible, this model does not describe how the model is implemented.
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 Logical Data Model
Following are the features of conceptual data model:
- This model includes all entities in the model and relationships among them.
- You should specify the attributes for each entities in the model
- You should also specify the primary key (if database supports) at this stage
- Foreign keys are also specified. Primary and foreign keys are used to define the relation between the entities
- Normalization occurs at this level. You have to normalize the table in case if that is required during logical model design
Schematic Representation of Data Warehouse Logical Data Model
The figure below is an example of a logical data model:
From the above table you can see that, data warehouse logical model describes the entities as much as possible.
You can also read: