Adaotubg data modeling techniques for data warehouse design

摘要

Since a data warehouse's primary function is to facilitate end-user analysis and decision making, the method in which the data warehouse is modeled is critical to its success. Two modeling methods are explored, the entity relationship(ER) model and the dimensional model. A review of the literature reveals ways of trying to work Around the limitations of each model, including the use of hybrid Models. Since hybrids themselves create limitations in terms of Available tools and data warehouse robustness, however, this Study concludes by recommending a combination of the ER and Dimensional models, not as a hybrid but as a process.