Sunday, November 7, 2010

Datawarehouse key concepts

When I first was asked to build a BI platform, I started reading The DataWarehouse toolkit Kimball book. I must say I had almost no idea of the complexity involved in datawarehouse construction. Soon, I reached two main tips related to database modelization:

1.- model your relationships as 1-1

2.- avoid null values

Simple and powerfull. From a database model point of view, first tip allows join tables easyly and second tip gives better performance when indexes are involved. Both tips are oriented to obtain better query performance. Of course, these are more key concepts, but these two are really important.

No comments: