![Previous Topic: Star Schema Design](574.png)
![Next Topic: Fact Table](573.png)
Creating Models › Creating a Dimensional Model › Dimensional Modeling › Characteristics of a Star Schema
Characteristics of a Star Schema
The star schema is extremely suitable for data warehouse database design because of the following characteristics:
- Creates a denormalized database that can quickly provide query responses.
- Provides a flexible design that can be changed easily or added to throughout the development cycle, and as the database grows.
- Provides a parallel in design to how end users typically think of and use the data.
- Reduces the complexity of metadata for both developers and end users.
Copyright © 2013 CA.
All rights reserved.
![Previous Topic: Star Schema Design](574.png) ![Next Topic: Fact Table](573.png)
|
|