A systematic approach for transformation of ER schema to dimensional schema

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.

[1]  Karen Corral,et al.  The impact of alternative diagrams on the accuracy of recall: A comparison of star-schema diagrams and entity-relationship diagrams , 2006, Decis. Support Syst..

[2]  Adriana Marotta,et al.  Data warehouse design: a schema-transformation approach , 2002, 12th International Conference of the Chilean Computer Science Society, 2002. Proceedings..

[3]  Amit Gupta,et al.  Dimensional Modeling: In a Business Intelligence Environment , 2006 .

[4]  Dov Dori,et al.  Transforming an operational system model to a data warehouse model: a survey of techniques , 2005, IEEE International Conference on Software - Science, Technology & Engineering (SwSTE'05).

[5]  Gottfried Vossen,et al.  Conceptual Data Warehouse Design , 2000 .

[6]  Daniel L. Moody,et al.  From enterprise models to dimensional models: a methodology for data warehouse and data mart design , 2000, DMDW.

[7]  Paulraj Ponniah,et al.  Data Warehousing Fundamentals , 2001 .

[8]  Fred R. McFadden,et al.  Modern Database Management (7th Edition) , 2004 .

[9]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[10]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[11]  Paulraj Ponniah,et al.  Data warehousing fundamentals : a comprehensive guide for IT professionals , 2001 .

[12]  Ping-Yu Hsu,et al.  A grain preservation translation algorithm: From ER diagram to multidimensional model , 2007, Inf. Sci..

[13]  Matteo Golfarelli,et al.  Beyond data warehousing: what's next in business intelligence? , 2004, DOLAP '04.

[14]  Fred R. McFadden,et al.  Modern database management (4. ed.) , 1994 .

[15]  Raghu Ramakrishnan,et al.  Database Management Systems , 1976 .