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.
Sunday, November 7, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment