<P> In computing , the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts . The star schema consists of one or more fact tables referencing any number of dimension tables . The star schema is an important special case of the snowflake schema , and is more effective for handling simpler queries . </P>
<P> In computing , the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts . The star schema consists of one or more fact tables referencing any number of dimension tables . The star schema is an important special case of the snowflake schema , and is more effective for handling simpler queries . </P>
relation between fact table and dimension table in star schema
relation between fact table and dimension table in star schema
one or more fact tables referencing any number of dimension tables
one or more fact tables referencing any number of dimension tables