Yahoo web space - Try It Out Analyzing a Data Warehouse Database
Try It Out Analyzing a Data Warehouse Database Model Create a simple analytical level data warehouse database model, for the same Web site, as shown in Figure 9-19. Once again, use a simple approach for a simple problem: 1. Identify dimensions (static stuff). 2. Identify facts (dynamic stuff). 3. Establish simple relationships. 4. Create basic fields within each table. How It Works All the detail was covered for the Try It Out section discussed for the OLTP database model. All this Try It Out needs is a basic picture of the data warehouse database model, as shown in Figure 9-29. Figure 9-29: A basic data warehouse ERD business rules database model. musician name phone email instruments skills band name founding_date genres shows location address directions phone show_date show_times Advertisement ad_date ad_text ad_phone ad_email ad_requirements discography cd_name release_date price merchandise type price 252 Chapter 9
Visit our web design programs services for an affordable and reliable webhost to suit all your needs.