I am proposing a vision on how OLAP concepts could be relevant for Agentic data modeling.
This is from Kimball's book, page 301 - "Dimension Granularity and Hierarchies":
"You should generally look for opportunities to collapse or denormalize dimension hierarchies whenever possible.
Experienced data modelers often revert to the normalization techniques they’ve applied countless times in operational entity-relationship models.
These modelers often need to be reminded that normalization is absolutely appropriate to support transaction processing and ensure referential integrity. But dimensional models support analytic processing.
Normalization in the dimensional model negatively impacts the model’s twin objectives of understandability and performance.
Although normalization is not forbidden in the extract, transform, and load (ETL) system where data integrity must be ensured, it does place an additional burden on the dimension change handling subsystems."
Good quotes. Unfortunately “normalization” can be a vague term. The first relational table example in the 1970 Codd origin paper is a “star schema”. Just as relational as anything else.
Dimensional design not denormalized. Facts are 3NF, dimensions are 2NF.
Hey Donald,
You got a point on 2NF and 3NF.
I am proposing a vision on how OLAP concepts could be relevant for Agentic data modeling.
This is from Kimball's book, page 301 - "Dimension Granularity and Hierarchies":
"You should generally look for opportunities to collapse or denormalize dimension hierarchies whenever possible.
Experienced data modelers often revert to the normalization techniques they’ve applied countless times in operational entity-relationship models.
These modelers often need to be reminded that normalization is absolutely appropriate to support transaction processing and ensure referential integrity. But dimensional models support analytic processing.
Normalization in the dimensional model negatively impacts the model’s twin objectives of understandability and performance.
Although normalization is not forbidden in the extract, transform, and load (ETL) system where data integrity must be ensured, it does place an additional burden on the dimension change handling subsystems."
Good quotes. Unfortunately “normalization” can be a vague term. The first relational table example in the 1970 Codd origin paper is a “star schema”. Just as relational as anything else.