When building a Data Warehouse, one person favors Snowflake Schema, the other Star Schema, another one wants to build an OLAP cube directly and you end up with lot of statements like "a data model is build that way" but no explanation why. In this book, we want to highlight the facts behind so YOU can decide rather than being pulled forth and back by different opinions.
- Basics of a Data Warehouse
- What is so special about a Star Schema?
- Common Solutions
- Surrogate vs. Natural keys
- Performance Considerations
- Tuning the EndUser Queries
- DWH Architectures
