Answer Posted / Yatendra Kumar Nagar
Star Schema is a simplified data modeling approach used in database design. It consists of a central fact table surrounded by multiple dimension tables, with each dimension table containing attributes (or columns) that describe the facts stored in the fact table.nnThe star schema facilitates efficient querying by minimizing joins and optimizing performance for reporting purposes. However, it may not be as flexible as other data models like the snowflake or galaxy schema when dealing with complex relationships between dimensions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers