The data model is a corporate repository ER-model (Entity-relationship model - the model "entity-relationship"), described on several levels set of interconnected entities, which are grouped by functional area and reflect the needs of the business in the analytical analysis and reporting.
General corporate data model repository is developed consistently and consists of:
General corporate data model repository is developed consistently and consists of:
- conceptual data model;
- logical data model;
- physical data model.
Conceptual Model
Conceptual model of a data warehouse is a description of the main (basic) entities and relations between them. The conceptual model is a reflection of the subject areas in which it is planned to build a data warehouse.
Logic model
Logical model extends the conceptual definitions for entities by their attributes, descriptions and restrictions, clarifies the composition of entities and relationships between them.
Physical model
Physical data model describes the implementation of a logical model of objects at the level of a specific database objects.
Comparison of models of different levels
The table below presents a comparative analysis of models of different levels.
