A systematic approach for transformation of ER schema to dimensional schema

Authors:
Khurram Shahzad;Abid Sohail
Affiliations:
Royal Institute of Technology & Stockholm University, SE, Kista, Stockholm, Sweden;COMSATS Institute of Information Technology, Lahore, Pakistan
Venue:
Proceedings of the 7th International Conference on Frontiers of Information Technology
Year:
2009

Citing 11
Cited 0

Modern database management (4th ed.)

Modern database management (4th ed.)
An overview of data warehousing and OLAP technology

ACM SIGMOD Record
Data Warehousing Fundamentals

Data Warehousing Fundamentals
Database Management Systems

Database Management Systems
Conceptual Design of Data Warehouses from E/R Schema

HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
Data Warehouse Design: A Schema-Transformation Approach

SCCC '02 Proceedings of the XII International Conference of the Chilean Computer Science Society
Beyond data warehousing: what's next in business intelligence?

Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques

SWSTE '05 Proceedings of the IEEE International Conference on Software - Science, Technology & Engineering
Dimensional Modeling: In a Business Intelligence Environment

Dimensional Modeling: In a Business Intelligence Environment
The impact of alternative diagrams on the accuracy of recall: a comparison of star-schema diagrams and entity-relationship diagrams

Decision Support Systems
A grain preservation translation algorithm: From ER diagram to multidimensional model

Information Sciences: an International Journal

Quantified Score

Hi-index	0.01

Visualization

Abstract

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.