Web site domain - What Is a Star Schema? The most effective
What Is a Star Schema? The most effective approach for a data warehouse database model (using dimensions and facts) is called a star schema. Figure 7-2 shows a simple star schema for the REVIEW fact table shown in Figure 7-1. Figure 7-2: The REVIEW table fact-dimensional structure. A more simplistic equivalent diagram to that of Figure 7-2 is shown by the star schema structure in Figure 7-3. Review review_id customer_id (FK) publication_id (FK) author_id (FK) publisher_id (FK) review_date text Customer customer_id customer address phone email credit_card_type credit_card# credit_card_expiry Author author_id author Publisher publisher_id publisher Publication publication_id title 176 Chapter 7
In case you need quality webspace to host and run your web applications, try our personal web hosting services.