From ER model to Star model: a systematic transformation approach Online publication date: Sat, 28-Mar-2015
by Abid Sohail; P.D.D. Dominic
International Journal of Business Information Systems (IJBIS), Vol. 18, No. 3, 2015
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.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Information Systems (IJBIS):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook