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 © 2017 erwin Inc.
All rights reserved.
|
|