Subscribe to DSC Newsletter

Dimensional Modeling in the Age of Big Data and Hadoop

This article was written by Uli Bethke.

The full title is "Dimensional Modeling and Kimball Data Marts in the Age of Big Data and Hadoop". 

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.

This long article has the following sections:

  • Why do we need to model our data?
  • Why do we need dimensional models?
  • Data Modelling vs Dimensional Modelling
  • So why do some people claim that dimensional modelling is dead?
  • The Data Warehouse is dead Confusion
  • The Schema on Read Misunderstanding
  • Denormalization revisited. The physical aspects of the model.
  • Taking de-normalization to its full conclusion
  • Data distribution on a distributed relational database (MPP)
  • Data Distribution on Hadoop
  • Dimensional Models on Hadoop
  • Hadoop and Slowly Changing Dimensions
  • Storage evolution on Hadoop
  • The verdict. Are dimensional models and star schemas obsolete?
  • Complementary Reading on Dimensional Modelling in the Era of Big Data

To read the full original article (and to learn more information about Kimball Data Marts) click here. For more dimensional modeling related articles on DSC click here.

DSC Resources

Popular Articles

Views: 3366

Comment

You need to be a member of Data Science Central to add comments!

Join Data Science Central

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service