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.