From ER Models to Dimensional Models Part II: Advanced Design Issues
Daniel L. Moody, Mark A. R. Kortink · 2003
The first article in this series, which appeared in the Summer 2003 issue of the Journal of Business Intelligence (Moody and Kortink, 2003), described how to design a set of star schemas based on a data model represented in Entity Relationship (ER) form. However as in most design problems, there are many exceptions, special cases and alternatives that arise in practice. In this article, we discuss some advanced design issues that need to be considered. These include: