Figure 7-3: (Web server logs) The REVIEW fact-dimensional structure is a
Figure 7-3: The REVIEW fact-dimensional structure is a star schema. A star schema contains a single fact table plus a number of small dimensional tables. If there is more than one fact table, effectively there is more than one star schema. Fact tables contain transactional records, which over a period of time can come to contain very large numbers of records. Dimension tables on the other hand remain relatively constant in record numbers. The objective is to enhance SQL query join performance, where joins are executed between a single fact table and multiple dimensions, all on a single hierarchical level. So, a star schema is a single, very large, very changeable, fact table, connected directly to a single layer of multiple, static-sized dimensional tables. Author Book Publisher Customer One-To-Many Relationship Review 177 Understanding Data Warehouse Database Modeling
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.