A systematic approach for transformation of ER Schema to dimensional schema
2009 (English)In: Proceedings of the 6th International Conference on Frontiers of Information Technology, FIT '09, 2009, 1838060- p.Conference paper (Refereed)
Development of Star model for data warehouse (DW) 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 used. These techniques transform ER model (of relational OLTP) to Star model/s. In this study, we present and evaluate a systematic approach for transformation of ER model to Star model. Based on an experiment, we prove that, by using our approach, inexperienced designers can produce Star models identical to the star models produced by experienced data warehouse designers.
Place, publisher, year, edition, pages
2009. 1838060- p.
Computer-based decision aids, Data warehouse, Decision support systems, Er model, Star model
Computer and Information Science
IdentifiersURN: urn:nbn:se:kth:diva-152421DOI: 10.1145/1838002.1838060ScopusID: 2-s2.0-77956296773ISBN: 978-160558642-7OAI: oai:DiVA.org:kth-152421DiVA: diva2:752023
6th International Conference on Frontiers of Information Technology, FIT '09, 16 December 2009 through 18 December 2009, Abbottabad, Pakistan
QC 201410022014-10-022014-09-262014-10-02Bibliographically approved