Data Modeling Types
Conceptual Data Modeling
Logical Data Modeling
Physical Data Modeling
Dimensional Data Modeling
Conceptual Data Modeling
Conceptual data model includes all major entities and relationships and does not contain much detailed level of information about attributes and is often used in the INITIAL PLANNING PHASE
Conceptual data model is created by gathering business requirements from various sources like business documents, discussion with functional teams, business analysts, smart management experts and end users who do the reporting on the database. Data modelers create conceptual data model and forward that model to functional team for their review.
Conceptual data modeling gives an idea to the functional and technical team about how business requirements would be projected in the logical data model.
Logical Data Modeling
This is the actual implementation and extension of a conceptual data model. Logical data model includes all required entities, attributes, key groups, and relationships that represent business information and define business rules.
Physical Data Modeling
Physical data model includes all required tables, columns, relationships, database properties for the physical implementation of databases. Database performance, indexing strategy, physical storage and demoralization are important parameters of a physical model.
Dimensional Data Modeling
Dimension model consists of fact and dimension tables
It is an approach to develop the schema DB designs
