This story was originally published on HackerNoon at:
https://hackernoon.com/demystifying-dimensional-modelling-unveiling-the-what-why-and-whos.
An Introduction to the art and science of dimensional modeling with relational databases
Check more stories related to data-science at:
https://hackernoon.com/c/data-science.
You can also check exclusive content about
#data-science,
#data,
#database,
#data-engineering,
#big-data,
#dimensional-modeling,
#kimball,
#relational-database, and more.
This story was written by:
@disa. Learn more about this writer by checking
@disa's about page,
and for more stories, please visit
hackernoon.com.
Dimensional modelling is a database design philosophy. It is the most widely used style of relational database. It has all the basic ingredients of a relational database i.e Primary keys, Foreign Keys and multiple tables. It’s different from your 3NF relational database majorly because of it's ease of understanding and its superior query performance.