 From ER model to Star model: a systematic transformation approachAbid Sohail and P.D.D. Dominic International Journal of Business Information Systems, 2015, vol. 18, issue 3, 249-267 Abstract: Data warehouse is an important component of decision support systems, because it provides data of interest for analysis and decision support purposes. This data of interest is useful for analysis due to the multidimensional nature of Star model. Designing a Star model requires ample amount of time, experience, expertise and adequate knowledge of data warehouse designing steps. As an alternative to data warehouse designing steps, transformation techniques are proposed in literature. These techniques transform entity-relationship (ER) model (of online transaction process systems) to Star model. In this study, we present and evaluate a systematic approach for transformation of ER model to Star model. We prove that by using our approach, inexperienced designers can produce Star models identical to the Star models produced by experienced data warehouse designers. Also, we prove that the Star model produced by existing approaches is different from the Star model produced by our transformation approach. Keywords: decision support systems; DSS; computer-based decision aids; data warehouses; entity-relationship model; Star model; model transformation. (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:ids:ijbisy:v:18:y:2015:i:3:p:249-267 Access Statistics for this article More articles in International Journal of Business Information Systems from Inderscience Enterprises Ltd |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.