Data Modeling is simply structuring data according to the need
Quote from bsdinsight on 10 April 2025, 18:41Data Modeling is simply structuring data according to the need.
What need?
Source systems OLTP
or
Datawarehousing systems OLAPHow do you model data in OLTPs?
Use normalization.
Why?1) to reduce redundancy
2) to optimize writes/ updates from front end
3) to avoid write, update and delete anomaliesHow do model data in OLAPs?
Totally depends on use caseWhat use case?
Could be building Staging tables
Could be building Core tables
Could be building Summary tables
Could be building a dimensional modelWhy do you need to know this?
Some companies have data modeling / design rounds
and you will need to build one
Data Modeling is simply structuring data according to the need.
What need?
Source systems OLTP
or
Datawarehousing systems OLAP
How do you model data in OLTPs?
Use normalization.
Why?
1) to reduce redundancy
2) to optimize writes/ updates from front end
3) to avoid write, update and delete anomalies
How do model data in OLAPs?
Totally depends on use case
What use case?
Could be building Staging tables
Could be building Core tables
Could be building Summary tables
Could be building a dimensional model
Why do you need to know this?
Some companies have data modeling / design rounds
and you will need to build one
- You need to login to have access to uploads.
