Data Modeling (DM)
Data modeling is a process to design the data model for a database to organize the data for a better management and faster access.
Data Modeling Technic
Data Modeling Technic depend on the type of application behavior for which we need to design the data model.
Data modeling is a process to design the data model for a database to organize the data for a better management and faster access.
Data Modeling Technic
Data Modeling Technic depend on the type of application behavior for which we need to design the data model.
- DM for a Transnational Application where CUD operation frequently occur this is called Relational Database modeling (Normalization / Less indexing / No partitioning )
- DM for a Reporting Application where Read operations frequently/heavily occur this is called Reporting DWH modeling (De-normalization / Good indexing / with partitioning on File group)
- DM for a Analytics Application where we need to analyze the data in multi dimension view with fast access this is called Analytics DWH modeling (Dimension Modelling / Data Vault Modelling)
- DM for a Big data Application where Data come in VVV this is called Nosql/Cloud Data Modeling (Key-Value store / Column store / Document store)
- Conceptual DM : Where we design the DM with entity and its relationship
- Logical DM : Where we design the DM with entity, attribute and attribute relationship
- Physical DM : Where we create the physical database as per logical DM
No comments:
Post a Comment