Dimensional Modeling and Kimball Data Marts in the Age of Big Data and Hadoop

Uli Bethke Big Data, Business Intelligence, Data Warehouse, Dimensional Modeling

Is dimensional modeling dead? Before I give you an answer to this question let's take a step back and first have a look at what we mean by dimensional data modelling. Why do we need to model our data? Contrary to a common misunderstanding, it is not the only purpose of data models to serve as an ER diagram for ...

Introduction to star schemas and dimensional modeling concepts.

Uli Bethke Data Warehousing Books, Dimensional Modeling, DW Design

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 of dimensional models by a ...