Dimensional Modeling and Kimball Data Marts in the Age of Big Data and Hadoop
Update 29-May-2018: The purpose of this article is threefold (1) Show that we will always need a data model (either done by humans or machines) (2) Show that physical modelling is not the same as logical modelling. In fact it is very different and depends on the underlying technology. We need both though. I illustrated ...
Read MoreIntroduction to star schemas and dimensional modeling concepts.
I recently came across two excellent papers that give an introduction to star schemas and dimensional modeling. The two papers have a unique anlgle in that they apply a rule based approach to transform transactional ER models to dimensional models. In the words of the authors: “An ER model can be transformed into a set ...
Read More