1145
Chapter 51: Business Intelligence Database Design
51
Because the business has an intimate relationship with the data and works with it on a
daily basis, the decision as to what goes into a data warehouse should be made by it or with
it. Not using its knowledge could result in a data warehouse that contains inaccurate or
irrelevant data. As a result, time and money could be wasted building a solution that may
never be used.FIGURE 51-1
The diagram view of the AdventureWorks data warehouse database shows one fact table
and several dimensions resembling a star.Surrogate Keys
The foundation of any star schema design is the foreign keys that exist between the fact
and dimension tables. However, you should not use the primary and foreign keys that exist
in the OLTP database or databases that act as the source for your data warehouse. Instead,c51.indd 1145c51.indd 1145 7/31/2012 10:28:41 AM7/31/2012 10:28:41 AM
http://www.it-ebooks.info