More Web Proxy on the site http://driver.im/

research-article

A systematic approach for transformation of ER schema to dimensional schema

Authors:

Khurram Shahzad,

Abid SohailAuthors Info & Claims

FIT '09: Proceedings of the 7th International Conference on Frontiers of Information Technology

Article No.: 51, Pages 1 - 6

https://doi.org/10.1145/1838002.1838060

Published: 16 December 2009 Publication History

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.

References

[1]

Ponniah, P., Data Warehousing Fundamantal, New Jersey, June 2001

Digital Library

[2]

Ramakrishnan, R., Gehrke, J., DataBase Management Systems, 3^rd Edition, New York, 2003

Digital Library

[3]

Connolly, T., Begg, G., Database Systems, 2^nd edition, Library of congress cataloging in Publication Data, 2001.

[4]

Fred R. McFadden and Jeffrey A. Hoffer, Modern Database Management, 4^th Edition, by the Benjamin/ Cummings PublisherCompany, Inc. 1994.

Digital Library

[5]

Kimball, R., and Ross, M., The Data Warehousing Toolkit, John Wiley & Sons, 2002.

[6]

Marotta, A. and Ruggia, R., Data Warehousing Design: A Schema-transformation Approach, Proceedings of 12th SCCC, Atacama, Chile, 2002.

Digital Library

[7]

Golfarlli, M., Maio, D. and Rizzi, s., Conceptual Design of Data Warehouses from E/R Schemes, In proceeding of 31st HICSS, Hawaii, USA, 1998.

Digital Library

[8]

Moody, D. L. and Kortink, M. A. R., From Enterprise Models to Dimensional Models: A Methodology for Data Warehousing and Data Mart Design, In Proceeding. 2nd DMDW, Toronto, Canada, 2002

[9]

husemann, B., Lechtenborger, J. and Vossen, G., Conceptual Data Warehouse Design, In proceeding of DMDW'2000 Stockholm, Sweden, June 5--6, 2000

[10]

Chen, Y. T. and Hsu, P. Y., A grain preservation translation algorithm: From ER diagram to multidimensional model, in format, Sci. (2007).

Digital Library

[11]

Dov Dori, Roman Feldman, Arnon Sturm. Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques, Proceeding of the International Conference on Software- Science, Technology & Engineering (SwSTE'05).

Digital Library

[12]

Chaudhuri, S. Dayal, U. An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, 26(1): 65--74, March 1997.

Digital Library

[13]

Matteo Golfarelli, Stefano Rizzi, Lunis Cella. Beyond Data Warehousing: What's Next in Business Intelligence? In the proceeding of DOLAP' 04, 2004 Washington, DC, USA.

Digital Library

[14]

Sohail Abid, From ER to Single Star Model (ERSSM): A systematic translation approach. MSCS thesis, February 2008 CIIT, Lahore, Pakistan

[15]

Ballard, C., Farrell, M, D., Gupta, A., Mazuela, C., Vohnik, S., Dimensional Modeling: In a Business Intelligence Environment, First edition IBM 2006.

Digital Library

[16]

Karen Corral, David Schuff, Robert D St. Lousi, The impact of alternative diagrams on the accuracy of recall: A comparison of star-schema diagrams and entity-relationship diagrams, Decision Support System, Vol. 42(1), pp. 450--468, 2006.

Digital Library

[17]

M. A. Pasha, J. A. Nasir, M. K. Shahzad, Semi-star schema for managing data warehouse consistency, Proceedings of IEEE National Conference on Emerging Technology, pp. 63--66, Karachi, Pakistan.

Cited By

Cavique LCavique MSantos J(2020)Supply-Demand Matrix: A Process-Oriented Approach for Data Warehouses with Constellation SchemasTrends and Innovations in Information Systems and Technologies10.1007/978-3-030-45688-7_33(324-332)Online publication date: 18-May-2020
https://doi.org/10.1007/978-3-030-45688-7_33
Sohail ADominic PShahzad K(2016)Business process analysisInternational Journal of Business Information Systems10.1504/IJBIS.2016.07425521:2(137-161)Online publication date: 1-Jan-2016
https://dl.acm.org/doi/10.1504/IJBIS.2016.074255

Index Terms

A systematic approach for transformation of ER schema to dimensional schema
1. Information systems
  1. Data management systems
    1. Database design and models
      1. Data model extensions
    2. Information integration
      1. Data warehouses
  2. Information systems applications
    1. Decision support systems
      1. Data warehouses

Recommendations

Research on Extract, Transform and Load(ETL) in Land and Resources Star Schema Data Warehouse
ISCID '12: Proceedings of the 2012 Fifth International Symposium on Computational Intelligence and Design - Volume 01

The extract, transform and Load (ETL) tool is extracting data from multiple, heterogeneous data source, transforming data, and finally loading data into the data warehouse. It is the foundation of any data warehouse, data mining and business ...
An empirical investigation of the effects of data warehousing on decision performance

Organizations implement data warehouses to overcome the limitations of DSS by adding this database component and thereby improve decision performance. However, no empirical evidence is available to show the effects of a data warehouse (DW) on decision ...
How to Guarantee Analysis Results Coherence after Data Warehouse Schema Changes Propagation towards Data Marts?
IC3K 2014: Proceedings of the International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management - Volume 2

Data Warehouse, accompanied with Online analytical processing, is considered as the core of the modern

Decision support systems. The emergence of new analytical requirements and changes in organization business

processes push the underlying ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Other conferences

FIT '09: Proceedings of the 7th International Conference on Frontiers of Information Technology

December 2009

446 pages

ISBN:9781605586427

DOI:10.1145/1838002

Conference Chair:
Sajjad Ahmad Madani
COMSATS Institute of Information Technology, Pakistan

Copyright © 2009 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

COMSATS Institute of Information Technology

In-Cooperation

SIGAI: ACM Special Interest Group on Artificial Intelligence

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 December 2009

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

FIT '09

Sponsor:

FIT '09: 7th International Conference on Frontiers of Information Technology

December 16 - 18, 2009

Abbottabad, Pakistan

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

2
Total Citations
View Citations
198
Total Downloads

Downloads (Last 12 months)4
Downloads (Last 6 weeks)1

Reflects downloads up to 12 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Cavique LCavique MSantos J(2020)Supply-Demand Matrix: A Process-Oriented Approach for Data Warehouses with Constellation SchemasTrends and Innovations in Information Systems and Technologies10.1007/978-3-030-45688-7_33(324-332)Online publication date: 18-May-2020
https://doi.org/10.1007/978-3-030-45688-7_33
Sohail ADominic PShahzad K(2016)Business process analysisInternational Journal of Business Information Systems10.1504/IJBIS.2016.07425521:2(137-161)Online publication date: 1-Jan-2016
https://dl.acm.org/doi/10.1504/IJBIS.2016.074255

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents